Designs and hardens resilient data ingestion / ETL / ELT pipelines end-to-end — source-to-warehouse — and ENFORCES reliability as deterministic phase gates (not advice): source profiling, extraction strategy (batch/incremental/CDC/ stream), schema contracts + drift policy, idempotency + load semantics, blocking data-quality gates with quarantine/dead-letter, dependency-ordered orchestration DAG, safe idempotent backfills, freshness/lineage/anomaly observability, late/out-of-order handling, and a final SLA + failure-mode audit.
