extraction, transformation, and loading The act of extracting data from various sources, transforming data to consistent types, and loading the transformed data for use by applications