Data Analyst

Job Category: Data Analyst
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.

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 → 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