The team is working (Agile) to build out a new Enterprise Data Warehouse: IVL (information supply layer). This is built according to modern architectural principles and works with Data Vault Modeling (for connecting sources) and with dimensional modeling (for off-takes). The focus is on ETL (with Vaultspeed as an automation tool) & Data Vault modeling, with occasional dimensional modeling.
Ideal Profile
Coming up with solutions obv analyses.
Building a logical and physical data model to support the solution.
Perform impact analyses and prepare technical analyses for coding.
Formulate improvement proposals, e.g. around the use of the ETL tool.
Maintain all documentation and processes and track relevant evolutions within own domain to contribute to the development and professionalization of the team.
At least 5 years of experience in similar assignments
Excellent knowledge of Data Vault modeling and 3NF modeling, and good knowledge of dimensional modeling.
Good knowledge of SQL
High seniority in DWH environments.
Good knowledge ODI
Strengths
Extensive experience with an ETL automation tool is a plus.
Experience with or knowledge of Tortoise SVN and/or GIT.
Knowledge of Oracle Exadata, Oracle Golden Gate, Oracle Enterprise Metadata Management or OBI