ETL process and sql query writing
Etl Engineer Interview Questions
1,581 etl engineer interview questions shared by candidates
Lookup types and lookup cache
Q. Most questions about what could be the result from two table data presented before us . Minus , Left outer Join ( Duplicate Twist ) , Union vs Union ALL , ROW_NUMBER () ,Rank () , DENSE_RANK() ..etc , Q.Which Architecture do you use in your Project ( STAR vs SnowFlake - Why SF is not Good ?) Q. What is Surrogate Key Q. How did you validate Data from Stage to EDW - Example Q. What is your Validation Strategy on Large data set Q. SCD Type - Example pls
Read - DESCRIBE THE INTERVIEW PROCESS SECTION
-Analytical Sql queries -General sql questions -Perfomance tuning -ETL scenario qeustoin.
SQL scenario based queries and unix
Query for finding duplicated records
Oracle queries about aggregate function
Tell me about a time when you were doing a group project and it failed. How did you respond?
Tell me about a time when you showed resiliency
Viewing 1031 - 1040 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