Job Details

ID #45953907
State New York
City Rensselaer
Job type Contract
Salary USD Up to $67 67
Source GreyCell Labs, Inc
Showed 2022-09-24
Date 2022-09-23
Deadline 2022-11-21
Category Et cetera
Create resume

ON SITE - Data Modeler Expert with OLTP/ETL - HBIT-04-12329

New York, Rensselaer, 12144 Rensselaer USA

Vacancy expired!

Job Title: ON SITE - Data Modeler Expert with OLTP/ETL - HBIT-04-12329

Location: Rensselear , NY, 12144

Duration: Long-term

Job Description:
  • 60 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.
  • 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols.
  • 84 months experience in build 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 24-month position for a Systems Developer with experience working on an Oracle Data Warehouse/Business Intelligence team is needed to work on the OCFS Operational Data Store component of the Data Warehouse for both for child welfare and juvenile justice.

Note: THIS WILL BE AN ON-SITE POSITION.

Max: Seven 32-800-2838

Kevin:- Seven 32-800-2373

Vacancy expired!

Subscribe Report job