Informatica CAI Lead

LumenData; Bengaluru; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

LumenData is seeking a Senior Informatica Cloud Application Integration (CAI) Developer in Bengaluru to design, develop, and deploy API-led integrations and real-time orchestration using Informatica IICS CAI and CDI. The candidate should have strong skills in integration patterns, XQuery, REST/SOAP APIs, and cloud architectures.

Responsibilities include building connectors, data mappings, and orchestrations, integrating with Salesforce, Snowflake, SQL Server, and APIs, plus ensuring robust error

Qualifications

• 5–9 years of IT experience with at least 3+ years in Informatica IICS CAI.
• Hands-on experience with XQuery and API integrations.
• Proficient in REST/SOAP services, process orchestration, and real-time integrations.

Responsibilities

• Design, develop, and implement end-to-end integrations using Informatica CAI and CDI.
• Build and maintain service connectors, process objects, and APIs for real-time and batch integrations.
• Develop XQuery and expression transformations for data mapping and transformation logic.
• Integrate with enterprise systems like Salesforce, Snowflake, SQL Server, and REST/SOAP endpoints.
• Design and manage error handling, fault tolerance, and process orchestration within CAI.
• Collaborate with solution architects to translate business requirements into scalable integration designs.
• Participate in code reviews, performance tuning, and CI/CD deployments.
• Document technical designs, configurations, and support operational readiness.

Skills

XQuery

JSON/XML parsing

API integrations

REST services

SOAP services

Process orchestration

CI/CD pipelines

Error handling

Tools

Informatica IICS CAI

Cloud Data Integration (CDI)

IDMC

Salesforce

Snowflake

SQL Server

API Gateway

Job description

LumenData is a leading provider of data management, cloud integration, and analytics services. We partner with enterprises to modernize their data ecosystems and accelerate digital transformation using technologies like Informatica Intelligent Data Management Cloud (IDMC), Snowflake, and advanced analytics platforms.

Role Overview

We are looking for a Senior Informatica Cloud Application Integration (CAI) Developer who will design, develop, and deploy API-led integrations and real-time orchestration solutions using Informatica IICS (CAI + CDI).

The ideal candidate is hands-on, collaborative, and has a strong understanding of integration patterns, XQuery, REST/SOAP APIs, and cloud-based architectures.

Key Responsibilities

• Design, develop, and implement end-to-end integrations using Informatica CAI and Cloud Data Integration (CDI).
• Build and maintain service connectors, process objects, and APIs for real-time and batch integrations.
• Develop XQuery and Expression transformations for data mapping and transformation logic.
• Integrate with enterprise systems such as Salesforce, Snowflake, SQL Server, and REST/SOAP endpoints.
• Design and manage error handling, fault tolerance, and process orchestration within CAI.
• Collaborate with solution architects to translate business requirements into scalable integration designs.
• Participate in code reviews, performance tuning, and CI/CD pipeline deployments.
• Document technical designs, configurations, and support operational readiness.

Required Skills & Experience

• 5–9 years of overall IT experience with at least 3+ years in Informatica IICS CAI.
• Strong hands-on experience in:
• XQuery, JSON/XML parsing, and API integrations
• Proficiency in building and deploying REST/SOAP services, process orchestration, and real-time integrations.
• Familiarity with IICS components such as Process Designer, Application Integration Console, and Secure Agents.
• Experience with error handling, logging, and retry mechanisms in CAI processes.
• Exposure to API Gateway / Cloud deployment models (AWS, Azure, GCP) is a plus.
• Good communication, analytical thinking, and problem-solving skills.

Nice to Have

• Experience integrating Salesforce, Workday, or Snowflake using CAI.
• Familiarity with IDMC, Data Quality (IDQ), or MDM components.
• Knowledge of Agile delivery frameworks.

Why Join LumenData

• Work on cutting-edge Informatica Cloud and Data Integration projects.
• Collaborate with data modernization experts across global enterprise clients.
• Opportunity to grow into Solution Architect or Lead Integration Consultant roles.