Explain the common data integration patterns: ETL, ELT, and Change Data Capture. When would you choose each?

Sample answer preview

Data integration patterns determine how data moves between systems, and choosing the right pattern affects latency, cost, complexity, and the ability to derive insights from data across an organization. ETL, Extract Transform Load, is the traditional pattern.