Data Integration Specialist

Key Responsibilities:

• Design and Develop Integration Solutions: Create and implement integration workflows, understanding business requirements, data sources, and target systems.
• Build Data Integration Processes: Develop and configure processes to extract, transform, and load (ETL) data between various systems, including data warehouses, Azure, Medius, Workday and other applications.
• Maintain Data Warehouse: Create and maintain integration processes from ERP systems and other source systems into a data warehouse to maximize uptime and fresh data to be fed into Power BI reports for business users.
• Implement EDI File Transmission: Configure integration systems to handle the transmission and transformation of EDI messages between trading partners, ensuring compliance with industry standards.
• Integrate with Workday and Medius: Establish seamless integration between Azure and Workday, as well as Medius, to enable smooth accounts payable automation and streamline invoice processing.
• Collaborate with Stakeholders: Work closely with business analysts, data architects, system administrators, and other team members to gather requirements and ensure effective integration solutions.
• Ensure Data Quality: Implement data validation mechanisms to ensure data accuracy, consistency, and adherence to business rules.
• Optimize Performance: Analyze and optimize integration processes, identifying and resolving performance bottlenecks.
• Document and Report: Maintain clear and comprehensive technical documentation of integration processes, mappings, configurations, and workflows. Generate reports and provide insights into integration activities.
• Continuous Improvement: Stay updated with the latest industry trends, technologies, and best practices related to Azure, Dell Boomi, data integration, and the systems used (Workday, Medius, etc.).

Qualifications:

• Experience using Azure processes (ADF, Azure SQL DB, etc.)
• Heavy SQL experience (SSMS, SSIS, SSAS)
• Proficiency in building Boomi processes, managing/deploying/supporting APIs, and leveraging common frameworks such as message queuing, caching, complex mapping, and scripting (JavaScript, Groovy).
• Proficiency with integration technologies such as HTTP Web Services (SOAP/REST), XML, JSON, and Flat file.
• Experience with JDBC adapter, JMS adapter, Web Service (SOAP and REST), and WSDL.
• Understanding of enterprise integration tools, middleware technologies, and data integration patterns, including Pub/Sub Messaging, EIP, Event-Driven Architecture, SOA, and iPaaS.
• Experience in maintaining existing APIs, reviewing, and enhancing code.
• Experience with Boomi Atom Management, Process Reporting, Deployments, and API Management.
• Familiarity with various relational databases like Oracle, MS-SQL Server, and MySQL.
• Knowledge of EDI X12/EDIFACT transaction sets and working with real-time and scheduled processes.
• Strong technical designing, interface designing, research and development skills, client interaction, onsite coordination, estimations, application development, documentation, and code review