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
163 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?
They use canned interview questions about experience, and skill familiarity.
Draw architecture of previous data warehouse project on whiteboard
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.
Viewing 61 - 70 interview questions