Loading, Please wait..!!
State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY
-
Posted on: Nov 20, 2026
-
Albany, New York
-
Onsite
-
Contract
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 →Find your match !
Job Title :
State of NY-Oracle Data Warehouse / ETL Developer || Albany, NY
Job Type :
Contract
Job Location :
Albany New York United States
Remote :
No
Job Description :
DURATION: 24 Months
LOCATION: Albany, NY
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
- 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.
Position Details
Posted:
Nov 20, 2026
Reference Number:
1408-44286
Employment:
Contract
City:
Albany
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

