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 tool related questions if you have hands-on
Interview process was Moderate, Panel was friendly
what all the set operations available in SQL
How do you evaluate the job in Unix . Test cases for running the job
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
confusing questions on Java- multi constructor program and output of java program. static final Abstract keyword
Viewing 71 - 80 interview questions