Skip to content
All topics

Data Warehouse & ETL

Warehouses, lakehouses, ELT/ETL, CDC and streaming pipelines with modelling and data quality.

5 long reads · 83 minutes in total

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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.

One email every Saturday. Unsubscribe with one click, any time.

Data Warehouse & ETL · Ekanatha