Informatica scenarios were given to solve and mainly focused on Caches nd lookups.
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
HR does not update you even weeks after attending the interview. But you keep getting calls for the same role. Amateur recruiters and disconnected process
SCD Types | Conditions in Router Types of LKP Types of Caches How did you optimise the performance? Listagg Set Operators Union and Union All results for scenario How to get non matching records? Types of JOIN Cross join count Analytics Functions SP vs Function Where did you use it in your project? How you design ETL Mapping? How to replace all words in a file in UNIX? Types of Schema Facts and Dimensions Documents prepared in your project Have prepraed LLD/HLD Scenario for LIKE Operator Prmary vs Unique Key How many nulls can unique key take? Subquerry vs Corelated Diff Rank Trans and USE Why you use Primary key in SCD 2? Parameters vs Variables Diff Types of threads generated in your mapping?
How you populate the target table?
What is data.
Stages of ETL
SQL Questions-> Functions, Join, Subqueries DWH Question Project management
Previous experience
Etl transformations, scd
Got selected
Viewing 521 - 530 interview questions