Informatica Consultant(4yrs): Banaglore

Sigma Allied Services; Bengaluru; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Sigma Allied Services in Bengaluru is seeking a Senior Integration Engineer with 4-6 years of hands-on experience in Informatica Intelligent Cloud Services (IICS), MFT and CAI/CDI. You will design, migrate and optimize end-to-end data integration workflows to support key business objectives and ensure secure data exchanges with external systems.

You will also work on the migration framework, write shell scripts for automation, tune performance, and mentor junior team members while staying

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 4-6 years hands-on experience in IMFT, IICS, CAI, CDI, and B2B Gateway.
• Strong proficiency in MFT technologies.
• Advanced skills in shell scripting (Bash/PowerShell) for automation.
• Expertise in SQL programming and databases (Oracle, SQL Server, PostgreSQL).
• Solid understanding of data integration, ETL, and data warehousing.

Responsibilities

• Design, develop, and implement data integration flows using IICS, CAI, CDI, and B2B Gateway.
• Configure and optimize MFT solutions for secure data exchanges.
• Develop and maintain shell scripts for automation and data transfers.
• Collaborate with cross-functional teams to gather integration requirements.
• Design SQL queries, stored procedures, and data transformations.
• Perform performance tuning of integration workflows for scalability.
• Troubleshoot and resolve integration issues and data discrepancies.
• Monitor data integration jobs and address errors and performance issues.
• Prepare and maintain technical documentation for integrations and workflows.
• Stay updated with IICS features and best practices.

Skills

IICS

MFT

CAI

CDI

B2B Gateway

Shell scripting

SQL

Oracle

Education

Bachelor's degree in CS/IT

Tools

Bash

PowerShell

SQL Server

Oracle

PostgreSQL

Job description

andatory Skills/ Skill to Evaluate

Informatica-MFT,-CDI,-CAI

Experience

4 to 6 Years

Location

Bengaluru

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 organization's 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

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.
• 11)Mentor junior team members, providing guidance and support in developing their IICS and data integration skills.
• 12) Invovement in entire migration process including Firewall tasks, support in development and other tests and hypercare support.
• 13) Understand Framework concepts and support in any enhancements in Framework

Requirements:

• 1) Bachelor's degree in Computer Science, Information Technology, or related field.
• 2) 4-6 years of hands-on experience in IMFT, Informatica Intelligent Cloud Services (IICS), Cloud Application Integration (CAI), and Cloud Data Integration (CDI), B2B Gateway.
• 3) Strong proficiency in managed file transfer (MFT) technologies.
• 4) Advanced skills in shell scripting (e.g., Bash, PowerShell) for automation and customization of integration workflows.
• 5) Expertise in SQL programming and database technologies (e.g., Oracle, SQL Server, PostgreSQL).
• 6) Solid understanding of data integration concepts, ETL processes, and data warehousing principles.
• 7) Experince in Cloud B2B Gateway
• 8) Excellent problem-solving skills with the ability to troubleshoot complex integration issues.

Preferred Qualifications:

• 1) Informatica certifications (e.g., Informatica Cloud Data Integration Specialist) or other relevant certifications.
• 2) Familiarity with cloud platforms (e.g., AWS, Azure) and their integration capabilities.
• 3) Knowledge of API management and RESTful services.
• 4) Strong interpersonal and communication skills with the ability to collaborate effectively with stakeholders at all levels.

Project Details

As part of the migration initiative, interfaces are being migrated to the Informatica platform and integrated with the Framework. Additionally, certain applications will also be migrated to Informatica as part of this transformation.

Shift Timings

6:00 AM IST to 3:00 PM IST