The role involves developing ETL workflows with SSIS, optimizing data pipelines, documenting processes, and collaborating with stakeholders for integration between Odoo ERP and a Reporting System.
We are seeking two Integration Developers with expertise in SSIS, KingswaySoft, and CData connectors to help complete and scale an ongoing integration project between Odoo ERP and our Reporting System.
You’ll join an active project, finish the first record type integration, and then expand the solution to handle multiple record types running in parallel. This is a hands-on role where you will design, develop, and optimize data pipelines using SSIS and related tools.
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.
Top Skills
Cdata Connectors
Kingswaysoft
SQL Server
Ssis
T-Sql
Similar Jobs
Marketing Tech • Real Estate • Software • PropTech • SEO
Lead the design and implementation of social media marketing tools, rapid prototyping using AI, and mentoring a small engineering team in a start-up environment.
Top Skills:
AWSDynamoDBElasticsearchJavaScriptKafkaKubernetesLangchainLangfuseNode.jsOpenrouterPostgresReactSqsTypescript
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The Lead Backend Developer will guide a team in delivering project work, mentor juniors, promote security practices, and learn new technologies.
Top Skills:
AWSJavaScriptNode.jsPostgres
.png){kind=avatar}
Fintech • Software
Engage with IMC Trading to explore potential opportunities after the NeurIPS 2024 conference. Fill out a form for consideration.
What you need to know about the Sydney Tech Scene
From opera to comedy shows, the Sydney Opera House hosts more than 1,600 performances a year, yet its entertainment sector isn't the only one taking center stage. The city's tech sector has earned a reputation as one of the fastest-growing in the region. More specifically, its IT sector stands out as the country's third-largest, growing at twice the rate of overall employment in the past decade as businesses continue to digitize their operations to stay competitive.
