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 Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
