Informatica PowerCenter IDMC IICS Developer Migration Specialist

Delan Associates, Inc; Pleasanton (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

Doist is seeking an Informatica PowerCenter & IDMC Developer – Migration Specialist to join our Pleasanton, CA team onsite. The role focuses on migration projects, ETL development, and ensuring data validation and testing across environments.

The candidate should have extensive hands-on experience with PowerCenter, IDMC, CDI, and complex mappings, workflows, and troubleshooting. Onsite work in Pleasanton, CA is required.

Qualifications

• Experience with Informatica PowerCenter and IDMC (IICS) platforms.
• Expertise in Cloud Data Integration and ETL development.
• Proficient in SQL, Oracle, and SQL Server with data validation and testing (SIT/UAT).
• Experience with migration from PowerCenter to IDMC and production support.

Skills

Informatica PowerCenter

Informatica IDMC (IICS)

Cloud Data Integration

ETL Development

PowerCenter to IDMC Migration

Mappings, Workflows & Taskflows

SQL

Oracle

SQL Server

Performance Tuning

Data Validation & Testing (SIT/UAT)

ETL Troubleshooting

Deployment & Production Support

Agile/Scrum

Tools

Azure Data Factory

Databricks

Azure Synapse

Python

PySpark

Job description

Informatica PowerCenter & IDMC (IICS) Developer – Migration Specialist PLEASANTON, CA (Onsite) 13+ Years

Must Have Skills

• Informatica PowerCenter
• Informatica IDMC (IICS)
• Cloud Data Integration (CDI)
• ETL Development
• PowerCenter to IDMC Migration
• Mappings, Workflows & Taskflows
• SQL
• Oracle
• SQL Server
• Performance Tuning
• Data Validation & Testing (SIT/UAT)
• ETL Troubleshooting
• Deployment & Production Support

Nice-to-Have

• Azure Data Factory
• Databricks
• Azure Synapse
• Python
• PySpark
• Agile/Scrum