project / DATA · ETL
End-to-End Food Order ETL Pipeline
- MySQL
- Python
- ETL
- Star Schema
- pytest
- GitHub Actions
- HTML
- Chart.js
Problem
Turn raw CSV food orders into a warehouse you can query and a dashboard you can read.
Outcome
MySQL star schema with idempotent loads, job logging, 20 automated tests and CI.
Overview
Production-style ETL pipeline replicating the architecture used by DoorDash and Uber Eats. Extracts raw CSV orders into a MySQL staging DB, transforms via stored procedures into a star schema warehouse (fact_orders + 4 dim tables), and serves an interactive HTML analytics dashboard. Includes idempotent loading, ETL job logging, 20 automated pytest tests, and GitHub Actions CI/CD.