Production portfolio project demonstrating end-to-end DE architecture across GCP, AWS, and Databricks — ingesting NYC and London public datasets through a full lakehouse stack with automated data quality and dbt transformation. -5 API integrations (NYC 311, NYPD crime, TfL London transit, AirNow EPA, Open-Meteo); BaseIngester with retry logic, BigQuery streaming loader, S3Writer, 4 Airflow DAGs - dbt transformation layer with automated quality test suite (33+ unit tests), ADR documentation, and lineage tracking -Fully open-source on GitHub — structured as a professional portfolio project with reproducible Docker deployment Tech: GCP (BigQuery, Pub/Sub, Dataflow) · AWS (S3) · Databricks · dbt · Apache Airflow · Python · Docker