Beschreibung
For an industry leading company based in Munich we are searching for an experienced ORACLE BI consultant for a full time position.
Our client is about to undertake a major Global IT initiative and need a backend Oracle specialist to join their team.
You would be responsible for the creation and management of the global reporting processes. The position is based at the IT headquarters in Munich city.
Job Description
- Architect, Design, and develop enterprise Data Warehouse components including Database and ETL as well as operational Databases required for BI Applications
- Develop Database & ETL Components while moving from the back-end database/data analysis to working in the front end BI tool space
Design Source to target mapping and ETL test cases
Develop code to load data mart tables
Develop Oracle DB objects including tables, indices, constraints and views
Performance tuning of the load procedures to reduce load time
- Develop Oracle views, SQL & UNIX scripts, ETL, PL/SQL and job scheduling scripts required to manage the loading of data from various transactional systems in to the data warehouse
- Develop the ETL Mappings using OWB
- Analysis and resolution of data discrepancy issues
- Support creation of views and dimensions for user access
- Performs software analysis and peer review and tests software specific to area of business
Qualifications
- Minimum 3 years’ experience in Oracle data warehouse environment with good understanding of data warehouse concepts
- Hands on Oracle Warehouse Builder, Oracle Apex, Java development tools, PLSQL, integration of Unix Scripts with Oracle stored procedures and functions
- Experience in setting up data warehouse, data mining techniques and maintenance of a BI System Experience in OBIEE
- Past experience in manufacturing environment is a plus
If interested in this opportunity please contact me immediately to discuss in further detail.