> Markdown version of [/jobs/ext/1248698-lead-odi-integration-developer-local-to-ny-nj](https://www.wearedevelopers.com/jobs/ext/1248698-lead-odi-integration-developer-local-to-ny-nj). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead ODI Integration Developer, - Local to NY- NJ - **Company:** Nexiva Inc - **Location:** Albany, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Business Analytics Applications, Data Analysis, Application Performance Management, Software Documentation, Databases, Extract Transform Load (ETL), Data Mapping, Data Security, Data Structures, Data Warehousing, Logical Databases, Oracle Data Service Integrator, Oracle Databases, Software Architecture, PL-SQL, SQL Databases, Systems Integration, Data Processing - **Published:** July 12, 2026 - **Apply:** https://www.careerjet.com/jobad/us6ea1957337d4cec5e1b34ef15b2d402f ## About the Role 72 months experience developing ETL/E-LT objects including Mapping, Packages, Scenarios and Procedures using Oracle Data Integrator. 2. 72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents. 3. 72 months experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages in Oracle database 12c or higher. 4. 72 months experience working with Oracle Data Integrator 12c or later. 5. 60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture. ## Description The candidate will be responsible for designing, developing, implementing, and supporting enterprise data integration solutions using Oracle Data Integrator (ODI) to meet business and operational needs. List of Day-to-Day Tasks to be performed by selected candidate This individual will be expected to participate in the following activities: * Manages ETL solutions for data warehouse projects. * Perform ETL application analysis, design, development and implementation, including: data analysis, data access, data structures, data manipulation, data reporting solutions, database, and technical and user documentation. * Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance. * Work with the Infrastructure team to execute activities such as performance test planning and execution failure failover planning and execution, endurance testing and deployment planning and testing. * Perform oversight of development activities which may include data analysis, data access, data structures, data manipulation, preparing logical database models, testing and implementation. * Prepare, and/or review technical documentation such as designs, schemas, etc., as appropriate. * Provide technical guidance to team of developers. Requested Qualification Number Requested Qualification * There is no requirement to have 10 Qualifications. * Only Number of Months is an allowable unit of measurement for experience., 24 months experience developing, implementing, and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures. Required Documentation R sum Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Best Regards, Aditya Shrivastava Lead Technical Recruiter, Nexiva Inc, Job Summary The candidate will be responsible for designing, developing, implementing, and supporting enterprise data integration solutions using Oracle Data Integrator (ODI) to … + 12 hours ago + Apply easily ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Why Your AI Agent Keeps Hallucinating Your Data: Building Deterministic Context Layers](https://www.wearedevelopers.com/videos/2055-why-your-ai-agent-keeps-hallucinating-your-data-building-deterministic-context-layers) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Science & more: The Lopez dilemma](https://www.wearedevelopers.com/magazine/10-data-science-more-the-lopez-dilemma) - [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)