A developer who builds the pipelines that move data between systems and keep the target current.
What they do
- Extract data from databases, flat files, web services and other sources
- Reshape it to fit the target system's data model, including cleansing, mapping and conversion
- Load it into the data warehouse, data mart or other repository
- Model the source and target systems before the pipeline is designed
- Schedule the jobs so the target stays up to date