Data Warehouse Developer

Overview

On Site
Full Time
Accepts corp to corp applications
Contract - 5 Year(s)
100% Travel

Skills

SQL
PL/SQL
ETL
OBIEE

Job Details

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 Client's 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 year's 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.