Skip to Main Content

Job Title


Informatica Data Integration Developer/Lead


Company : Mastech Digital


Location : Chennai, Tamil Nadu


Created : 2026-01-31


Job Type : Full Time


Job Description

Job Title: Informatica Data Integration Developer/LeadLocation: Chennai/Bangalore/HyderabadBudget: Open to discussNotice Period: Immediate joiner/ Serving notice with less than 45 days/Notice is less than 30 daysPlease find below JD for Informatica Data Integration Developer.Position SummaryThe 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 ResponsibilitiesCloud 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 projectsCloud 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 monitoringCloud 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 sessionsTechnical Skills RequiredRequired- 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 awarenessQualificationsRequired- 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 interactionPreferred- CDQ Professional certification - Cloud certifications: Snowflake SnowPro, Databricks Data Engineer, AWS/AzurePlease find below JD for Informatica Data Integration Lead.Position SummaryThe 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 ResponsibilitiesArchitecture & 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 deploymentTechnical 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 executionClient 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 consultantsTechnical Skills RequiredRequired- 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 controlPreferred- 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 workflowsQualificationsRequired- 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 skillsPreferred- 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