Senior ETL Consultant

PEOPLECORP AMERICA; Denver (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

A leading consulting firm is seeking a Senior ETL Consultant for a critical client project. The role involves analyzing legacy data, transforming, and integrating databases, with a focus on ensuring data integrity. Ideal candidates will have extensive experience with ETL processes, particularly with Informix and Oracle systems. This position offers an opportunity to work with government clients and apply advanced analytical skills in a dynamic environment.

Qualifications

• 3+ years in data migration, conversion, mapping, and analysis.
• Strong ETL tool understanding and analytical skills.
• Familiarity with Oracle db environments.

Responsibilities

• Analyze Informix and Oracle databases for data transformation.
• Identify and test data bridges; validate data mapping.
• Provide impact analysis on legacy systems.

Skills

Data Migration

Data Conversion

Data Mapping

Data Analysis

Analytical Skills

ETL Concepts

Tools

Informix

Oracle

Job description

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

800 Corporate Drive, Suite 301-500
Stafford, VA, 22554
Phone - 1 [phone]
Fax - 1 [phone]