The Extract Transform Load (ETL) Developer is focused on Data Movement. The goal of ETL Development is to create ETL Maps, which extract data from a source system, transform data by applying predetermined business rules, and move the data to the data warehouse. The ETL Developer schedules these maps to run on a recurring basis to keep the data warehouse data current.
ETL Developers work closely with the Data Warehouse Designer to understand the business requirements of the project, applying the design to the data source to create the data solution. They work closely with the Data Warehouse Designers to understand and implement any data interactions required to store and retrieve data. The ETL Developer is responsible for troubleshooting data integrity issues found during data validations.