Snowflake

Cloud data platform enabling data warehousing, data lakes, and data sharing.

4 Rounds ~21 Days Hard

Start Mock Interview

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

All Roles Cloud Engineer 1 Data Engineer 3 Data Scientist 2 Machine Learning Engineer 4 Software Engineer 4

All Topics SQL 3 System Design 2 Statistics 2 Algorithms 2 Machine Learning 2 Product Analytics 2 Leadership 1 Culture Fit 1

Data Scientist • Coding • medium

Write a Python function that takes a list of query execution intervals (start_time, end_time) for a specific compute warehouse and an auto-suspend threshold (in seconds). Calculate the total billed uptime, keeping in mind that the warehouse stays on for the auto-suspend duration after the last query finishes.

#Merge Intervals #Array Manipulation #Python

Data Scientist • Coding • easy

You are given a dataset containing JSON strings in a VARIANT column representing query execution metadata. Write a Python script using pandas to parse this JSON, extract the 'bytes_scanned' and 'execution_time_ms' fields, and identify queries that scan massive data but execute suspiciously fast.

#Data Parsing #JSON #Pandas

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.