Data Warehouse ETL Developer
IntegrateUs LLC · Austin, TX
$75 - $95 Hourly
Term:Part time
Type:EmployeeContract
We are looking for a full-time employee or contractor at one of our client locations in Austin TX.
The ETL Developer designs and writes the scripts required to extract, transform, and load (ETL) data as defined in the data mapping. The ETL Developer should understand both transactional and dimensional ETL.
The ETL Developer designs and writes the scripts required to extract, transform, and load (ETL) data as defined in the data mapping. The ETL Developer should understand both transactional and dimensional ETL.
(Note: The data mapping is an artifact that is given to the ETL developer, which defines what needs to be done. The job of the ELT Developer is to determine how to do it.)
Key Responsibilities:
Key Responsibilities:
- Automate and streamline business workflow processes
- Create and manage sophisticated SQL Service Integration Services (SSIS), ETL jobs, and schedules
- Develop ETL processes, including logic for data cleansing and data aggregation
- Work with the Business and System Analysts and Data Modelers to resolve issues with requirements
- Adapt ETL processes to accommodate the change in source systems and new business requirements
- Mitigate operational ETL risks and issues
