Oracle Data Integrator
The requirement of ODI is three. It's a short term project and we require experienced resources.
1. Two for nine weeks
2. One until end of the project, estimated by Nov 11, 2014.
The consultant must be able to do/have the following
· Involve in Staging area and EDW design discussions with Solution Architect
· Create database from Logical Data Model
· Map, transform (if required) and load data from multiple sources (Oracle DB, Flat file and Excel file) to Staging area (Oracle DB)
· Mapping, transforming, loading from Staging area to EDW (Oracle DB to Oracle DB)
· Create technical design document
· Edit the ODI generated scripts if necessary
· Schedule the jobs
· Implement business rules
Must have the following
· Involvement in two full data warehouse implementations
· Strong database design and relational and dimensional data modelling skills
· Working experience with SQL Developer Data Modeller
· Experience in creating technical design document
· Experience in creating ETL and/or ELT job schedules
· Experience in ODI administration, maintenance and configuration
· Experience in Mapping, transforming, loading from Oracle database, flat files, and Excel documents to Oracle Database.
· Good knowledge of OLAP, OLTP, Data warehouse, Fact and Dimensional DB designs.
· Experience in writing complex queries, Stored Procedures preferably in PL/SQL.
· Experience in performance tuning of sources, mappings, targets and sessions.
· Experience in converting logical data model into database.
· Experience in editing the scripts generated by the SQL developer data modeller.
OBIEE Developers also three. (Experienced).
1. One developer start from 15 August 2014 until end of the project (11 Nov 2014)
2. Two developers start from 25 August 2014 until end of the project (11 Nov 2014)
OBIEE developer must be able to do the following and must have two implementations experience
· Able to assist Solution Architect in EDW design finalisation (Senior who joins first)
· Able to recommend EDW design changes to accommodate identified gaps while report development (Senior who joins first)
· Able to help the other two OBIEE developers (Senior who joins first)
· Develop OBIEE ad-hoc, analysis reports and dashboards
· Write advance SQL, use Oracle's SQL aggregate and analytic functions
· Have an understanding of repository objects designed from ROLAP data models, hierarchies, levels
· Able to recommend ad hoc and analysis design for a simple report
· Working Experience on data warehouse with ODS
No comments:
Post a Comment