Duplicate check, null check , primary key
Etl Engineer Interview Questions
1,581 etl engineer 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?
Left outer join with constrain on right table, how it will behave.
Explain scd type 2 and find duplicates
Any of the questions on the "Online Assesment" were pretty difficult. Many very mathematical/quantitative/anaytical.
Describe a time when you disagreed with your manager and what did you do about it.
Tell us a time when you had to give bad news to a manager
Describe a time when you had a conflict with your supervisor and you thought they were in the wrong.
Viewing 511 - 520 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant