Python for pipeline orchestration, data transformation, and scripting
Dimensional modelling, SCD types 1/2/3, and snapshot patterns.
dbt or equivalent, including testing documentations and incremental loading patterns.
Pipeline orchestration using Airflow, Prefect, or similar.
Cloud data warehousing (Snowflake, BigQuery, or Redshift)
Advanced SQL, including window functions, CTEs, date spine logic.
+3 more