Data Warehouse Developer

Data Warehouse Developer – (Position B)While not required, OSC will give additional consideration to Proposers whose Consultant candidate has: additional years of experience beyond what is required to meet Minimum Qualification experience performing ETL development using Attunity Compose.The Data Warehouse Developer will work with OSC staff to maintain existing processes and systems, convert existing processes from Oracle Warehouse Builder ("OWB") to Attunity Compose, and develop new processes to integrate new datasets into the data warehouse. Proposers should propose only one candidate for this position. The candidate must meet the Minimum Qualifications described in Section 4.2(a).The Data Warehouse Developer is responsible for performing database development for PARIS, as well as ETL development and OAS development for OSC's FirstNY Data Warehouse. In this capacity the Data Warehouse Developer's duties include:maintaining and developing SQL and PL/SQL for the PARIS Application;maintaining, converting and developing all BI Publisher Reports for the PARIS application;performing database modeling in the context of an online transaction processing ("OLTP") system;performing database modeling in the context of an online analytic processing ("OLAP") system for the FirstNY Data Warehouse;tuning SQL for performance;developing new ETL processes using an enterprise ETL tool;maintaining existing ETL processes using OWB and/or Attunity Compose;converting existing OWB ETL processes to Attunity Compose;maintaining and developing the physical, logical and business layers in the OAS RPD in a MUDE;maintaining and developing dashboards, reports, visualizations and analyses in OAS.