Data Analyst

Job ID: 65397

Position: Data Analyst

Client: CO CDE

Location: 201 E Colfax Ave Denver, Colorado 80203-0000 (Remote)

Duration: 6+ Months

Role Summary

• 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

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

• Provide targeted ETL and database expertise to:
• Accelerate PowerCenter to IDMC migration
• Reduce load on permanent IMS staff
• Support Oracle/stored-procedure based Accountability Frameworks during transition