Data Engineering Interview Kit 2026 – Pro (PDF + Portfolio Project + Study Plan)
Launch offer: 25% off with code LAUNCH25 until 18 October 2026, 21:00 CEST (Pro €29.25 instead of €39).
Everything in Basic (the 107-page PDF: 80 interview questions with model answers, trade-offs, common mistakes and follow-ups, 10 worked design exercises, SQL practice set with verified solutions), plus the SQL practice set as files (15 problems as runnable .sql, tasks and solutions separate, a ready-made DuckDB database, expected results as CSV) and:
- A complete, runnable Airflow 3 + dbt + DuckDB pipeline: two commands (make setup && make run), no cloud account, no costs
- Layered testing to talk about in interviews: dbt unit test, 69 data tests incl. a custom test and a revenue reconciliation, a persisted quality check, pytest + DAG integrity tests
- Production patterns interviewers ask about: idempotent ingestion with rollback, deduplication, an incremental fact table handling late updates, an SCD snapshot, a schema contract, CI with linting
- A built-in interview guide: 60-second pitch, 10 likely follow-up questions with answer outlines, steps to make it your own GitHub project
- A 14-day study plan (~35 h) as Markdown, PDF and a Notion-importable CSV, mapped to kit chapters
Why Pro: a project you built and can explain is the strongest answer to "tell me about a pipeline you built". The interview guide shows you how to present it.
One ZIP download: the PDF, portfolio-project.zip, the study plan and the SQL files, with a START-HERE file. The portfolio project needs Python 3.11 or 3.12, make and Git; Docker (Compose v2, ~4 GB RAM) only for the optional Airflow path.
Try first: the free sample with 20 complete questions is in the store: https://payhip.com/b/18A5n
30-day money-back guarantee: if the kit does not help your preparation, email info@itcraftsman.de within 30 days of purchase with your order number and you get a full refund. This voluntary guarantee is in addition to your statutory rights.
Right of withdrawal for digital content. This product is digital content that is delivered immediately after purchase. By completing your purchase you request immediate delivery and acknowledge that your right of withdrawal expires once the delivery (download) has started. Regardless of this, our voluntary 30-day money-back guarantee applies: if the kit does not help your preparation, email info@itcraftsman.de within 30 days of purchase with your order number and you get a full refund. This guarantee is in addition to your statutory rights.
About the author: IT-Craftsman is the company of an independent data engineer and DevOps freelancer who has delivered several data engineering and DevOps projects for large companies. He also works for a technology consulting firm, where he conducts hiring interviews for data engineers and DevOps engineers. Quality: every SQL solution was executed in DuckDB; everything else is checked against the official docs. No testimonials, invented credentials or made-up statistics.
Imprint / Privacy: https://itcraftsman.de/imprint · https://itcraftsman.de/privacy