Whenever you're ready, walk me through how you'd approach this.
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.