Quick overview
Job description
Job Title: ON-SITE - Oracle Data Warehouse / ETL Developer (ODI) - HBITS-08-15117
Location: Albany, NY
Duration: 24 Months
Job Description:
-
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
________________________________________________________________
Agency: Office of Children & Family Services
Project: OCFS Data Warehouse
Detailed Job Description: 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.
Note: Sorry we do not Sponsor Visa
Max: SEVEN 32.800.2838
Aryan: - SEVEN 32.444.8990
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- ME
Full Stack Java DeveloperRecently posted
Menzo · Tampa, FL · On-site · Posted 20 Nov 2026 🇺🇸
DockerMicroservicesMySQL+26TechnologySalary not listed - CB
Salesforce DeveloperRecently posted
Code Beacons Inc · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
ScrumJavaREST+2TechnologySalary not listed - IT

CXone Lead Developer – NICE CXone (Onshore)Recently posted
Ideate Technologies LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
Stakeholder ManagementRESTSOAP+2Technology$55/hr - AG

Zendesk / OTSM DeveloperRecently posted
ASCII Group LLC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLETLJava+2TechnologySalary not listed - DD

Full Stack EngineerRecently posted
Dexian DISYS · Westlake, TX · Hybrid · Posted 20 Nov 2026 🇺🇸
DynamoDBAWSAngular+5TechnologySalary not listed - AP
Full Stack Java Developer Remote OpportunityRecently posted
Apolis · Salt Lake City, UT · Remote · Posted 20 Nov 2026 🇺🇸
MySQLPHPSQL+14TechnologySalary not listed - DS
Salesforce Developer/ ArchitectRecently posted
Digitek Software, Inc. · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
ScrumJavaREST+2TechnologySalary not listed - AI
React /. Net Full Stack Developer with Security ClearanceRecently posted
Applied Information Sciences · Washington, DC · Hybrid · Posted 20 Nov 2026 🇺🇸
DockerSQLGit+17Technology$100k - $150k/yr - OT
Senior SAP ABAP Techno-Functional Developer (Finance)Recently posted
OnwardPath Technology Solutions LLC · Houston, TX · On-site · Posted 20 Nov 2026 🇺🇸
SQLTechnologySalary not listed - LT

Senior Mainframe full stack DeveloperRecently posted
Lorven Technologies, Inc. · Jersey City, NJ · Hybrid · Posted 20 Nov 2026 🇺🇸
COBOLAgileTechnologySalary not listed - PS

Full Stack Java DeveloperRecently posted
Prismagic Solutions Inc · Salt Lake City, UT · On-site · Posted 20 Nov 2026 🇺🇸
MySQLPHPSQL+15TechnologySalary not listed - ZI
Full stack DeveloperRecently posted
Ziddos · Pleasanton, CA · On-site · Posted 20 Nov 2026 🇺🇸
DockerMongoDBMySQL+11TechnologySalary not listed
