Job Description :
Daily Tasks will include but are not limited to the following:
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.

Qualifications

1. 84 months experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.
2. 60 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
3. 48 months experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.
4. 60 months experience in an Oracle Data Warehouse as a developer performing development work.
5. 84 months experience using PL/SQL.
6. 48 months experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques.
7. Bachelor’s Degree. Proof of Education for all candidates are to be submitted with all responses.