about ETL basics and process and previous experience
Informatica Etl Developer Interview Questions
728 informatica etl developer interview questions shared by candidates
If you have a list of data that includes negative and positive values (I.E. -10, -1, 10, -20, 20), how do I switch the signs of the those values?
A stupid case is given. They give same case to everyone. There is data of some bass electronic goods selling company now you have to design data mart, complete architecture, reports design, analytics report design, granularity of data. These guys are so stubborn with their cases, all of them have crammed that solution and expect the same from the candidate. They are not going to ask you anything apart from the questions and solutions they have crammed.
This was over two years ago, so it's hard to remember a lot of details beyond my impression above (see "Describe the Interview Process") that they were not screening adequately, or at the very least, giving me softball questions.
How to implement scd2 using informatica tool?
Overall experience and previous project details
Informatica questions , DT Studio questions, personality quiz, questions abt lookup , update strategy , DT studio- serializer , parser etc
simple transformations in informatica and some SQL questions
How can the mapping be fine-tuned in ETL?
Are you willing to relocate to Cincinnati, OH? If so, what is the reason for your relocation
Viewing 21 - 30 interview questions