python-data-engineering

SQLAlchemy ORM patterns (TypeDecorator, factory methods, hybrid properties, events), data warehousing architecture (Kimball dimensional modeling, medallion bronze/silver/gold, SCD types), ETL/ELT patterns, naming conventions (dim_, fact_, stg_), and modern tools (dbt, Airflow, Dagster). Use when building data pipelines, API-to-database transformations, dimensional models, or integrating external data sources with Python/PostgreSQL.