Welcome to your interview.
The question is on your right: Describe a Complex Transformation Pipeline. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.
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?