HamburgerMenu
hirist

Sonata Software - Informatica Consultant - SQL/ETL

SONATA SOFTWARE LTD
4 - 6 Years
Multiple Locations

Posted on: 23/09/2026

Job Description

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, you will be responsible for migration, designing, implementing, and optimizing end-to-end data integration solutions to support our organization's business objectives.

Roles & Responsibilities:

- Design, develop, and implement data integration flows using 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.

- Develop and maintain shell scripts for automation of integration tasks and file transfers.

- Collaborate with cross-functional teams to gather integration requirements.

- Design and implement SQL queries, stored procedures, and data transformations.

- Perform performance tuning and optimization of integration workflows.

- Troubleshoot, debug and resolve integration issues.

- Monitor data integration jobs and proactively address errors or discrepancies.

- Prepare and maintain technical documentation for integrations and workflows.

- Stay up to date with the latest IICS features and best practices.

- Mentor junior team members.

- Involvement in the entire migration process including Firewall tasks, testing, and hypercare support.

- Understand Framework concepts and support enhancements.

Requirements:

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

- 4 - 6 years of hands-on experience in IMFT, IICS, CAI, CDI, and B2B Gateway.

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

- Advanced skills in shell scripting (e.g., Bash, PowerShell) for automation.

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

- Excellent problem-solving skills.

Preferred Qualifications:

- Informatica certifications (e.g., Informatica Cloud Data Integration Specialist).

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

- Knowledge of API management and RESTful services.

- Strong interpersonal and communication skills.

info-icon

Did you find something suspicious?

Similar jobs that you might be interested in

Loading chat...