There were questions on: Snowflake, dbt, PostgreSql, Python, data warehousing, data modeling, OLAP vs OLTP, SQL, data quality, pipeline orchestration, and more. There was an emphasis placed on knowing Python, as noted above.
Data Warehouse Engineer Interview Questions
93 data warehouse engineer interview questions shared by candidates
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?
design a platform for the company
How do you approach designing a scalable data warehouse architecture?
what are the most efficient ways to process some data from production database without making read traffic
Technical questions based on sql data manipulation, data retrieval, and data visualization.
Sql, data warehousing fundamentals, linux
Data engineering concepts, Open source technologies.
Viewing 31 - 40 interview questions