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.
- Collaborate with database and system administrators to optimize database performance.
- Analyze data requirements to ensure accurate mapping and transformation rules.
- Validate the integrity and consistency of migrated data.
Required Skills
- Experience with DataStage.
- Proficiency in Oracle and DB2 UDB.
- Hands-on work with Teradata and SQL Server.
- Experience handling Flat Files and CSV formats.
- Knowledge of SSMT and SSIS.
- Ability to work with Data Modeler.
- Master’s degree in Computer Science, Electrical Engineering, Civil Engineering, or a related field, or a Bachelor’s degree with 5 years of progressive post-baccalaureate experience.
- Willingness to travel or relocate to unanticipated locations throughout the US on short notice for extended periods.