Informatica Data Integration Consultant

Title: Informatica Data Integration Consultant

Location: Offshore Remote

Time Avalability : 3 am to 12 pm PST

Role Overview

We are looking for a dynamic and hands-on Informatica Data Integration Developer with 4 to 5 years of experience to join our data engineering team. In this role, you will design, develop, and maintain robust data integration solutions using Informatica Intelligent Cloud Services (IICS), covering both Cloud Application Integration (CAI) and Cloud Data Integration (CDI) . You will also handle complex B2B data exchanges, implement data quality validation checks, and build scalable data transformation logic to support our growing enterprise data ecosystem.

Key Responsibilities

• Data Integration & Pipelines: Design, develop, test, and deploy end-to-end data pipelines using Informatica CDI for batch processing and CAI for real-time/event-driven application integration with source systems like SAP, Mulesoft, Salesforce
• B2B Integration: Implement and manage B2B integration workflows, handling various data formats (EDI, XML, JSON, flat files) and partner onboarding processes.
• Data Transformation & Quality: Build complex data transformation logic and incorporate Data Quality (CDQ) rules (profiling, cleansing, standardization, and deduplication) directly into the integration pipelines.
• API & Web Services Integration: Integrate disparate systems using REST/SOAP APIs and real-time messaging patterns via CAI guides and processes.
• Optimization & Troubleshooting: Tune performance of complex mappings, bottlenecks, and data flows; troubleshoot and resolve production issues promptly.
• Informatica CDI (Cloud Data Integration): Proficient in building advanced mappings, mapping tasks, taskflows, and synchs.
• Informatica CAI (Cloud Application Integration): Strong experience in creating processes, guides, service connectors, and action listeners.
• Database & SQL: Strong SQL scripting skills and experience working with relational databases , noSQL and cloud data warehouses
• API Knowledge: Familiarity with RESTful APIs, JSON, XML, and web service protocols.
• Informatica Cloud certification (IICS Developer or Administrator).
• Experience with CI/CD deployment pipelines for IICS code migration.
• Should have the abillity to write custom code and shell scripts for any customizations in the data integration piipeline

MUST Have Qualifications: Certification in Informatica Cloud Integration (IICS), CAI ,CDI , IDMC