IDMC Administrator (RARR Job 6504)

We are looking for an experienced Informatica IDMC (IICS) Administrator with strong expertise in designing, developing, and migrating ETL solutions using Informatica Intelligent Data Management Cloud (IDMC). The ideal candidate should have hands-on experience with PowerCenter migration, Cloud Data Integration (CDI), Cloud Data Quality (CDQ), Cloud Application Integration (CAI), SQL, and cloud platforms such as AWS, Azure, or GCP.

Key Responsibilities

• Design, develop, and deploy ETL mappings and workflows using Informatica IDMC (IICS).
• Migrate existing Informatica PowerCenter workflows and mappings to IDMC.
• Develop and maintain Cloud Data Integration (CDI) pipelines.
• Implement Cloud Data Quality (CDQ) rules to ensure data accuracy and consistency.
• Build and manage integrations using Cloud Application Integration (CAI) and APIs.
• Optimize ETL jobs, SQL queries, and workflows for better performance using pushdown optimization and partitioning.
• Configure and manage Secure Agents in IDMC environments.
• Implement CI/CD pipelines and maintain source code using Git.
• Support data governance initiatives, data modeling, and Master Data Management (MDM).
• Collaborate with cross-functional teams to deliver scalable and secure data integration solutions.

Required Skills

• Strong hands-on experience with Informatica Intelligent Data Management Cloud (IDMC/IICS).
• Expertise in Cloud Data Integration (CDI).
• Experience with Cloud Data Quality (CDQ).
• Experience with Cloud Application Integration (CAI).
• Hands-on experience migrating PowerCenter to IDMC.
• Strong knowledge of Informatica PowerCenter mappings, workflows, and parameters.
• Strong SQL skills with experience in Oracle, SQL Server, or PostgreSQL.
• Experience working with at least one cloud platform: AWS, Azure, or GCP.
• Experience with Git and CI/CD implementation.
• Knowledge of Python or Shell Scripting.