Sr Integration Engineer (Informatica CDI and CAI Lead)

Zohorecruit; Bengaluru Urban; On-site; INR 3,500,000 - 6,500,000; Full time

Job summary

Zohorecruit in Bengaluru invites an experienced Sr Integration Engineer to own the integration and data quality layer around the product master. You will build ingress/egress pipelines, real-time and API-based integration, and enforce CDQ rules across IDMC, CDI, CAI, and CDQ domains.

The role demands 8–12 years total experience with hands-on IDMC delivery and ownership of end-to-end integration workstreams, plus excellence in data governance and performance tuning in a fast-paced product

Qualifications

• 8–12 years total experience in integration
• Hands-on IDMC across CDI, CAI and CDQ mandatory
• CDI/CAI/CDQ and MDM integration experience required
• REST/SOAP service exposure and consumption, with retries and fault handling

Responsibilities

• Owns the integration and data quality layer around the product master.
• Builds ingress and egress pipelines, real-time and API-based integration.
• Develops CAI processes, service connectors, and app connections; exposes REST/SOAP services.
• Author CDQ rule specifications and profiling; wire DQ checks into ingress path.
• Define error handling, monitoring thresholds and runbooks; support pipelines to production.

Skills

IDMC

CDI

CAI

CDQ

MDM

Data quality

REST

SQL

Cloud data

Ownership

Tools

Salesforce

SAP

Dynamics

Job description

Sr Integration Engineer (Informatica CDI and CAI Lead)

Bangalore South, India | Posted on 09/24/2026

Experience : 8–12 Y ears total; minimum 2–3 years extensive hands‑on delivery on IDMC (Cloud Data Integration, Cloud Application Integration, Cloud Data Quality)

Role Summary

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

• 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.