SCD types, sql qry - intersect, union , Infa - LKP transformation
Etl Engineer Interview Questions
1,581 etl engineer interview questions shared by candidates
Explain scd type 2 and find duplicates
Brief about myself and technical questions,
What's DDL and DML :') (yah, for a 9 year experienced candidate)
Normal SQL questions ETL concepts Technologies you have worked
All related to SQL queries
Sql based queries complexity is medium to high
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?
Have you worked Cassandra?
Scenario based questions related to ETL and SQL. Questions on PL/SQL packages, Basics of Unix scripting Core concepts of Data warehousing.
Viewing 471 - 480 interview questions