
You are working on a data pipeline that combines records from multiple operational systems into curated tables for reporting and downstream use. The transformation has to handle messy source data, changing schemas, and duplicate records without breaking daily loads.
Describe a complex data transformation you recently built. What were the challenges?