Informatica Data Integration Developer/Lead

Job Title: Informatica Data Integration Developer/Lead

Location: Chennai/Bangalore/Hyderabad

Budget: Open to discuss

Notice Period: Immediate joiner/ Serving notice with less than 45 days/Notice is less than 30 days

Please find below JD for Informatica Data Integration Developer.

Position Summary

The IDMC Data Integration Developer leads technical delivery of data integration solutions, designing complex mappings, optimizing performance, and mentoring junior team members. This role requires hands-on expertise in CDI, CDQ, and CAI with the ability to work directly with clients and integrate with MDM SaaS implementations.

Key Responsibilities

Cloud Data Integration (CDI)

• Design and develop complex ETL/ELT mappings with advanced transformations
• Build enterprise TaskFlows with error handling, restartability, and notifications
• Configure Mass Ingestion for high-volume data loading
• Implement change data capture (CDC) patterns
• Develop MDM SaaS ingress/egress jobs using FEP Connector, Business Events
• Perform job performance tuning and optimization
• Support PowerCenter to CDI migration projects

Cloud Data Quality (CDQ)

• Design and implement comprehensive data quality rules
• Configure address standardization and verification (Address Doctor)
• Implement data deduplication and matching logic
• Integrate DaaS services for data enrichment
• Build data quality scorecards and monitoring

Cloud Application Integration (CAI)

• Develop API-based integrations using CAI processes
• Implement real-time event-driven patterns
• Configure connectors for SaaS applications (Salesforce, SAP, Workday)

General

• Lead technical workstreams and coordinate with cross-functional teams
• Create technical design documents and mapping specifications
• Conduct code reviews and mentor Associate consultants
• Participate in client workshops and requirements sessions

Technical Skills Required

Required

• Advanced CDI mapping development (Joiner, Aggregator, Router, custom functions)
• TaskFlow design with parallel execution, error handling, and recovery
• Mass Ingestion configuration and optimization
• CDQ profiling, rules, standardization, and deduplication
• CAI process development and API integration
• Secure Agent configuration and troubleshooting
• Strong SQL and database skills
• MDM SaaS integration (FEP Connector, Business Events, egress patterns)

Preferred

• PowerCenter expertise (for migration projects)
• Cloud data platforms: Snowflake, Databricks, AWS Redshift, Azure Synapse, BigQuery
• Python and PySpark for data engineering tasks
• CDGC for data governance and lineage
• CLAIRE AI features (Copilot, smart mapping)
• AI/ML fundamentals and GenAI application awareness

Qualifications

Required

• Bachelor's degree in Computer Science, Information Systems, or related field
• 4-8 years of experience in data integration with at least 2 years on IDMC or PowerCenter
• Data Engineering Professional certification or CDI Developer certification
• Hands-on experience with at least one cloud data platform
• Excellent communication skills for client interaction

Preferred

• CDQ Professional certification
• Cloud certifications: Snowflake SnowPro, Databricks Data Engineer, AWS/Azure

Please find below JD for Informatica Data Integration Lead.

Position Summary

The IDMC Data Integration Lead designs enterprise-grade data integration architectures, leads complex implementations, and provides technical leadership for CDI, CDQ, and CAI solutions. This role combines hands-on with deep technical expertise with the ability to guide teams, engage with senior client stakeholders, and support pre-sales activities.

Key Responsibilities

Architecture & Design

• Design enterprise data integration architectures (batch, real-time, hybrid)
• Create solution designs including HLD/LLD and architecture patterns
• Design data lake and data warehouse integration patterns
• Architect MDM SaaS integration solutions (ingress, egress, real-time sync)
• Design Secure Agent architecture including HA, multi-agent, and failover
• Establish CI/CD pipelines for IDMC asset deployment

Technical Leadership

• Design data quality frameworks and governance standards
• Configure CLAIRE AI features for productivity (Copilot, smart mapping, AI recommendations)
• Drive performance optimization for high-volume data processing
• Conduct architecture reviews and quality gates
• Lead PowerCenter to CDI migration strategy and execution

Client Engagement

• Lead technical discovery and requirements workshops
• Provide pre-sales support including demos, POCs, and proposals
• Engage with client architects and senior stakeholders
• Mentor Specialist and Associate consultants

Technical Skills Required

Required

• Enterprise data integration architecture (EAI, ETL, ELT, CDC, streaming)
• Advanced CDI: complex mappings, hierarchical data, advanced transformations
• CDQ: enterprise DQ frameworks, scorecards, remediation workflows
• CAI: API design, event-driven architecture, microservices integration
• MDM SaaS integration patterns (FEP, Business Events, MDM Extensions)
• Kafka, Event Hubs for streaming integration
• Secure Agent architecture: HA, serverless, multi-agent deployment
• CI/CD for IDMC: export/import automation, version control

Preferred

• PowerCenter migration methodology and best practices
• CDGC: catalog, lineage, business glossary, data marketplace
• Cloud data platforms: Snowflake, Databricks, AWS (Redshift, Glue), Azure (Synapse, ADF), GCP (BigQuery)
• Python and PySpark for advanced data engineering
• CLAIRE AI: Copilot, CLAIRE Agents (Data Exploration, ELT, DQ)
• AI/ML implementation; familiarity with LLMs and GenAI applications
• Agent AI concepts: Salesforce Agentforce, autonomous data workflows

Qualifications

Required

• Bachelor's degree in Computer Science, Information Systems, or related field
• 8-12 years of data integration experience with at least 6 - 8 years on Informatica (IDMC )
• CDI/CAI Professional certifications
• Proven experience designing enterprise integration architectures
• Strong stakeholder management and executive communication skills

Preferred

• CDQ Professional and CDGC certifications
• Cloud certifications: Snowflake SnowPro, Databricks Data Engineer, AWS Solutions Architect, Azure Data Engineer
• MDM SaaS certifications (Customer 360 Developer, MDM Foundation)
• Pre-sales and proposal development experience