How ETL works. The ETL process is comprised of 3 steps that enable data integration from source to destination: data extraction, data transformation, and data loading.