Responsabilities
- 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.
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.
Nice to have
- 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.
Why join us
- Immediate impact on a critical enterprise integration project.
- Work with modern ETL tools and ERP systems.
- Collaborative, results-driven environment.
- Flexible remote engagement.
Similar Jobs
What We Do
Your World-Class development team is closer than you think!
Building the right development team, it’s the most crucial element to your project’s success. Located in Hermosillo, Mexico (2.5 hours from the US border) We strive to provide independent and fully-managed software development teams, bringing top talent to your projects, taking away the hustle of turnover, training and scaling.
What we do?
TEAM AUGMENTATION
We assign a dedicated developer (or a team of developers) directly to you. The dedicated resource is managed by you, using your working methodologies and tools.
We provide world class talent in different technologies, levels of experience, and with a english speaking degree. Communication and Culture is not a problem!
What we do? We...
FULLY MANAGED DEVELOPMENT TEAM
If you need a full development team, managed by a seasoned project manager, that includes a talented group of developers, designers and testers that will help you bring your projects to success, this is the best option for your company or start up.
APP DEVELOPMENT
We work hand in hand with our customer covering the complete development cycle, creating a seamless process, turning your Idea into a fully launched product.