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.