Skip to main content
Loading
loadingbar
Loading, Please wait..!!

State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY

  • State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY job type Posted on: Nov 20, 2026
  • State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY experience level GDR Defense
  • State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY employment type Albany, New York
  • State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY employment type Onsite
  • State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY salary Contract

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY roles in New York.

View Salary Guide →

Job Title :

State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY

Job Type :

Contract

Job Location :

Albany New York United States

Remote :

No

Jobcon Logo Job Description :

Expert Systems Developer HBITS-08-15117
DURATION: 24 Months
LOCATION: Albany, NY
This position is for a systems developer with experience working on a Oracle Data Warehouse/Business Intelligence team. The developer will design/model, construct, load and validate the tables through the enterprise Data Warehouse architecture.
Qualifications
  • Systems Developer - Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
  • Expert- 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
  • 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
  • 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment
  • 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL
  • 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
  • 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
  • 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
  • 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols
  • 84 months experience in building database schemas, tables, views, indexes, and stored procedures
  • Bachelor's Degree
Day-to-Day tasks
  • Work in coordination with a team of developers to expand the current Data Warehouse.
  • Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
  • Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  • Perform unit testing and correct all identified bugs.
  • Perform complex PL/SQL coding in a Data Warehouse environment.
  • Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements
  • Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI
  • The individual in this position will work under the direction of a Technical Lead & Project Manager.

Jobcon Logo Position Details

Posted:

Nov 20, 2026

Reference Number:

1408-44286

Employment:

Contract

City:

Albany

Job Origin:

CIEPAL_ORGANIC_FEED

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Expert Systems Developer HBITS-08-15117
DURATION: 24 Months
LOCATION: Albany, NY
This position is for a systems developer with experience working on a Oracle Data Warehouse/Business Intelligence team. The developer will design/model, construct, load and validate the tables through the enterprise Data Warehouse architecture.
Qualifications
  • Systems Developer - Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
  • Expert- 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
  • 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
  • 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment
  • 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL
  • 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
  • 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
  • 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
  • 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols
  • 84 months experience in building database schemas, tables, views, indexes, and stored procedures
  • Bachelor's Degree
Day-to-Day tasks
  • Work in coordination with a team of developers to expand the current Data Warehouse.
  • Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
  • Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  • Perform unit testing and correct all identified bugs.
  • Perform complex PL/SQL coding in a Data Warehouse environment.
  • Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements
  • Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI
  • The individual in this position will work under the direction of a Technical Lead & Project Manager.

Loading
Please wait..!!