Informatica Consultant

Sigma Allied Services; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Sigma Allied Services in Bengaluru, India is seeking a Senior Integration Engineer with 4-6 years of hands-on experience in Informatica IICS, MFT, and Cloud B2B Gateway to design, migrate, and optimize end-to-end data integration solutions.

You will work on CAI/CDI, develop automation scripts, craft SQL queries, and ensure scalable, reliable data pipelines while collaborating with cross-functional teams and maintaining technical documentation.

Qualifications

• 4-6 years of hands-on experience with Informatica IICS, MFT, CAI/CDI.
• Experience migrating and integrating data across platforms.
• Familiarity with cloud-based data integration patterns.

Responsibilities

• Design, develop, and implement data integration flows using IICS, CAI, CDI and B2B Gateway.
• Configure and optimize MFT for secure data exchanges.
• Develop and maintain shell scripts for automation of integration tasks, data processing, and file transfers.
• Collaborate with cross-functional teams to gather integration requirements.
• Design SQL queries, stored procedures, and data transformations to support integration processes.
• Tune performance of integration workflows for scalability and reliability.
• Troubleshoot and resolve integration issues to ensure seamless data pipelines.
• Monitor data integration jobs and address errors and discrepancies.
• Prepare and maintain technical documentation for integrations and workflows.
• Stay up to date with IICS features and best practices.

Skills

Informatica IICS

MFT (Managed File Transfer)

Cloud B2B Gateway

SQL

Shell scripting

Education

Informatica CDI/CAI/IMFT

Tools

Informatica IICS

MFT

CAI

CDI

Job description

Job Description

Senior Integration Engineer (4-6 Years Experience)

We are looking for a Senior Integration Engineer with 4-6 years of experience in Informatica Intelligent Cloud Services (IICS), Managed File Transfer (MFT) and Cloud B2B Gateway. As a key member of our integration team, candidate would be responsible for migration, designing, implementing, and optimizing end-to-end data integration solutions to support our organizations business objectives.

Candidate is also expected to understand the custom framework and support in the enhancement and migration activities.

Education Qualificaiton

Informatica hands on experience in IMFT, CDI, CAI

Open Positions

1

Roles & Responsibilities

• 1) Design, develop, and implement data integration flows using Informatica Intelligent Cloud Services (IICS), leveraging Cloud Application Integration (CAI) and Cloud Data Integration (CDI) and B2B Gateway capabilities.
• 2) Configure and optimize managed file transfer (MFT) solutions to facilitate secure and efficient data exchanges between internal and external systems.
• 3) Develop and maintain shell scripts for automation of integration tasks, data processing, and file transfers.
• 4) Collaborate with cross-functional teams to gather integration requirements and translate them into technical solutions.
• 5) Design and implement SQL queries, stored procedures, and data transformations to support integration processes.
• 6) Perform performance tuning and optimization of integration workflows to ensure scalability and reliability.
• 7) Troubleshoot, debug and resolve integration issues, ensuring seamless operation of data pipelines.
• 8) Monitor data integration jobs and proactively address errors, performance issues, or data discrepancies.
• 9) Prepare and maintain technical documentation for integrations, workflows and processes.
• 10)Stay up to date with the latest IICS features and best practices, ensuring that solutions leverage the latest capabilities of the platform.