Data Integration Specialist

Data Integration SpecialistJob Summary:Our client is seeking a Data Integration Specialist with experience in Azure, SQL, and data warehousing to support their growing team of developers. The ideal candidate will play a pivotal role in transitioning the acquired company's systems to their platform, assisting with critical go-live phases and future initiatives. This position is integral to meeting project deadlines and ensuring a seamless migration off their current integration tool, Dell Boomi, to Azure.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.#IND#ZP#ZIP#ZR

Created: 2025-02-17