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.