GO TO A SECTION

↑ ↓ to navigate · Enter to openExplore all sections →
FDEInterviews logo
← SQL & Data Engineering / 25
hard★ EssentialDatabricksPalantirSnowflake

Design a daily pipeline that survives reruns, late-arriving data, and a 3-year backfill, without double-counting.

The pipeline-design question that exposes whether you've ever been paged. One property, idempotency, solves reruns, late data, and backfills at once, and there are exactly three patterns that deliver it.

Updated Sep 2026 · Grounded in real Forward Deployed Engineer interview loops and written to a senior-engineer editorial bar.

The pipeline-design question that exposes whether you've ever been paged. One property, idempotency, solves reruns, late data, and backfills at once, and there are exactly three patterns that deliver it.

20 answers per topic instead of 10, plus saved progress and bookmarks · no cardor unlock all 548 remaining answers · ₹2,000 / $25

Every answer, concept and course, every paper breakdown, all published video lessons, hands-on FDE Lab missions, Premium PDF guides and companion files, the full practice-test bank and work-sample downloads. Referral Premium excludes guide PDFs and their companion files.

6 months · One payment · No auto-renewal

Study alongside free video lessons.

Keep practising

Next in this trackYou must ingest from a customer source that ships nulls, duplicates, and surprise schema changes. Design defensive ingestion.PremiumNext in this trackTwo customer lists, millions of rows, no shared key, names and emails almost match. Dedupe and merge them.PremiumNext in this trackDesign CDC from a customer's Oracle ERP into the lakehouse, including deletes and schema evolution.Premium
DISCUSSION · 0

No comments yet — be the first to share your approach.