Sr Integration Engineer (Informatica CDI and CAI Lead)

India

INR 3,500,000 – INR 5,000,000

Location

Hyderabad/Bangalore/Gurgaon/Mumbai

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.