Data Integration Specialist

Job Description

Key Responsibilities:

Design and Develop Integration Solutions : Create and implement integration workflows, gathering business requirements, identifying data sources, and integrating with target systems.

Develop Data Integration Processes : Build and configure ETL (Extract, Transform, Load) processes for seamless data flow between systems, including data warehouses, Azure, Workday, Medius, and other applications.

Maintain Data Warehouse Integration : Ensure the effective integration of ERP systems and other sources into data warehouses, ensuring data is up-to-date for Power BI reports and business analysis.

Implement EDI File Transmission : Configure and manage EDI message transmission between trading partners, ensuring compliance with industry standards.

Workday and Medius Integration : Integrate Azure with Workday and Medius for smooth accounts payable automation and optimized invoice processing.

Collaboration with Stakeholders : Work with business analysts, data architects, and system administrators to gather requirements and deliver optimal integration solutions.

Ensure Data Quality : Implement validation mechanisms to ensure accurate, consistent, and reliable data that meets business standards.

Optimize Performance : Analyze integration processes to identify performance bottlenecks and implement improvements for higher efficiency.

Documentation and Reporting : Maintain clear documentation on integration processes, configurations, and workflows. Provide insightful reports on integration activities.

Continuous Improvement : Stay current with trends in Azure, Dell Boomi, API integrations, and industry best practices to improve integration processes.

Qualifications:

Experience with Azure tools such as Azure Data Factory (ADF) and Azure SQL Database.

Extensive SQL experience with tools like SSMS, SSIS, and SSAS.

Expertise in building and managing Dell Boomi processes, APIs, and utilizing frameworks such as message queuing, complex mapping, and scripting (JavaScript, Groovy).

Proficient in integration technologies such as HTTP Web Services (SOAP/REST), XML, JSON, and flat files.

Familiarity with JDBC, JMS adapters, and Web Service protocols (SOAP/REST/WSDL).

Knowledge of enterprise integration patterns like Pub/Sub Messaging, EIP, Event-Driven Architecture, SOA, and iPaaS.

Experience maintaining and enhancing existing APIs.

Proficient in Boomi Atom Management, process reporting, deployments, and API management.

Strong understanding of relational databases (Oracle, MS-SQL Server, MySQL).

Knowledge of EDI X12/EDIFACT transaction sets and managing both real-time and scheduled processes.

Strong skills in technical design, interface design, client interaction, development, and code review.

Company Description

RightStaff was recognized by INC 5000 as one of the fastest growing companies in the nation. RightStaff's unique process and approach to staffing has enabled us to provide services that far exceed our competitors in the areas of resource qualification, delivery and performance measurement.

Voted Best Places to work in the Dallas/Fort Worth area. RightStaff is a nationwide IT solutions partner. We offer a full range of services, covering recruitment, project management, rollouts, project deployment, staffing, consulting services, and direct hire placement.

RightStaff is continuing to grow our service offerings every year, offers excellent compensation, and a great opportunity for career growth.

Company Description

RightStaff was recognized by INC 5000 as one of the fastest growing companies in the nation. RightStaff's unique process and approach to staffing has enabled us to provide services that far exceed our competitors in the areas of resource qualification, delivery and performance measurement.\r\n\r\nVoted Best Places to work in the Dallas/Fort Worth area. RightStaff is a nationwide IT solutions partner. We offer a full range of services, covering recruitment, project management, rollouts, project deployment, staffing, consulting services, and direct hire placement. \r\n\r\nRightStaff is continuing to grow our service offerings every year, offers excellent compensation, and a great opportunity for career growth.