Informatica PowerCenter & IDMC (IICS) Developer – Migration Specialist

Delan Associates, Inc•Pleasanton, CA

10d•Onsite

About The Position

We are seeking an experienced Informatica PowerCenter & IDMC (IICS) Developer with a specialization in migration to join our team in Pleasanton, CA. This onsite role requires a deep understanding of Informatica PowerCenter and Informatica IDMC (IICS), with a strong focus on migrating existing ETL processes to the cloud. The ideal candidate will be responsible for developing, testing, and supporting data integration solutions, ensuring performance, reliability, and data integrity throughout the migration process.

Requirements

Informatica PowerCenter
Informatica IDMC (IICS)
Cloud Data Integration (CDI)
ETL Development
PowerCenter to IDMC Migration experience
Experience with Mappings, Workflows & Taskflows
SQL proficiency
Oracle database experience
SQL Server experience
Performance Tuning skills
Data Validation & Testing (SIT/UAT) experience
ETL Troubleshooting skills
Deployment & Production Support experience
Minimum 13 years of relevant experience

Nice To Haves

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

Responsibilities

Develop and implement ETL processes using Informatica PowerCenter and Informatica IDMC (IICS).
Lead and execute migration projects from PowerCenter to IDMC (IICS).
Design, develop, and maintain mappings, workflows, and taskflows.
Write and optimize SQL queries for Oracle and SQL Server databases.
Perform performance tuning on ETL processes to ensure efficiency.
Conduct data validation and testing, including System Integration Testing (SIT) and User Acceptance Testing (UAT).
Troubleshoot and resolve ETL issues.
Manage deployment processes and provide production support.
Collaborate with cross-functional teams to understand data integration requirements.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume