what tool did you use for ETL procedure
Informatica Etl Developer Interview Questions
208 informatica etl developer interview questions shared by candidates
Scenario based questions are asked
What is the difference between connected and unconnected lookup?
flat file and Joiner ,active lookup etc
Etl basics , sql scenarios and Informatica scenarios
explain about current project overview?
I got selected for both the technical rounds where the interviewer asked me about sorting algorithms, Normalization in database, few OS questions like diff b/w process and thread, about kernel, scheduling algorithms and Oops concepts (about abstract class, inheritance, encapsulation)
Describe a situation when all your colleagues were against an approach suggested by you. How you tackle that?
Olap vs oltp.. Start snowflake.. Different type of dimension table.. View vs mv.. Proc vs fucn
Data flow
Viewing 181 - 190 interview questions