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

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

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

Company: Diverse Agile Solutions (DAS)

Location: Albany, NY (Hybrid)

Job Type: Full-Time | Consultant

About Diverse Agile Solutions

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.

Position Overview

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.

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

Required Qualifications

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

Preferred Qualifications

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 Criminal Justice systems at the state or federal level utilizing Criminal Justice terminology and business processes

Technical Skills

Preferred experience includes:

• 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

Why Join Diverse Agile Solutions?

At DAS, you'll have the opportunity to work on high-impact public sector initiatives that improve government services while collaborating with talented professionals on cutting-edge technology projects.

We offer:

• Competitive compensation
• Opportunities to work on enterprise-level government projects
• Professional growth and career advancement
• Collaborative and supportive team environment
• Exposure to modern data integration and cloud technologies
• Commitment to diversity, inclusion, and innovation

Equal Opportunity Employer

Diverse Agile Solutions is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other protected characteristic.

Apply Today

If you're an experienced Oracle Data Integrator professional with a passion for enterprise data integration, data warehousing, and technical leadership, we'd love to hear from you.

Join Diverse Agile Solutions and help build the next generation of enterprise data solutions for New York State.