Go through the resume
Data Warehouse Engineer Interview Questions
92 data warehouse engineer interview questions shared by candidates
How does our day look like?
What dimensions would you expect to find on a fact sales table in this industry?
What do you bring to the team?
Basic ssis package to pull data from a transform data types and insert into b
Given a list with multiple integers, write a function that returns the integer that occurs the most frequently in the list.
The SQL questions looked at event tables for a streaming service and asked questions around insights to the data such as change over time, so make sure you are up to speed on your windowing functions.
Write a sql query for selecting top 50 rows of a database.
What is SQL? How to use Stored Procedure?
Various Python, Snowflake, and dbt questions. More heavily weighted to Python, as noted above. Some ETL vs ELT and OLAP vs OLTP questions.
Viewing 71 - 80 interview questions