ETL Migration Analyst - IDMC & Oracle SQL Expert

nLeague; Denver (CO); Remote; USD 80,000 - 100,000; Full time

Job summary

A state organization is seeking a mid-level Data Analyst to support the migration of ETL workflows from Informatica PowerCenter to IDMC. This hands-on role focuses on analyzing, developing, and providing database support during the migration. The ideal candidate will have 4-7 years of Informatica ETL experience, strong SQL skills, and familiarity with Oracle databases. Responsibilities include supporting migration efforts, testing, and troubleshooting while contributing to documentation. This is a remote position based in Colorado.

Qualifications

• 4–7 years of hands-on Informatica ETL experience.
• Experience supporting or administering Informatica environments.
• Experience working with stored procedures and database-driven logic.

Responsibilities

• Support migration of ETL workflows from PowerCenter to IDMC.
• Analyze existing mappings and workflows for rebuilding in IDMC.
• Assist with testing and troubleshooting of migrated workflows.

Skills

Informatica ETL experience

Strong SQL skills

Linux command line interface

Tools

Informatica IDMC

Oracle databases

Job description

A state organization is seeking a mid-level Data Analyst to support the migration of ETL workflows from Informatica PowerCenter to IDMC. This hands-on role focuses on analyzing, developing, and providing database support during the migration. The ideal candidate will have 4-7 years of Informatica ETL experience, strong SQL skills, and familiarity with Oracle databases. Responsibilities include supporting migration efforts, testing, and troubleshooting while contributing to documentation. This is a remote position based in Colorado.