Lead ODI Integration Developer, - Local to NY- NJ

Nexiva • Albany, NY

1d • Hybrid

About The Position

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. This individual will be expected to participate in managing ETL solutions for data warehouse projects. They will 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. The role involves acting as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance. Collaboration with the Infrastructure team for activities such as performance test planning and execution, failure failover planning and execution, endurance testing, and deployment planning and testing is also expected. The position requires oversight of development activities, including data analysis, data access, data structures, data manipulation, preparing logical database models, testing, and implementation. Preparation and/or review of technical documentation such as designs and schemas is necessary. The Lead ODI Integration Developer will also provide technical guidance to a team of developers.

Requirements

• 8+ years experienced candidate required local to NJ NY.
• 72 months experience developing ETL/E-LT objects including Mapping, Packages, Scenarios and Procedures using Oracle Data Integrator.
• 72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents.
• 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.
• 72 months experience working with Oracle Data Integrator 12c or later.
• 60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture.
• 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.
• NY/ NJ DL mandatory candidates

Nice To Haves

• Webcam interview.
• 3 professional references mandatory

Responsibilities

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed