drjobs Data Integration Specialist

Data Integration Specialist

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Dallas - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Role: Data Integration Specialist

Location: Dallas TX - Hybrid

Duration: 6 months CTH

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 data integration and the systems used (Workday Medius etc.).

Qualifications:

  • SSIS ADF SQL Data Ingestion
  • Heavy experience using Azure processes (ADF Azure SQL DB etc.)
  • SQL experience (SSMS SSIS SSAS)
  • Python experience
  • Proficiency 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.
  • 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.

Employment Type

Full-time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.