Skip to contentSkip to footer

Informatica Interview Questions

Salaries
Interviews

294 informatica 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.5★
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.

how many mapping you have done ? what kinds of mapping ? how complex mapping you have done? how do cleanse the data facts and dimensions tables procedure,package and functions used in previous projects explain with business scenerios few more questions from both
avatar

Oracle Developer With Informatica

Interviewed at BBVA

3.9★
Sep 18, 2017

how many mapping you have done ? what kinds of mapping ? how complex mapping you have done? how do cleanse the data facts and dimensions tables procedure,package and functions used in previous projects explain with business scenerios few more questions from both

Viewing 101 - 110 interview questions

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