Our direct client is seeking a Senior ETL consultant who will be working on the Client project and shall provide the Services as follows:
Perform analysis of legacy Informix db data, data models, and advise Client on the best way to transform and integrate required data from source database (Oracle) into legacy Informix database.
Understand legacy systems and processes and provide analysis of impacts and risks associated with bridging of source data to legacy database
Responsible for identifying and testing data bridges between Informix and Oracle databases. Support integrated testing of ODI interfaces and validation of data mapping
Experience Requirements:
Demonstrated high level of understanding of ETL/ELT development concepts and patterns
Data Migration 3+ years
Data Conversion 3+ years
Data Mapping and Analysis 3+ years
Informix experience 3+ years
Extract, Transform, Load (ETL) concepts and tools
Strong analytical skills with a focus on ensuring data integrity, access and security
Familiar with Oracle db environments, Oracle 12c experience preferred
Experience working in Government Clients preferred