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