End-to-End Food Order ETL Pipeline

MySQL · Star Schema · 20 tests · CI/CD

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.

Built with: MySQL, Python, ETL, Star Schema, pytest, GitHub Actions, HTML, Chart.js