Dataford
Top 22
Prep plan
Updated weekly · Last refresh Aug 30

Snowflake Data Engineer Interview Questions

The questions to prepare for a Snowflake Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 5 questions · ~44 min
Merge Overlapping IntervalsMedium
Practice

Sort intervals by start time, then merge overlapping ranges into a minimal non-overlapping list.

ArraysSearchingSortingSnowflake
Aggregate Error Rates From LogsMedium

Tests coding ability to parse semi-structured logs and compute time-bounded error metrics.

StringspythonAggregationsSnowflake
Space-Efficient Payload TransformationHard

Tests advanced coding and space complexity trade-offs for transforming semi-structured payloads.

json parsingStringsperformance analysisSnowflake
More Coding questions with a free account
2
Pipelines3 questions · ~26 min
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualitySnowflake
Design Real-Time Event Processing PipelineMedium

Design a real-time event pipeline processing 250K events/sec into Snowflake with under 2-minute latency, strong data quality, and replay support.

InfrastructureStream ProcessingOrchestrationSnowflake
ETL With Array FlatteningMedium

Assesses practical ETL design and data transformation skills with SQL and Python.

ETLstring manipulationsqlSnowflake

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
SQL & Data Manipulation4 questions + 3 drills · ~65 min
Fix Skewed Join PerformanceHard

Tests query optimization strategies for skewed joins and performance troubleshooting.

Performance TuningJoinsperformanceSnowflake
SQL Scenario: Historical + CurrentMedium

Tests your ability to design SQL for incremental updates and historical correctness.

sqlSnowflake
MQL Month-over-Month GrowthMedium
Practice
Practice drill

Calculate monthly MQL counts and month-over-month growth by Snowflake campaign channel using CTEs and LAG.

Window FunctionsDate FunctionsAggregationsSnowflakeSnowflake Computing
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
SQL Ranking by SalaryEasy
Practice
Practice drill

Join employee and salary data, then rank employees within each Intuit product company using a PostgreSQL window function.

JoinssqlAggregationsIntuit
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership10 questions · ~88 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 22 questions plus 3 hands-on drills to finish this plan.