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 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.
Recommended Jobs
Patient Access Specialist
Essential Functions Must be proficient in time management and identifying priorities. Analyze and disseminate physician orders to appropriately match services to the planned admission. Respo…
Civil Engineer Project Manager
Here’s a fresh and engaging rewrite of the job description for Luxus Build, making it unique and compelling while emphasizing the hybrid remote nature of the role. Civil Site Development Project M…
Sales Associate - Optical
America's Best is part of National Vision, one of the largest optical retailers in the United States. The America's Best brand continues to grow, with 1000+ stores and counting. Each location combines…
Communications Specialist- School of Medicine, Human Genetics
Discover Your Career at Emory University Emory University is a leading research university that fosters excellence and attracts world-class talent to innovate today and prepare leaders for the fut…
Machine Operators Needed in Kennesaw, 2nd Shift, EARN UPTO $865/WEEKLY! Excellent Company, Great Ben
I.K. Hofmann USA has a need for Machine Operators in Kennesaw, Ga Job Responsibilities: • Machine parts to specs using machine tools such as lathes, shapers or grinders • knowledge of measurin…
Social Worker
EMIT Learning is seeking a compassionate and skilled Social Worker to join our dedicated team. As a Social Worker you will play a crucial role in supporting the emotional social and academic well-be…
Production Team Member
Non-Exempt Oldcastle Infrastructure™ , a CRH company, is the leading provider of utility infrastructure solutions for the water, energy, and communications markets throughout North America. …
Join Our Day Shift LPN Team in Corrections!
Correctional LPN Join our dedicated team as a Day Shift Correctional LPN at BOS Medical Staffing in Douglasville, GA. This role demands an LPN with a minimum of 1 year of correctional nursing experie…
Senior Director, Translational Medicine (MD)
The Senior Director Translational Medicine will be responsible for design, execution and reporting of First in Human (FIH), Translational Medicine (TM) and Proof of Concept (POC) studies and will work…
General Dentist - Bonaire, GA
Job Description Job Description General Dentist Opportunity in Bonaire,GA Dental Care of Bonaire is looking for a General Dentist to join the team! Offering a $200,000 Compensation Package …