Job Description :
Oracle Data Warehouse to support OBIEE/In- person Only
Richmond, VA
5 Months
F2F
Complete Description:
*local candidates strongly preferred
*ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions
.Support for development and maintenance of Oracle Data Warehouse to support OBIEE and BIP reporting tools for ABC
The applicant is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in Data Warehouse and BI development and implementations. The applicant will be involved in gathering of business requirements and creating technical designs.
It involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems. The data warehouse developer’s role in an organization includes providing support to the organization’s business requirements in the application and consumption of information from the Data Warehouse.
The applicant will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes. Task will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.
This position involves the delivering of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how.
Data Warehouse Developer Role:
Experienced SQL and PL/SQL developer on Oracle database platform.
Deep understanding of data warehouse and star schema
Develop ETL scripts and write PL/SQL code from data model, dataflow diagram and technical design specifications
Ability to work on wide variety of development needs from simple queries to complex queries and multidimensional analysis
Ability to follow best coding standards practices
Expert in performance tuning of ETL/SQL code
Analyze and provide resolutions for production data issues
Familiar with Unix shell scripting and job automation
Build and implement BI dashboards, analysis using OBIEE
Build reports using BI publisher
Skill
Required / Desired
Amount
of Experience
PL/SQL and SQL developer with Oracle expereince
Required
5
Years
Understanding of Start Schema ata warehouses and data warehouse design
Desired
5
Years
ETL script development and execution, including automation in a Linux / Oracle environment
Desired
5
Years
Performance tuning and reconciliation of SQL quey execution
Desired
5
Years
Familiar with Unix Shell Scripting
Desired
5
Years
Experience with OBIEE, BIP and data Repository in Oracle OBIEE reporting platform
Highly desired
5
Years
Experience developing report specifications from business requirements and executing the build to design
Desired
5
Years
Experience with a mature data modelling tool such as ERWIN (preferred)
Nice to have
5
Years
Experience with Oracle 12 enviornments
Highly desired
3
Years
Global Candidate Requirements
Skill
Required / Desired
Amount
of Experience
Questions
Description
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
Please list candidate''s email address that will be used when submitting E-RTR.