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

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

Location : Rensselaer, NY

Duration: 24 Months

2-3 references required.

Job Description:

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

• Work in coordination with a team of developers to expand the current Data Warehouse.
• 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.
• Assist with responding to Juvenile Justice data requests.
• The individual in this position will work under the direction of a Technical Lead & Project Manager.
• Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL

Candidates should have at least 60 months experience, and following should apply:

Experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.

Experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.

Experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.

Experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.

Experience using PL/SQL

Experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques.

Problem solving skills and ability to think and resolve technical issues under pressure

Bachelor’s Degree. Proof of Education for all candidates are to be submitted with all responses..

Please note that our client does allow Skype/remote interviews.  However they reserve the right to require an in-person interview.

Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects

3 references are must with the resume.

Contact mvkramarao@mitresource.com or Ph # 203-567-0129 for further information.