Some data modeling concepts & fact/dim designs. Lots of SQL. The SQL is heavy on entry level questions. Textbook oriented entry SQL questions, instead of practical entry SQL. One window function but easy, medium difficulty if you're not a regular window function user.
Go through the resume
How does our day look like?
What dimensions would you expect to find on a fact sales table in this industry?
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.
Basic ssis package to pull data from a transform data types and insert into b
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.
3 top technical skills do you have?
Viewing 71 - 80 interview questions