Data Warehouse Developers (Oracle) - Maastricht, Netherlands

DATA WAREHOUSE DEVELOPERS (ORACLE) - MAASTRICHT, NETHERLANDS

Languages: ENGLISH only.

SKILLS AND EXPERIENCE:

- Proposed candidates should have successfully conducted activities in environments working with package BI Tooling, Datamodelling and Reporting within the last five years.
- Proposed candidates should have years of experience with Oracle VLDB.
- Proposed candidates should have years of experience with Oracle Data Integrator and ODI automation using ODI SDK.
- Proposed candidates should be able to provide examples of previous successfully manufactured technical and user-facing documentation of Datamodelling and transformation design.
- Proposed candidates should have years of experience with Data Vault and specifically, Data Vault 2.0, or else they should provide convincing arguments that they are capable of learning and then applying Data Vault 2.0 methodology within three months.

DESCRIPTION OF WORK:

- Source analysis (with support by MUAC).
- Reverse engineering and maintaining metadata for source systems and all layers of DWH enabling automation of loading patterns.
- Modelling of the source data in Data Vault 2.0 standard.
- Automation of Data Vault 2.0 loading patterns using SQL, Groovy, ODI SDK and ODI KM.
- Development of an ODI configuration to automate ingestion of the source data into a staging area.
- Improvements of a framework for automatic generation of ODI transformations of the data from staging area into the Raw Data Vault and further to some areas of Business Vault layer.
- Development of transformations of the data from Raw Data Vault to Business Vault layer, including implementation of Soft Rules.
- Development of transformations of the data to self-service presentation layer (including dimensional models, 3NF relational models and flat wide de-normalized reporting tables/views).
- Development of historical data purging rules.
- Technical and user-facing documentation of the Datamodelling design and transformation design.
- Development, execution and reporting of integration and user acceptance tests, including example Tableau visualisations.

Please send your CV to Janisha/Ashini and call to discuss further.

We are an equal opportunities employment agency and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age.

We champion difference in the world of technology recruitment.