
Integration Developer
- Ringoes, NJ
- Permanent
- Full-time
- Design and develop RESTful API integrations between Datacor ERP and external platforms.
- Design and implement integration workflows using custom middleware or enterprise integration platforms such as Azure Logic etc.., ensuring efficient orchestration of data across systems.
- Write and optimize SQL queries to extract, transform, and analyze data from ERP and integrated systems.
- Develop and maintain reports and dashboards using Power BI or similar business intelligence tools.
- Ensure secure, scalable, and reliable communication between systems.
- Monitor integration performance and implement logging, alerting, and error handling.
- Collaborate with ERP analysts and business stakeholders to define integration requirements and data mappings.
- Maintain technical documentation for integrations, including API specifications, data flows, and troubleshooting guides.
- Support testing, validation, and deployment of integration workflows.
- Work with JSON data formats for API payloads, data transformation, and validation.
- Support data governance initiatives, ensuring data quality, consistency, and compliance across systems.
- Collaborate with data teams to support data lake architecture and enterprise analytics.
- 3-5+ years of experience in API development and system integration.
- Proficiency in RESTful APIs, JSON, XML, and webhooks.
- Strong SQL skills and experience working with relational databases.
- Experience with integration platforms or custom middleware development.
- Strong programming/scripting skills (e.g., Python, JavaScript, VB Script etc.).
- Familiarity with authentication protocols (OAuth2, API keys, etc.).
- Experience with Power BI or similar reporting/analytics platforms.
- Familiarity with data transformation, mapping, and validation techniques.
- Experience with DB/400 database and HTML a plus.
- Experience working with ERP systems and logistics platforms.
- Experience integrating with Datacor ERP, BeyondTrucks, or IntelliTrans.
- Knowledge of EDI standards and transportation/logistics data formats.
- Familiarity with event-driven architecture and message queues (e.g., Kafka, RabbitMQ).
- Exposure to CI/CD pipelines and version control for integration deployment.
- Understanding of data lake architecture and how integration data contributes to enterprise analytics.
- Experience with DB2/400 and AS/400 environments for legacy system integration.
- Proficiency in VB Script for automation and scripting tasks.
- Strong understanding of HTML for building and customizing web-based interfaces.
- Experience deploying and managing web applications using IIS (Internet Information Services).
- Ability to troubleshoot and optimize integration workflows across diverse platforms.
- Familiarity with Agile development methodologies and cross-functional collaboration.
- Strong documentation skills for technical specifications, data mappings, and support guides.
- Ability to work independently and manage multiple integration projects simultaneously.