Dataford
Dataford
Top 31
Prep plan
Updated weekly · Last refresh Oct 17

Snowflake Data Engineer Interview Questions

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

31questions
~5htotal time
Track your progressSign up free to work through all 31 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions · ~71 min
UPSERT Incremental LoadMedium
Practice

Upsert the newest staging records into a PostgreSQL dimension while preserving newer target data.

Data ManipulationETLdata migrationSnowflake
Session Duration With InactivityHard
Practice

Calculate per-user session durations by identifying sessions separated by more than 30 minutes of inactivity.

Window FunctionsLag/LeadDate FunctionsSnowflake
Top Customers Per RegionMedium
Practice
Recently asked

Use CTEs, joins, aggregation, and ROW_NUMBER to find the top three recent-revenue customers in each region.

Window FunctionsJoinsAggregationsSnowflake
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~40 min
Merge Overlapping IntervalsMedium
Practice

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

ArraysSearchingSortingSnowflake
LeetCode Coding PerformanceHard

Assesses resilience and iterative improvement when facing difficult coding problems.

challengesleetcodeSnowflake
More Coding questions with a free account

Sign up to see every question

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

Get my prep plan
3
Pipelines6 questions · ~61 min
Scalable Fault-Tolerant ETLHard

Explain practical patterns for building scalable, fault-tolerant ETL pipelines with reliable recovery, data quality, and backfills.

Data Qualitydata pipelinesETLSnowflake
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
More Pipelines questions with a free account
4
Behavioral & Leadership13 questions · ~131 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~10 min
Ledger vs Payment ReconciliationHard

Tests end-to-end reconciliation design, matching rules, and handling mismatches across systems.

Stakeholder Managementsolution designSnowflake
The finish line: interview-readyComplete all 31 questions to finish this plan.