Tell me about a time you made a mistake.
Etl Engineer Interview Questions
1,579 etl engineer interview questions shared by candidates
- Couple of related to SQL - UI/Web testing (now this is not a good question to ask to a DWH/ETL tester, you can't ask a fish how to fly) - Rest were puzzles about temple-flowers, sheep-tiger, bucket-water.
What is the most complex SSIS package you designed?
They asked a lot about databases and experience with ETL projects
Discussion started with ETL flow to SQL Queries. Testing questions were : difference between star and snowflax, ETL flow in current project. SQL questions were : Set operators, Difference between union and union all, Delete,drop and truncate. Asked to write queries on given scenarios. scenarios were based on Sub string, In string, Replace, Translate, Minus. Gave 3 select statements and asked how it works. group by and having function flow
Questions related to my role that is tester. Tools used in the previous projects.
on basic ETL concepts Data Warehousing concepts
Explain about Previous project experience
All etl testing related questions
Joins and join types. Data warehouse concepts. What is OLAP and OLTP. SQL Quires like Duplicate records. Case and Decode. Rank and Dense Rank. Difference between SCDtype1,SCD type2,SCDtype3.
Viewing 241 - 250 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