ETL (Extract, Transform, Load)
In short: What is ETL (Extract, Transform, Load)?
ETL (extract, transform, load) is a data pipeline that extracts data from source systems, standardises it and loads it into a target database.
Explanation
The three stages are reading raw data from source systems, transforming it (cleaning, normalising formats, joining records, computing derived fields) and loading the result into a data warehouse. A common modern variant is ELT, where transformations run inside the target warehouse itself.
Reliable data pipelines are the foundation of analytics: if ingestion is broken or incomplete, every downstream dashboard will be too. Pipelines therefore need scheduling, monitoring and fault-tolerant retry logic.
Example: an overnight job pulls the previous day's orders, converts amounts into a common currency, joins customer master data and refreshes the reporting tables.