Data Analyst

JPS Tech Solutions; Colorado; On-site; USD 83,000 - 124,000; Full time

Job summary

IMS is seeking a mid-level Informatica ETL Developer/Administrator to support the migration of ETL workflows from Informatica PowerCenter to Informatica IDMC. This hands-on role focuses on migration, development, and database support during transition and stabilization.

The contractor will analyze mappings, assist with testing, validation, and troubleshooting of migrated workflows, and support cutover activities. Experience with Oracle databases and Linux CLI is required.

Qualifications

• 8+ years of hands-on Informatica ETL experience.
• Experience with Informatica IDMC / Informatica Cloud or PowerCenter with migration exposure.
• Experience supporting or administering Informatica environments.
• Strong SQL skills with Oracle databases.
• Experience working with stored procedures and database-driven logic.
• Experience supporting ETL testing, validation, and issue resolution.
• Experience with Linux based operating systems and command line interface.

Responsibilities

• Support migration of ETL workflows from PowerCenter to IDMC.
• Analyze existing mappings and workflows to support rebuild or refactor in IDMC.
• Assist with testing, validation, and troubleshooting of migrated workflows.
• Support cutover and post-migration stabilization activities.
• Support IDMC environment configuration and operations.
• Perform system configuration activities to support hybrid legacy configuration.
• Assist with job scheduling, monitoring, and error resolution.
• Follow established operational procedures and escalation paths.
• Document changes made during migration to support operational continuity.

Skills

Informatica ETL

SQL

Oracle

Linux

ETL Testing

IDMC Migration

Stored Procedures

Tools

PowerCenter

Informatica IDMC

Informatica Cloud

Job description

Job Description:

• IMS is seeking a mid-level Informatica ETL Developer / Administrator to support the migration of ETL workflows from Informatica PowerCenter to Informatica Intelligent Data Management Cloud (IDMC).
• This role is hands-on and execution-focused, providing development, administration, and database support during migration and stabilization efforts.
• The contractor will primarily focus on ETL Asset/ Workflow migration. The contractor will may also assist with Oracle database and stored-procedure-based systems, including components supporting Accountability Frameworks.
• This position works under the direction of IMS technical leads and does not include platform ownership, architecture authority, or people management.

Key Responsibilities:

Informatica IDMC Migration:

• Support migration of ETL workflows from PowerCenter to IDMC.
• Analyze existing mappings and workflows to support rebuild or refactor in IDMC.
• Assist with testing, validation, and troubleshooting of migrated workflows.
• Support cutover and post-migration stabilization activities.

Informatica Administration (Execution-Level):

• Support IDMC environment configuration and operations.
• Perform system configuration activities to support hybrid legacy configuration.
• Assist with job scheduling, monitoring, and error resolution.
• Follow established operational procedures and escalation paths.

Database & Stored Procedure Support:

• Support Oracle databases used by ETL and reporting systems.
• Assist with analysis and troubleshooting of SQL and stored procedures.
• Validate data transformations and outputs, particularly for Accountability Frameworks.

Documentation & Knowledge Transfer:

• Contribute to migration and configuration documentation.
• Document changes made during migration to support operational continuity.
• Participate in knowledge transfer to IMS staff as requested.

Required Skills & Experience:

• 8+ years of hands-on Informatica ETL experience.
• Experience with Informatica IDMC / Informatica Cloud or PowerCenter with migration exposure.
• Experience supporting or administering Informatica environments.
• Strong SQL skills with Oracle databases.
• Experience working with stored procedures and database-driven logic.
• Experience supporting ETL testing, validation, and issue resolution.
• Experience with Linux based operating systems and command line interface.

Preferred Skills:

• Prior PowerCenter to IDMC migration experience.
• Familiarity with cloud or hybrid execution environments.
• Experience or familiarity with Linux system administration activities.
• Experience supporting regulated or audit-sensitive data systems.

Engagement Objective:

• Accelerate PowerCenter to IDMC migration
• Reduce load on permanent IMS staff
• Support Oracle/stored-procedure-based Accountability Frameworks during transition