Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645

The Division of Juvenile Justice and Opportunities for Youth (DJJOY) Juvenile Justice Information System (JJIS) is a web-based application using .Net technology. It tracks juvenile justice youth through detention facilities into OCFS placement where they go through Intake, Residential, and CMSO (community multi-service organizations) programs and services, and also provides an automated financial/billing module.
JJIS moved into Phase 4 development in April 2010. The first three phases included a full system re-write (deployed in July 2007) based on the legacy system developed in the 1970’s, plus many functional enhancements. Phase 4 is defined by the priority system enhancements required to support program improvements in DJJOY facilities as required by the federal Department of Justice (DOJ) settlement agreement, as well as many additional functionality enhancements to support case management and other operational processes throughout OCFS’ juvenile justice system.
Examples of priority work to be completed in JJIS Phase 4 include, but are not limited to: a comprehensive youth interventions/counseling module to include individual and group interventions, single working diagnosis, and psychotropic medications tracking support; Imaging; Unusual Incident Report (UIR) system re-write and integration; Treatment Team form automation; transitional planning support; additional restraint reporting from the Automated Restraint Tracking System (ARTS, which is integrated with JJIS); HIPAA compliance; and more.
This request is for an Oracle Data Warehouse Developer with report development experience. The person in this position will work on DJJOY data modeling/design, ETL, and validation within the OCFS enterprise data warehouse architecture. In addition, this person will assist with Cognos report development, including creating packages, cubes and reports, and applying security. This position is needed in order to meet the vast data/report requirements for DJJOY and related to the DOJ system enhancements.

Duties include but are not limited to:

1. Work in coordination with a team of developers to expand the current Data Warehouse.
2. Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
3. Perform unit testing and correct all identified bugs.
4. Perform complex PL/SQL coding in a Data Warehouse environment.
5. Assist with responding to Juvenile Justice data requests.
6. The individual in this position will work under the direction of a Technical Lead & Project Manager.
7. Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL