Your question is Data Warehousing and ETL Design. 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).
Describe your experience with data warehousing concepts and ETL pipeline design.
Discuss how you model analytical data, choose between ETL and ELT, implement incremental loading, manage dependencies and schema changes, and validate data quality. Be prepared to explain technology choices, orchestration, monitoring, failure recovery, and how you would backfill historical data without creating duplicates.