Description

You will design, develop, and maintain integration workflows and ETL processes across various enterprise systems.

Responsibilities

• Build and configure ETL processes to extract and transform data between source systems, data warehouses, and applications like Workday and Medius.
• Maintain data warehouse integration processes from ERP systems to ensure data freshness for Power BI reporting.
• Configure EDI file transmission systems to handle message transformation and 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 and APIs.

Required Skills

• 5+ years of experience in data integration and ETL development.
• Strong proficiency with Azure processes including ADF and Azure SQL DB.
• Heavy SQL experience using SSMS, SSIS, and SSAS.
• Expertise in building Boomi processes, including Atom Management, Process Reporting, and API Management.
• Experience with HTTP Web Services (SOAP/REST), XML, JSON, and Flat files.
• Hands-on experience with JDBC, JMS, and WSDL adapters.
• Knowledge of integration patterns such as Pub/Sub, Event-Driven Architecture, SOA, and iPaaS.
• Proficiency in scripting with JavaScript or Groovy for complex mapping.
• Experience working with relational databases including MS-SQL Server, Oracle, and MySQL.

Preferred Skills

• Knowledge of EDI X12 and EDIFACT transaction sets.
• Experience with message queuing and caching frameworks.

Key Skills

Education

Any Gradute