Key Responsibilities : Design & Develop Integration Solutions Create and implement integration workflows based on business requirements, data sources, and target systems. Build Data Integration Processes Develop and configure ETL (Extract, Transform, Load) processes to transfer data between various systems, including data warehouses, Azure, Medius, Workday, and other applications. Maintain Data Warehouse Create and manage integration processes between ERP systems and other source systems to a data warehouse, ensuring maximum uptime and up-to-date data feeding into Power BI reports for business users. Implement EDI File Transmission Configure integration systems to manage the transmission and transformation of EDI messages between trading partners, ensuring industry standard compliance. Integrate with Workday & Medius Establish seamless integration between Azure, Workday, and Medius to automate accounts payable processes and streamline invoice management. Collaborate with Stakeholders Work with business analysts, data architects, system administrators, and other team members to gather requirements and ensure the successful implementation of integration solutions. Ensure Data Quality Implement data validation mechanisms to guarantee accuracy, consistency, and adherence to business rules. Optimize Performance Analyze and optimize integration processes to identify and resolve performance bottlenecks. Document & Report Maintain clear and comprehensive documentation for integration processes, mappings, configurations, and workflows. Generate reports and provide insights into integration activities. Continuous Improvement Stay updated on industry trends, new technologies, and best practices in data integration, Azure, Dell Boomi, and other systems (e.g., Workday, Medius). Qualifications : Technical Experience : Strong experience with Azure technologies, including ADF (Azure Data Factory), Azure SQL DB, and related processes. Advanced proficiency in SQL, including experience with SSMS, SSIS, SSAS. Integration Technologies : Expertise in building Boomi processes and supporting APIs, including message queuing, caching, complex mappings, and scripting (JavaScript, Groovy). Proficiency in integration technologies such as HTTP Web Services (SOAP/REST), XML, JSON, and flat files. Experience with JDBC adapter, JMS adapter, Web Service (SOAP and REST), and WSDL. Enterprise Integration & Middleware : Solid understanding of enterprise integration tools and middleware technologies, including patterns like Pub/Sub Messaging, Event-Driven Architecture, SOA, and iPaaS. API Management & Maintenance : Experience maintaining APIs, reviewing code, and enhancing existing integration solutions. Familiarity with Boomi Atom Management, Process Reporting, Deployments, and API Management. Database Knowledge : Experience with relational databases like Oracle, MS-SQL Server, and MySQL. EDI & Transaction Sets : Knowledge of EDI X12/EDIFACT transaction sets and real-time and scheduled EDI processes. Skills : Strong technical, interface design, and research skills. Ability to interact with clients, coordinate on-site tasks, estimate workloads, develop applications, document solutions, and perform code reviews.
