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 Analyst Interview Questions
71 etl testing analyst 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
See Interview Questions for Similar Jobs
Etl TesterEtl Test Analyst 4 To 6 YrsEtl Testing With SsisEtl Testing Etl TesterEtl Test Analyst 24years Etl TestingTest Data ManagerTest Data ManagementEtl & Sql Database TestingEtl Sql Database TestingData Analyst Sas ProgrammerData Warehouse Etl TestingBusiness Objects Developer Data AnalystDatabase TestingSql Data AnalystSoftware Testing AnalystAb Initio DeveloperBig Data Manager