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
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.
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
As a Technology Consultant, you will support customers in adopting Dynatrace technologies, providing analytics and resolving performance issues throughout application lifecycles.
Top Skills:
AjaxApacheAWSAzureBgpCloud FoundryCSSDnsHTMLHTTPIisJavaJavaScriptJbossOpenshiftOpenstackPHPSQLSslTcp/IpWeblogicWebsphere
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
