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
types of facts ( here I assumed fact tables )
how to remove duplicates and how to find duplicates
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