paytrail: Payments Medallion Lakehouse
- Built a Databricks medallion lakehouse taking 6.3M synthetic payments from Azure storage through bronze, silver and gold layers.
- Designed idempotent incremental loads for late and out-of-order data, with Unity Catalog governance and 51 dbt tests gated in CI.
- Reconciled settlement outputs to source at penny level and reduced the heaviest rollup runtime by 39% after optimisation.
