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?
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?
Viewing 71 - 80 interview questions