Description
You will design and implement ETL processes to move data from diverse sources into destination systems.
Responsibilities
- Extract data from various sources and transform it according to target schemas.
- Develop and maintain data integration workflows, job scheduling, and monitoring mechanisms.
- Analyze data requirements to ensure accurate mapping and transformation rules.
- Validate the integrity and consistency of migrated data.
- Collaborate with database and system administrators to optimize database performance.
Required Skills
- Experience with IBM DataStage.
- Proficiency in Oracle and DB2 UDB.
- Hands-on work with Teradata and SQL Server.
- Experience handling Flat Files and CSV formats.
- Knowledge of SQL Server Migration Toolkit (SSMT) and SQL Server Integration Services (SSIS).
- Ability to work with Data Modeler.
- Bachelor’s degree with 10+ years of progressive post-baccalaureate experience, or Master’s degree in Computer Science, Electrical Engineering, Civil Engineering, or a related field.
- Willingness to travel or relocate to unanticipated locations throughout the US on short notice for extended periods.