How would you design an ETL pipeline to ingest daily mortgage transaction data from multiple external vendors?
