Duplicate check, null check , primary key
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
Employee tables and salary tables. Fetch it according to row number. Highest salary etc.
What is staging layer ?
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?
Mostly about hadoop, spark, hive, sql.
cuantos años de experiencia tenes con la tecnología?
A lot of text book questions. If you are in DW, read Ralph Kimball and you should be good.
interview went well and got offer as contractor in their client location - Richmond, VA. worked around 1 year time ..but Systems in Motion's not paid me around $18,000 dollors
technical skills, career goals, salary, relocation
A data related problem was presented and I was asked to explain how I would solve it.
Viewing 561 - 570 interview questions