The role involves developing and optimizing ETL workflows for integration between Odoo ERP and a reporting system using SSIS, KingswaySoft, and CData connectors.
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
As a Staff Software Engineer, you will lead design, drive projects, define architecture, mentor engineers, and collaborate on AI-driven products.
Top Skills:
AWSDynamoDBElasticsearchJavaScriptKafkaKubernetesLambdaLangchainLangfuseMastraNode.jsOpenrouterPostgresPythonReactSqsTypescript
Marketing Tech • Real Estate • Software • PropTech • SEO
The Technical Lead Manager will lead engineering efforts, mentor a small team, write high-quality code, and collaborate across functions to deliver innovative products.
Top Skills:
Next.JsNode.jsReact
Marketing Tech • Real Estate • Software • PropTech • SEO
As a Senior Software Engineer II, you'll design and build AI-driven cloud-native applications, enhance architecture, mentor others, and collaborate with teams to deliver high-quality features.
Top Skills:
AWSDynamoDBElasticsearchJavaScriptKafkaKubernetesLambdaLangchainLangfuseMastraNode.jsOpenrouterPostgresReactSqsTypescript
What you need to know about the Dublin Tech Scene
From Bono and Oscar Wilde to today's tech leaders, Dublin has always attracted trailblazers, with more than 70,000 people working in the city's expanding digital sector. Continuing its legacy of drawing pioneers, the city is advancing rapidly. Ireland is now ranked as one of the top tech clusters in the region and the number one destination for digital companies, with the highest hiring intention of any region across all sectors.
