Description

You will design, implement, and maintain ETL processes to extract, transform, and load data from diverse sources into target systems.

Responsibilities

• Develop and maintain data integration workflows, job scheduling, and monitoring mechanisms to ensure timely and accurate execution.
• Collaborate with database and system administrators to optimize database performance and ensure seamless integration.
• Analyze data requirements, define transformation rules, and validate data integrity and consistency during migration.
• Work with source data structures and flat files to ensure accurate mapping and loading.

Required Skills

• Experience working with ETL processes and DataStage.
• Proficiency with Oracle, DB2 UDB, Teradata, and SQL Server.
• Hands-on experience with SSMS, SSIS, and Data Modeler.
• Ability to handle flat files and CSV data formats.
• Bachelor’s degree in Computer Science, Electrical Engineering, Civil Engineering, or related field plus 5 years of progressive post-baccalaureate experience, or a Master’s degree in a related field.
• Minimum 6 months of experience in ETL processes or as a Software Developer.

Preferred Skills

• Willingness to travel or relocate to unanticipated locations throughout the US on short notice for extended periods.

Key Skills

Education

Any Graduate