Data Warehouse Developer

Elegant Enterprise- Wide Solutions Inc

Job Location:

Albany, GA - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

About this Position:

Job Title: Data Warehouse Developer

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 Clients 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.

Minimum Qualifications:

Availability to begin work on the Anticipated Commencement of Work Date stated and for a minimum of six months.
At least one years experience developing complex reports in Oracle BI Publisher using Microsoft Word to design the layout.
At least three years experience using OBIEE in a multi-user development environment (MUDE) developing within the Repository Database (RPD) and creating dashboards and analyses.
At least three years experience performing ETL development using an ETL development tool such as Oracle Warehouse Builder Attunity Compose Informatica PowerCenter Pentaho Data Integration Oracle Data Integration or Talend Data Integration.
At least five years experience performing Oracle database development using SQL and PL/SQL.
At least two years experience tuning SQL for performance within an Oracle environment.
At least three years experience modeling data for reporting and analytics.

About this Position: Job Title: Data Warehouse Developer 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 tran...