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)

Visa Requirement:
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.

Job Description: 

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:

·         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