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
what all the set operations available in SQL
How do you evaluate the job in Unix . Test cases for running the job
Interview process was Moderate, Panel was friendly
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 )
what are Joins, group by, DWH
ETL Concepts, SQL, Informatica were the topics
Viewing 71 - 80 interview questions