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
Etl Testing Interview Questions
71 etl testing interview questions shared by candidates
ETL tool related questions if you have hands-on
Etl basic knowledge Sql Unix
Apart from answering the question they also check your cognitive skills
how to remove duplicates and how to find duplicates
types of facts ( here I assumed fact tables )
what are Joins, group by, DWH
How to calculate nth max salary
How many layers you have invloved in ETL testing?
Validating a Fact table ,scenarios wrt current project
Viewing 51 - 60 interview questions