Description
ODI Developer (Oracle Data Integrator/DWH) - Maastricht, Netherlands
Languages: ENGLISH only.
Skills and Experience:
- Candidates should have years of experience with Oracle VLDB.
- Candidates should have years of experience with ODI and ODI automation using ODI SDK.
- Candidates should be able to provide examples of previous successfully manufactured technical and user-facing documentation of Datamodelling and transformation design.
Description of work:
- Source analysis.
- Reverse engineering and maintaining metadata for source systems and 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 and work with clients who actively wish to diversify their talent force - ALL applicants welcome to apply