Development and support ETL scripts (PL/SQL).
Development and support ETLs using OWB (Oracle Warehouse Builder).
Develop and maintain OBIEE staging environment and star schema (Oracle 11g).
Responsible for documentation, requirements' definition, analysis, scope and time estimation for all assigned projects and tasks.
Assist in OBIEE meta-layer development and maintenance.
Troubleshoot ETL problems and perform DB tuning.
DW installation, maintenance and upgrades.
Fine-tune the performance of the data warehouse and transactional database.
Set standards for operations, programming and security at database level.
Perform data modeling tasks for all BI and none-BI projects and knowledge how to build for performance.
Expert in DB design and architecture.
Strong technical knowledge of Oracle Database, tools and techniques.
Knowledge of custom ETL programming.
Exposure to Master Database concept and design is a plus.
Required 7 + years of experience with Oracle, PL/SQL and stored procedures.
3 + years of experience with Oracle Business Intelligence Enterprise Edition.
6 + Years Oracle 10g and 11g data base.
5+ years of relational database experience (Oracle and SQL Server preferred) with ETL, OLAP, data warehousing and business intelligence technologies including business objects.
Key Skills: