Description

You will design and implement integration workflows and ETL processes to connect data sources with target systems including Azure, Medius, and Workday.

Responsibilities

• Build and configure ETL processes to extract, transform, and load data between various applications and data warehouses.
• Maintain integration processes from ERP and other source systems to ensure data freshness for Power BI reporting.
• Configure systems to handle EDI message transmission and transformation in compliance with industry standards.
• Implement data validation mechanisms to ensure accuracy, consistency, and adherence to business rules.
• Optimize integration performance by identifying and resolving bottlenecks in existing workflows.

Required Skills

• 5+ years of experience in data integration and ingestion.
• Proficiency with Azure processes including ADF and Azure SQL DB.
• Strong SQL experience using SSMS, SSIS, and SSAS.
• Experience with Python and scripting languages such as JavaScript or Groovy.
• Hands-on experience managing and deploying APIs using SOAP, REST, XML, and JSON.
• Knowledge of integration patterns including Pub/Sub, Event-Driven Architecture, SOA, and iPaaS.
• Working knowledge of EDI X12/EDIFACT transaction sets.
• Experience with relational databases such as MS-SQL Server, Oracle, and MySQL.
• Competency with message queuing, caching, and complex mapping.

Preferred Skills

• Experience with JDBC and JMS adapters.

Key Skills

Education

Any Gradute