Whenever you're ready, walk me through how you'd approach this.
Describe your approach to designing an ETL pipeline that handles both batch and real-time streaming data.
Explain how you would choose ingestion, processing, storage, orchestration, and serving technologies. Cover data modeling, schema evolution, idempotency, exactly-once or effectively-once processing, data quality, monitoring, failure recovery, and backfilling. Discuss how batch and streaming paths share logic, avoid duplicate data, and meet different latency requirements.