Designs an ETL or ELT pipeline architecture — triggers on "design a pipeline", "how should I load this data", "build an ingestion layer", "incremental load", "idempotent pipeline". Produces a concrete pipeline spec covering source extraction, transformation strategy, load pattern, idempotency, incrementality, late-data handling, and schema contracts.
