Sr Integration Engineer (Informatica CDI and CAI Lead)

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

Job summary

Zohorecruit in Bangalore South, India is seeking a Sr Integration Engineer specializing in Informatica CDI and CAI lead. The role requires 8–12 years total with 2–3 years hands-on IDMC delivery.

You will drive the integration and data quality layer around the product master, building ingress and egress pipelines and overseeing data quality rules. Own the design standards for integration, including real-time and API-based integration, SI/ETL patterns, and mentoring junior engineers.

Qualifications

• Minimum 2–3 years of hands-on IDMC development across CDI, CAI and CDQ.
• Strong CAI process design, service connectors, and REST/SOAP exposure.
• Experience with MDM integration and inbound/outbound pipelines.
• Experience with high-volume SQL loads and performance tuning.
• Ability to own an integration workstream end-to-end.

Responsibilities

• Ingress mappings, mapping tasks and flows into MDM staging with deduplication.
• Publish golden records, hierarchies, and reference data to downstream systems (batch and real-time).
• Develop CAI processes, service connectors, and app connections with REST/SOAP exposure.
• Author CDQ rules, cleanse/standardize transformations and integrate DQ into pipelines.
• Profile legacy source data and define remediation for master attributes.
• Build initial and delta load pipelines for product/SKU with reconciliation and rerun capability.
• Configure Secure Agent runtimes and optimize for volume (partitioning, incremental extracts).
• Establish reusable assets and naming standards for pipeline maintainability.
• Define error handling, alerts, and operations runbooks; support pipelines into production.
• Set build standards and estimate integration workstreams.

Skills

IDMC

CDI

CAI

CDQ

MDM integration

Salesforce

ERP SAP/Dynamics

SQL & performance

Ownership

Tools

REST APIs

SOAP APIs

CI/CD

IDMC platform

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.