DWH Concepts, ETL Techniques, Performance tuning and others.
Informatica Etl Developer Interview Questions
728 informatica etl developer interview questions shared by candidates
-Analytical Sql queries -General sql questions -Perfomance tuning -ETL scenario qeustoin.
Describe Yourself
Questions related to database modelling
Remove duplicates in SQL, SCD type 2 flow, Dynamic lookup, Department wise highest salary query in SQL, How to consider list of files in Informatica PC
SQL scenario based queries and unix
Basic Informatica concepts, PLSQL, UNIX
This is a written exam with no multiple-choice or true/false questions. there were very basic-advanced T-SQL development questions - like text-book questions - dmvs, indexing, keys, define a relational db… Nothing to do with the job requirements- 0 ETL or BI questions. They asked 2-3 questions where you will need to revise and create code.
Tell me about your project
Informatica scenario based questions and data warehousing concept
Viewing 481 - 490 interview questions