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 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
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.