Oracle Data Warehouse/Business Intelligence Developer (05283)

Location: Rensselaer, NY
Date Posted: 02-28-2018
Oracle Data Warehouse/Business Intelligence Developer (05283)
 Rensselaer, NY
 24 Months
Job Description: 
This 24-month position for an Oracle Data Warehouse/Business Intelligence Developer resource is needed for the OCFS Data Warehouse/CONNECTIONS Reporting Module. The DW is sourced from the agency’s major child welfare case management related systems: CONNECTIONS, CCRS, and WMS.
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
1. 84 months experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts. #OF MONTHS  
2. 72 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes. #OF MONTHS  
3. 48 months experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting. #OF MONTHS  
4. 60 months experience in an Oracle Data Warehouse as a developer performing development work. #OF MONTHS  
5. 84 months experience using PL/SQL #OF MONTHS  
6. 48 months experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques. #OF MONTHS  
7. 60 months problem solving on technical issues. #OF MONTHS  
8. Bachelor’s Degree. #OF MONTHS  
this job portal is powered by CATS