All etl testing related questions
Senior Etl Developer Interview Questions
1,581 senior etl developer interview questions shared by candidates
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.
project explanation and compensation details ?
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
Tell me about a time when you made a mistake.
How can we update a record in target table without using Update strategy?
Viewing 231 - 240 interview questions