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 development of scalable automation systems by building workflows, integrating AI, and ensuring system reliability in a fast-paced environment.
Top Skills:
APIsAutomation AnywhereGraphQLHubspotJavaScriptJSONLow-CodeNo-Code PlatformsNode.jsPlaywrightPostmanPythonRestfulRpa ToolsSalesforceSQLUipathXML
Marketing Tech • Real Estate • Software • PropTech • SEO
The Sr. Salesforce Administrator will implement Salesforce solutions, handle development and automation work, ensure quality deployments, and collaborate with internal teams.
Top Skills:
ApexDevops CenterFlow BuilderSalesforceSOQLWorkbench
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Join Rubrik's sales talent community to connect and be considered for future opportunities aimed at securing data against cyber threats.
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
