Informatica Developer Interview Questions

653 informatica developer interview questions shared by candidates

All scenario based questions not a single straight forward question. Year wise sales data to be loaded in the target , load only positive sales data. If a source file has parent child relationship how will you load each file for different parents. Interview was very tough as interviewer was expecting answers in detail.
avatar

Specialist - Informatica

Interviewed at Accenture

3.7
Jul 10, 2021

All scenario based questions not a single straight forward question. Year wise sales data to be loaded in the target , load only positive sales data. If a source file has parent child relationship how will you load each file for different parents. Interview was very tough as interviewer was expecting answers in detail.

1) Three session are used, if session 1 completed session 2 has to start and once session 2 completed session 3 has to start. It should be sequential. 2) how do you compare two files in unix. 3) mechanism how diff command works. 4) 3 i/p used say A B C in aggregator, and the o/p should be as A & B, B & C, C & A. How do you design the mapping. 5) In Sorter transformation 10 i/p is used, if group by port is not marked, what would be the o/p.
avatar

Informatica Developer

Interviewed at Cognizant

3.9
May 14, 2016

1) Three session are used, if session 1 completed session 2 has to start and once session 2 completed session 3 has to start. It should be sequential. 2) how do you compare two files in unix. 3) mechanism how diff command works. 4) 3 i/p used say A B C in aggregator, and the o/p should be as A & B, B & C, C & A. How do you design the mapping. 5) In Sorter transformation 10 i/p is used, if group by port is not marked, what would be the o/p.

Viewing 281 - 290 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 653 interview questions and reports from Informatica developer interviews. Prepare for your interview. Get hired. Love your job.