Data Warehouse Developer

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. Note: For H-1B and OPT cases, we are seeking candidates from recognised organizations. "No phone calls please."