NYS ITS HBITS Senior IT Specialist (Oracle Data Integrator (ODI) ETL Developer)

Diverse Agile Solutions•Albany, NY

22d•Hybrid

About The Position

Diverse Agile Solutions (DAS) is a certified Minority Business Enterprise (MBE) specializing in IT consulting, staff augmentation, cloud modernization, cybersecurity, DevSecOps, data engineering, artificial intelligence, and enterprise technology solutions. We partner with federal, state, and commercial organizations to deliver highly skilled professionals who drive innovation, operational excellence, and successful digital transformation initiatives. We are seeking an experienced Senior IT Specialist – Oracle Data Integrator (ODI) ETL Developer to support a New York State agency in designing, developing, and maintaining enterprise data integration solutions for mission-critical applications. The Senior IT Specialist will serve as a technical leader responsible for designing, developing, implementing, and supporting enterprise ETL/ELT solutions using Oracle Data Integrator (ODI). The successful candidate will play a critical role in delivering scalable data warehouse solutions while collaborating with development teams, database administrators, and infrastructure engineers to ensure reliable, high-performing data integration platforms. This position requires extensive experience with Oracle technologies, data warehouse architecture, ETL development, SQL optimization, and technical leadership.

Requirements

Ability to work independently while providing technical guidance to development teams.
Experience leading enterprise ETL and data warehouse development efforts.
Strong analytical, problem-solving, and communication skills.
Ability to produce high-quality technical documentation.
Experience working within enterprise software development lifecycle (SDLC) environments.

Nice To Haves

72 months of experience developing ETL/ELT solutions using Oracle Data Integrator (ODI) including: Mappings, Packages, Scenarios, Procedures
72 months of experience creating technical documentation including: Source-to-Target Mapping Documents, ETL Design Documents, Technical Specifications, Use Cases, Software Architecture Documents, Implementation Documentation
72 months of experience writing and optimizing Oracle SQL and PL/SQL including: Tables, Views, Indexes, Stored Procedures, Functions, Triggers, Packages
72 months of experience working with Oracle Data Integrator (ODI) 12c or later
60 months serving as a technical lead responsible for enterprise ETL and data warehouse architecture
24 months of experience supporting Criminal Justice systems at the state or federal level utilizing Criminal Justice terminology and business processes
Oracle Data Integrator (ODI) 12c+
Oracle Database 12c or higher
Oracle SQL
PL/SQL
ETL / ELT Development
Data Warehouse Architecture
Data Modeling
Database Performance Tuning
Oracle Performance Optimization
Enterprise Data Integration
Software Development Life Cycle (SDLC)
Technical Documentation
Database Design
Production Support
Data Analysis

Responsibilities

Design, develop, implement, and maintain enterprise ETL/ELT solutions using Oracle Data Integrator (ODI).
Develop and support enterprise data warehouse integration processes.
Perform ETL application analysis, architecture, design, development, testing, implementation, and production support.
Analyze source systems and design efficient data integration solutions.
Develop data mappings, transformation logic, and data movement processes.
Create and optimize Oracle SQL and PL/SQL code for high-performance data processing.
Develop database objects including tables, views, indexes, procedures, functions, triggers, and packages.
Collaborate with infrastructure teams to resolve technical issues affecting ETL performance and application availability.
Participate in performance testing, failover planning, deployment planning, endurance testing, and production implementations.
Review and oversee ETL development activities to ensure adherence to architectural standards and best practices.
Prepare and maintain technical documentation including: ETL Design Documents, Source-to-Target Mapping Documents, Technical Specifications, Database Schemas, Software Architecture Documents, Implementation Documentation.
Provide technical leadership and mentoring to ETL developers.
Support production troubleshooting, performance tuning, and ongoing platform optimization.