New

Data Engineering

Pipelines, SQL & warehousing

Analytics SQL, dimensional modeling and SCDs, ETL/ELT, Airflow, dbt, and cloud warehouses (Snowflake, BigQuery, Redshift) — junior to senior.

  • SQL · Modeling
  • Airflow · dbt
  • Snowflake · BigQuery
  • Editorial solutions
  • Progress tracking

Sample questions

  • ETL vs ELT
    Asked at DE
    Junior
  • Implement SCD Type 2
    Asked at Modeling
    Mid
  • Design an idempotent backfill
    Asked at Airflow
    Mid
  • Snowflake micro-partitions & pruning
    Asked at Snowflake
    Senior
Unlock full set