← All projects

Python Data Warehouse

Python Data Warehouse

Production-grade ETL pipeline that ingests hourly weather data from a live REST API, transforms it into a dimensional data model, and loads it into a MySQL data warehouse. Demonstrates idempotent loading, connection pooling, and structured logging.

ETLPythonSQLAlchemyMySQLPandas

Related projects