Data Analyst

Job Category: Data

Job Type: Remote

Job Location: Colorado Denver

Compensation: Depends on Experience

W2: W2-Contract Only;
Kindly note that applications on a C2C basis will not be considered for this role.

Eligible Visa: GC GC-EAD H4 EAD L2S U.S. Citizen (USC)

This position is open only to candidates authorized to work in the United States under the following visa categories:
H4-EAD, Green Card Holder, GC-EAD, U.S. Citizen, L2s, L2-EAD. No other visa types are eligible for this role.

• IMS is seeking a mid-level Informatica ETL Developer / Administrator to support the migration of ETL workflows from Informatica Power Center 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.

• Support migration of ETL workflows from Power Center 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.

• 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.

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

• 8+ years of hands‑on Informatica ETL experience.
• Experience with Informatica IDMC / Informatica Cloud or Power Center 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.

• Prior Power Center → 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.

• Accelerate Power Center to IDMC migration
• Reduce load on permanent IMS staff
• Support Oracle/stored‑procedure–based Accountability Frameworks during transition