Informatica Consultant IICS

Sonata Software; Bengaluru; Hybrid; INR 1,500,000 - 2,300,000; Full time

Job summary

Sonata Software is seeking a Senior Integration Engineer in Bengaluru with 4-6 years of experience in Informatica Intelligent Cloud Services (IICS), MFT, CAI, CDI and B2B Gateway. The role focuses on migration, design, implementation, and optimization of end-to-end data integration solutions to support business objectives.

The candidate will understand the custom framework, contribute to enhancements and migration activities, and mentor junior team members while ensuring secure and scalable data

Qualifications

• Bachelor's degree in CS/IT or related field.
• 4-6 years hands-on experience with IMFT, IICS, CAI, CDI and B2B Gateway.
• Strong skills in MFT technologies and shell scripting.
• Proficiency in SQL and database tech (Oracle, SQL Server, PostgreSQL).

Responsibilities

• Design, develop, and implement data integration flows with IICS, CAI, CDI and B2B Gateway.
• Configure and optimize MFT solutions for secure data exchange.
• Develop shell scripts to automate integration tasks and data transfers.
• Collaborate with cross-functional teams to gather requirements and translate into solutions.
• Write and optimize SQL queries, procedures, and data transformations.
• Tune performance and ensure scalability of integration workflows.
• Troubleshoot and resolve data integration issues; monitor jobs and address data discrepancies.
• Prepare technical docs for integrations, workflows, and processes.
• Stay updated with IICS features and best practices; mentor juniors.

Skills

Informatica MFT

CDI

CAI

Education

Bachelor's degree in CS/IT

Job description

Locations

Bengaluru

Minimum Experience

4

Maximum Experience

6

Mandatory Skills

Informatica MFT, CDI, CAI

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

Job Title

Informatica Consultant

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