Your question is Design End-to-End Data Pipeline. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
How would you design a data pipeline to consume, clean, and transform a large volume of data into target tables?
Explain the ingestion pattern, storage layers, transformation logic, target-table design, orchestration, and data-quality controls. Include how you would handle incremental loads, schema changes, retries, failed records, backfills, observability, and idempotent reruns.
