Data Engineer Job at Optomi, Dallas, TX

S0xBNGEyc25vbnJud1JheG45MlVMTk9wTGc9PQ==
  • Optomi
  • Dallas, TX

Job Description

Key Responsibilities :

  • Design & Develop Integration Solutions
  • Create and implement integration workflows based on business requirements, data sources, and target systems.
  • Build Data Integration Processes
  • Develop and configure ETL (Extract, Transform, Load) processes to transfer data between various systems, including data warehouses, Azure, Medius, Workday, and other applications.
  • Maintain Data Warehouse
  • Create and manage integration processes between ERP systems and other source systems to a data warehouse, ensuring maximum uptime and up-to-date data feeding into Power BI reports for business users.
  • Implement EDI File Transmission
  • Configure integration systems to manage the transmission and transformation of EDI messages between trading partners, ensuring industry standard compliance.
  • Integrate with Workday & Medius
  • Establish seamless integration between Azure, Workday, and Medius to automate accounts payable processes and streamline invoice management.
  • Collaborate with Stakeholders
  • Work with business analysts, data architects, system administrators, and other team members to gather requirements and ensure the successful implementation of integration solutions.
  • Ensure Data Quality
  • Implement data validation mechanisms to guarantee accuracy, consistency, and adherence to business rules.
  • Optimize Performance
  • Analyze and optimize integration processes to identify and resolve performance bottlenecks.
  • Document & Report
  • Maintain clear and comprehensive documentation for integration processes, mappings, configurations, and workflows. Generate reports and provide insights into integration activities.
  • Continuous Improvement
  • Stay updated on industry trends, new technologies, and best practices in data integration, Azure, Dell Boomi, and other systems (e.g., Workday, Medius).

Qualifications :

  • Technical Experience :
  • Strong experience with Azure technologies, including ADF (Azure Data Factory), Azure SQL DB, and related processes.
  • Advanced proficiency in SQL, including experience with SSMS, SSIS, SSAS.
  • Integration Technologies :
  • Expertise in building Boomi processes and supporting APIs, including message queuing, caching, complex mappings, and scripting (JavaScript, Groovy).
  • Proficiency in integration technologies such as Web Services (SOAP/REST), XML, JSON, and flat files.
  • Experience with JDBC adapter, JMS adapter, Web Service (SOAP and REST), and WSDL.
  • Enterprise Integration & Middleware :
  • Solid understanding of enterprise integration tools and middleware technologies, including patterns like Pub/Sub Messaging, Event-Driven Architecture, SOA, and iPaaS.
  • API Management & Maintenance :
  • Experience maintaining APIs, reviewing code, and enhancing existing integration solutions.
  • Familiarity with Boomi Atom Management, Process Reporting, Deployments, and API Management.
  • Database Knowledge :
  • Experience with relational databases like Oracle, MS-SQL Server, and MySQL.
  • EDI & Transaction Sets :
  • Knowledge of EDI X12/EDIFACT transaction sets and real-time and scheduled EDI processes.
  • Skills :
  • Strong technical, interface design, and research skills.
  • Ability to interact with clients, coordinate on-site tasks, estimate workloads, develop applications, document solutions, and perform code reviews.

Job Tags

Similar Jobs

CVS Health

Staff Pharmacist Job at CVS Health

 ...Location :1950 32ND AVE. S, Grand Forks, North Dakota Job ID :R0448442 Category :Pharmacy Sub Category :Pharmacist Remote :On-Site Description Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our... 

CoolSys

HVAC/R Service Technician - Light Commercial Job at CoolSys

 ...remodels, service & maintenance; and energy solutions, including controls and lighting.CoolSys serves customers in the retail, commercial, food service, educational, healthcare, and industrial markets. Headquartered in Southern California, CoolSys has more than 2,000... 

Keurig Dr Pepper

Relief Sales Manager Job at Keurig Dr Pepper

 ...accountable for retention and penetration of large format customers by geography and handling on-premise customers. Supporting Keurig Dr Pepper brands like 7UP, Snapple, Core, Bai and other fan favorites to retail stores within the assigned territory. Shift and Schedule... 

Vivo Inc.

Part Time Graphic Designer Job at Vivo Inc.

VIVO is a U.S. based company that designs, manufactures, and supplies a diverse selection of products across multiple unique product markets...  ..., onsite in Goodfield, IL, averaging 20 hours per week. The Graphic Designer is primarily responsible for product image design work... 

CARDIOCOMMAND INC

Manufacturing Assembler Job at CARDIOCOMMAND INC

 ...Job Description Job Description Essential functions include using hand tools and operating production equipment to manufacture medical devices and ancillary products. Following drawings, guidelines, and/or diagrams to ensure product specifications and tolerance levels...