Data Warehouse & ETL
Warehouses, lakehouses, ELT/ETL, CDC and streaming pipelines with modelling and data quality.
5 long reads · 83 minutes in total
Retail Warehouse Design: Stable Facts, Historical Dimensions, and Shared Meaning
A practical design for a medium-scale retail warehouse that preserves history with SCD Type 2 and keeps sales, inventory, and returns consistent through conformed dimensions.
17 Nov 202616 min
Data Warehouse & ETL Interview Questions: Slowly Changing Dimensions and Temporal Modeling
A practical interview guide to modeling dimensional history, handling late-arriving changes, and keeping facts correctly attributed across time.
14 Nov 202613 min
A Modern Data Stack Blueprint: Airbyte, Snowflake, dbt, and Dagster
A medium-scale, AWS-based blueprint for reliable ingestion, warehouse modeling, orchestration, delivery, and operations with Airbyte, Snowflake, dbt, and Dagster.
5 Nov 202620 min
Data Warehouse & ETL Interview Questions: CDC Replay and Backfill Correctness
Fourteen interview questions on change data capture, incremental loads, deletes, replay, and backfills—with runnable examples and production-grade reasoning.
3 Nov 202616 min
Small-Team Analytics Stack: PostgreSQL, dbt Core, and a Nightly ELT Job
A practical AWS blueprint for a small team building dependable nightly analytics with PostgreSQL, dbt Core, and a deliberately simple ELT pipeline.
31 Oct 202618 min
Newsletter
Get new Data Warehouse & ETL reads on Saturday.
The week’s new long reads on architecture, cloud and AI — with the diagrams left in. Delivered Saturday morning, no noise in between.