Data Integration Engineer

We are looking for a Senior Data Integration Engineer with expertise in Alteryx, Oracle Data Integrator (ODI) and MuleSoft .The ideal candidate will have a strong background in ETL/ELT development, API integrations . This role involves designing and optimizing data pipelines, integrating data from multiple enterprise applications, and ensuring seamless data flow across the organization. Key Responsibilities: ETL/ELT Development & Data Integration:

• Develop and maintain data workflows in Alteryx , ensuring efficient data transformation and movement.
• Administer Alteryx Server Environments and SDLC Processes.
• Design, develop, and implement ODI mappings, load plans, and workflows to support data integration across multiple modules.
• Build, test, and deploy ETL/ELT pipelines for Oracle ADW , optimizing data processing performance.
• Implement API-based integrations using MuleSoft to connect enterprise applications (Oracle EBS, Oracle Fusion, Salesforce, etc.).
• Write complex SQL queries with multiple joins to automate and manipulate data extracts in Alteryx.
• Design and develop MuleSoft-based integrations for seamless data exchange between cloud and on-premise systems.
• Work with REST/SOAP APIs to enable secure data transmission across platforms.
• Ensure robust error handling, logging, and monitoring mechanisms in Alteryx and MuleSoft integrations.
• Configure and manage project permissions while providing periodic reports on Alteryx and MuleSoft server usage .
• Create and maintain Standard Operating Procedures (SOPs) and technical documentation for Alteryx workflows, MuleSoft APIs, and ODI processes .

• 5+ years of experience in ETL/ELT development, data integration, and enterprise data warehousing .
• Strong hands-on experience with Oracle Data Integrator (ODI), Alteryx, and MuleSoft (or comparable products like Tibco, RabbitMQ or other WebServices platform)
• Expertise in Oracle ADW, SQL, and PL/SQL with the ability to write and optimize complex queries.
• Experience in designing and implementing APIs using MuleSoft for enterprise applications.
• Strong knowledge of data modeling, data warehouse concepts, and performance tuning .
• Experience working with Oracle EBS, Oracle Fusion, Salesforce, or other enterprise applications .
• Familiarity with BI tools (OAC, OBIEE, Tableau ,Power BI ) .
• Ability to manage and coordinate offshore/onshore teams .
• Excellent problem-solving, communication, and interpersonal skills .
• Experience in machine learning/data science projects is a plus.

• MuleSoft Certified Developer or Architect .
• ODI Certified Implementation Specialist .
• Experience with other ELT/ETL tools like Informatica, Talend, or Azure Data Factory.

• Opportunity to work on cutting-edge data integration projects with ODI, Alteryx, and MuleSoft .
• Be part of a collaborative, innovative, and forward-thinking team .
• Exposure to Oracle Cloud technologies and enterprise data strategies .
• Competitive compensation, professional growth opportunities, and a dynamic work environment .