Description
The Juvenile Justice component of the OCFS data warehouse includes data from the Division of Juvenile Justice and Opportunities for Youth (DJJOY) systems: JJIS, JJISCTH, DRAIS, ARTS and JDAS. The efforts over the next period will include but are not limited to updating, maintaining and creating new data marts in support of Juvenile Justice Information System (JJIS) Reporting, Juvenile Justice state and federal reporting, and the DJJOY dashboard.
Duties
- Perform Oracle Data Integrator (ODI) administration related tasks
- Perform Fusion Middleware upgrades
- Migrate OWB projects to ODI 12c
- Perform complex PL/SQL coding in a Data Warehouse environment with an Oracle Database
- Perform unit testing and correct all identified bugs.
- 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.
- The individual in this position will work under the direction of a Project Manager.
Mandatory Requirements
- Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
- Experience (8+ Years)
Requirements
- 84 months experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.
- 84 months experience in SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support
- 60 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI) including migrating OWB projects to ODI 12c.
- 60 months Data modeling (Dimensional & Relational),
- process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
- 60 months experience in an Oracle Data Warehouse as a developer performing development work using PL/SQL
- 60 months experience in converting business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
- Bachelor’s Degree.