How would you design an end-to-end ETL pipeline that ingests data from a third-party financial API and loads it into a cloud data warehouse?