NYS HBITS Senior IT Specialist; Oracle Data Integrator; ODI ETL Developer

BreezyHR-optimized job posting branded for Diverse Agile Solutions (DAS) that aligns with your previous NYS ITS HBITS postings.

Company: Diverse Agile Solutions (DAS)

Location: Albany, NY (Hybrid)

Job Type: Full-Time | Consultant

Diverse Agile Solutions (DAS) is a certified Minority Business Enterprise (MBE) specializing in IT consulting, staff augmentation, cloud modernization, cybersecurity, Dev Sec Ops , 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.

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

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

The ideal candidate will possess:

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