Free practice · no signup

Scenario Based DE problems. Run and test in browser.

For candidates who've been ghosted on data-engineering applications and can't pinpoint what's missing — the SQL, the take-home, the level you're targeting. Pick a pattern and climb.

New · Learn the concepts

The querying spine — 18 patterns, each a map of the exact traps, with the one-line truth and a runnable counterexample.

Open →
New · DE scenario interviews

Open-ended Kafka / Spark / dbt prompts with senior-reviewer feedback. Bundled with the coached tier.

Browse scenarios →
Progress0 / 237 solved
progress saved on this device

SQL patterns

10 patterns
SQL

Filtering, NULLs & Predicate Logic

12 problems · Easy → Hard
0 / 12 solvedStart →
SQL

Joins & Set Logic

25 problems · Easy → Hard
0 / 25 solvedStart →
SQL

Aggregation & Metric Correctness

23 problems · Easy → Hard
0 / 23 solvedStart →
SQL

Window Functions, Ranking & Top-N

16 problems · Easy → Hard
0 / 16 solvedStart →
SQL

Time Series, Rolling & Period-over-Period

36 problems · Easy → Hard
0 / 36 solvedStart →
SQL

Deduplication & Latest-State Logic

13 problems · Easy → Hard
0 / 13 solvedStart →
SQL

Event Sequences, Gaps & Sessions

16 problems · Easy → Hard
0 / 16 solvedStart →
SQL

Dimensional Modeling & SCD

10 problems · Medium → Hard
0 / 10 solvedStart →
SQL

Data Quality & Reconciliation

1 problem
More problems on the wayComing soon
SQL

Reshaping, Pivots & Parsing

20 problems · Medium → Hard
0 / 20 solvedStart →

Python patterns

21 patterns
Why this exists

Most data engineering practice platforms miss what hiring teams actually evaluate. They either repackage LeetCode-style puzzles as SQL problems or hide shallow learning behind a paywall. Our problems focus on real screening gaps: choosing LEFT JOINs over INNER JOINs, using the right window frame, handling nulls correctly, and writing CTEs that hold up under messy data. Once you have solved enough to understand your weak spots, the assessment identifies them clearly and gives targeted projects to help you close those gaps.

When you've done enough problems to know where your gaps are, the assessment names them precisely and gives you the projects to close them.