Sr Integration Engineer (Informatica CDI and CAI Lead)

Location - Hyderabad/Bangalore/Gurgaon/Mumbai

Owns the integration and data quality layer around the product master. Hands-on build of ingress and egress pipelines, real-time and API-based integration, and the data quality rule set — while setting the design and build standards the integration team works to. Covers Cloud Data Integration, Cloud Application Integration and Cloud Data Quality.

Technical Responsibilities

• Ingress — Build CDI mappings, mapping tasks and task flows landing source data into the MDM staging layer. Implement source-to-target mappings, type handling, deduplication, rejection handling and reconciliation counts. 
  

• Egress — Build publication pipelines pushing golden records, hierarchies and reference data to downstream consumer systems — batch and event-driven. 
  

• Real-time integration — Develop CAI processes, service connectors, process objects and app connections. Expose and consume REST and SOAP services; implement synchronous call outs against Business Entity APIs with retry and fault handling. 
  

• Data quality — Author CDQ rule specifications, cleanse, standardize, parse and labeler transformations, reference dictionaries, profiles and scorecards. Wire DQ checks into the ingress path and define monitoring thresholds. 
  

• Profiling and remediation — Profile legacy source data — percent populated, value distributions, active versus obsolete picklist values — and own the remediation approach for attributes migrating into the master. 
  

• Migration — Build initial and delta load pipelines for existing product and SKU records, with reconciliation, exception reporting and rerun capability. 
  

• Runtime and performance — Configure Secure Agent runtime environments and connectors; tune for volume — partitioning, push down optimization, incremental extracts, job sequencing and scheduling. 
  

• Parameterisation and reuse — Establish reusable assets, mapplets, parameter sets and naming standards so the pipeline estate stays maintainable. 
  

• Operations — Define error handling, alerting, restartability and operational runbooks; support pipelines through test cycles into production. 
  

• Technical leadership — Set build standards, review the work of junior integration resources, and own estimation for the integration work stream. 
  

Mandatory Technical Skills 

• IDMC — mandatory — Minimum 2–3 years of extensive, hands-on build on IDMC across Cloud Data Integration, Cloud Application Integration and Cloud Data Quality. This is a hard requirement. 
  

• CDI — Strong hands-on build — mappings, mapping tasks, taskflows, mapplets, parameterisation, dynamic mappings, error and reject handling, scheduling. 
  

• CAI — Process and orchestration design, service connectors, process objects, app connections; REST and SOAP service exposure and consumption; fault handling and retries. 
  

• CDQ — Rule specifications, cleanse and standardize transformations, dictionaries, profiling and scorecards, and integration of DQ into pipelines. 
  

• MDM integration — Direct experience integrating with an MDM platform — ingress and egress patterns and working against MDM APIs, not just database-to-database movement. 
  

• Connectors — Salesforce, ERP (SAP or Dynamics), flat file and cloud object storage; understanding of connector limits, API quotas and bulk versus row-level operations. 
  

• SQL and volume — Strong SQL; demonstrable experience with high-volume loads, reconciliation and performance tuning. 
  

• Ownership — Track record owning an integration workstream end to end, including design and estimation, rather than building to another architect's design. 
  

Preferred Technical Skills 

• Informatica certification in CDI, CAI or CDQ. 
  

• Event-driven publication — messaging, streaming or webhook-based patterns. 
  

• CI/CD and automated asset promotion across IDMC orgs using platform REST APIs. 
  

• Cloud Data Governance and Catalog, or Metadata Command Center exposure. 
  

• Product or pricing data domain experience.