Data Integration Developer

Summary

Join our team as an Integration Developer to contribute to a critical enterprise integration project. You will collaborate with stakeholders, design, develop, and optimize data pipelines using SSIS and related tools. This hands-on role requires expertise in SSIS, KingswaySoft, and CData connectors to integrate Odoo ERP and our Reporting System. You will finish the first record type integration and expand the solution to handle multiple record types running in parallel. The position offers a flexible remote engagement in a collaborative, results-driven environment. You will have an immediate impact on a critical project and work with modern ETL tools and ERP systems.

Requirements

• Proven experience developing ETL workflows with SSIS
• Hands-on expertise with KingswaySoft Integration Toolkit for SSIS
• Experience using CData connectors, specifically for Odoo or similar ERP systems
• Strong SQL Server / T-SQL skills
• Solid understanding of relational data models and database optimization
• Ability to work independently and collaboratively in a fast-paced, remote environment
• Excellent communication skills in English

Responsibilities

• Collaborate with stakeholders to understand data mapping requirements between Odoo ERP and CertaGold Reporting System
• Design, develop, and deploy SSIS packages utilizing KingswaySoft and CData Odoo connectors
• Optimize ETL workflows for performance and scalability
• Document data flows, mapping specifications, and integration processes
• Work with other developers to ensure parallel workstreams and timely delivery of all record types
• Troubleshoot and resolve integration issues, ensuring data integrity and consistency
• Contribute to best practices for error handling, monitoring, and deployment

Preferred Qualifications

• Familiarity with Odoo ERP’s data structure and modules
• Experience with REST APIs, JSON, or custom SSIS script tasks
• Experience with CI/CD for data pipelines
• Knowledge of reporting tools or BI platforms

Benefits

• Immediate impact on a critical enterprise integration project
• Work with modern ETL tools and ERP systems
• Collaborative, results-driven environment
• Flexible remote engagement