AWS objective type questions
Data Warehouse Engineer Interview Questions
92 data warehouse engineer interview questions shared by candidates
SQL- usage of aggregate functions, Rank, duplicate removals etc
Questions in 1st round - live coding sql - joins query, analytic function query, duplicate rows from table... etc live coding python - Compare words for 2 lists . Questions in 2nd round - ETL/data warehousing concepts, dimension modelling, project..etc Questions in 3rd round - basic discussion over project and work timings and cultural fit
What are the different joins in SQL and explain them
Tell me about experince
1 easy sql query using ranking
What's slowly changing dimension? What's row based vs column based database? How do you diagnose the code that's running very slow? what kinds of performance tuning techniques you know? Tell me a time that you said no to the customer & what happened & how did you handle it?
Tell me your proudest achivement
What experience do you have with data warehousing?
How do you approach designing a scalable data warehouse architecture?
Viewing 21 - 30 interview questions