Snowflake
Cloud data platform enabling data warehousing, data lakes, and data sharing.
4 Rounds
~21 Days
Hard
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Technical
•
medium
Given a table with a VARIANT column containing deeply nested JSON payloads from a web tracking system, write a Snowflake SQL query to flatten the JSON, extract the 'user_id' and 'event_type', and handle cases where the 'event_type' key might be missing or null.
#VARIANT data type
#FLATTEN function
#Semi-structured data
#JSON parsing
Data Engineer
•
Technical
•
hard
Write a SQL query to implement a Type 2 Slowly Changing Dimension (SCD2) update. You have a source staging table and a target dimension table. Use a MERGE statement to insert new records, close out old records (update end_date), and insert the updated active records.
#SCD Type 2
#MERGE statement
#Data Warehousing
#ETL
Data Engineer
•
Technical
•
medium
Given a table of 'employee_salaries' (emp_id, dept_id, salary), write a SQL query to find the top 3 highest paid employees in each department. Do not use subqueries in the SELECT clause.
#Window Functions
#DENSE_RANK
#CTEs
Data Scientist
•
Coding
•
medium
Given a table of Snowflake customer query executions with columns `customer_id`, `query_id`, `start_time`, `end_time`, and `credits_used`, write a SQL query to calculate the 7-day rolling average of daily credits consumed per customer.
#Window Functions
#Time Series Aggregation
#Data Transformation
Data Scientist
•
Coding
•
hard
Given a table of query logs, write a SQL query to find the maximum number of concurrent queries that ran on a specific virtual warehouse 'WH_ANALYTICS' during the last 24 hours.
#Overlapping Intervals
#Concurrency
#Advanced SQL
Data Scientist
•
Coding
•
medium
Given a table of user logins and a table of query executions, write a SQL query to find the percentage of users who executed at least one query within 5 minutes of their first login of the day.
#Joins
#Date/Time Functions
#CTEs
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query to find the top 3 most frequently executed queries per user in the last 30 days, partitioned by virtual warehouse. Assume a massive query_history table.
#Window Functions
#Aggregation
#Performance Optimization
Product Manager
•
Coding
•
easy
Given a table of 'user_logins' and a table of 'query_executions', write a SQL query to find users who logged in but did not execute any queries in the last 7 days.
#Joins
#Filtering
#Date Functions
Product Manager
•
Coding
•
medium
Write a SQL query to identify the top 10% of customers by compute credit consumption over the last 30 days, partitioned by geographic region.
#Window Functions
#Data Analysis
#Customer Metrics
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.