Sonata Software - Informatica Consultant - SQL/ETL in Bangalore, भारत

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 https://jobeax.com/link/6huqaOxKtXBuykyh 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 https://jobeax.com/link/7LD7RHq9dMaspQ8e & 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 https://jobeax.com/link/Cexs453KRiH2S1rJ 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. (ref:hirist.tech)