Informatica Consultant

Sonata Software; Bengaluru; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Sonata Software seeks a Senior Integration Engineer with 4-6 years of hands-on experience in Informatica Intelligent Cloud Services (IICS), MFT, CAI, CDI and B2B Gateway to design, migrate, and optimize end-to-end data integration solutions for the organization.

You will develop shell scripts for automation, collaborate with cross-functional teams, and ensure scalable, reliable data pipelines while mentoring junior members and supporting migration and hypercare activities.

Qualifications

• Bachelor's degree in computer science, information technology, or related field.
• 4-6 years hands-on experience in IMFT, Informatica Intelligent Cloud Services (IICS), Cloud Application Integration (CAI), and Cloud Data Integration (CDI), B2B Gateway.
• Strong proficiency in managed file transfer (MFT) technologies.
• Shell scripting (Bash/PowerShell) for automation and customization of integration workflows.
• Expertise in SQL programming and database technologies (e.g., Oracle, SQL Server, PostgreSQL).
• Understanding of data integration concepts, ETL processes, and data warehousing principles.
• Experience in Cloud B2B Gateway.

Responsibilities

• Design, develop, and implement data integration flows using IICS, CAI, CDI, and B2B Gateway.
• Configure and optimize MFT solutions for secure data exchanges between internal and external systems.
• Develop and maintain shell scripts for automation of integration tasks, data processing, and file transfers.
• Collaborate with cross-functional teams to gather integration requirements and translate them into technical solutions.
• Design and implement SQL queries, stored procedures, and data transformations to support integration processes.
• Perform performance tuning and optimization of integration workflows for scalability and reliability.
• Troubleshoot, debug and resolve integration issues; monitor data pipelines for errors and discrepancies.
• Prepare and maintain technical documentation for integrations, workflows, and processes.
• Stay current with IICS features and best practices to leverage platform capabilities.
• Mentor junior team members in IICS and data integration skills.
• Involvement in migration processes including firewall tasks, development support, tests, and hypercare.
• Understand Framework concepts and support enhancements in Framework.

Skills

IICS

MFT

CAI

CDI

SQL

Shell scripting

ETL concepts

Cloud platforms

Education

Bachelor's degree in CS/IT

Job description

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 Qualification

Informatica hands on experience in IMFT, CDI, CAI

Job Title

• 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.


• Configure and optimize managed file transfer (MFT) solutions to facilitate secure and efficient data exchanges between internal and external systems.


• Develop and maintain shell scripts for automation of integration tasks, data processing, and file transfers.


• Collaborate with cross-functional teams to gather integration requirements and translate them into technical solutions.


• Design and implement SQL queries, stored procedures, and data transformations to support integration processes.


• Perform performance tuning and optimization of integration workflows to ensure scalability and reliability.


• Troubleshoot, debug and resolve integration issues, ensuring seamless operation of data pipelines.


• Monitor data integration jobs and proactively address errors, performance issues, or data discrepancies.


• Prepare and maintain technical documentation for integrations, workflows and processes.


• Stay up to date with the latest IICS features and best practices, ensuring that solutions leverage the latest capabilities of the platform.


• Mentor junior team members, providing guidance and support in developing their IICS and data integration skills.


• Involvement in entire migration process including Firewall tasks, support in development and other tests and hypercare support.


• Understand Framework concepts and support in any enhancements in Framework

Requirements

• Bachelor's degree in computer science, Information Technology, or related field.


• 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.


• Strong proficiency in managed file transfer (MFT) technologies.


• Advanced skills in shell scripting (e.g., Bash, PowerShell) for automation and customization of integration workflows.


• Expertise in SQL programming and database technologies (e.g., Oracle, SQL Server, PostgreSQL).


• Solid understanding of data integration concepts, ETL processes, and data warehousing principles.


• Experience in Cloud B2B Gateway


• Excellent problem-solving skills with the ability to troubleshoot complex integration issues.

Preferred Qualifications

• Informatica certifications (e.g., Informatica Cloud Data Integration Specialist) or other relevant certifications.


• Familiarity with cloud platforms (e.g., AWS, Azure) and their integration capabilities.


• Knowledge of API management and RESTful services.


• Strong interpersonal and communication skills with the ability to collaborate effectively with stakeholders at all levels.