je.st
news
Data Warehouse Development Support
2019-04-08 15:30:11| Space-careers.com Jobs RSS
Data Warehouse Development Support Start date and duration Position starting as soon as feasible on a two years contract. Client and Location For one of our customers we are currently recruiting a Data Warehouse Development Support for their location in Maastricht, the Netherlands. Tasks and Responsibilities 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 selfservice presentation layer including dimensional models, 3NF relational models and flat wide denormalized reporting tablesviews Development of historical data purging rules Technical and userfacing documentation of the data modelling design and transformation design Development, execution and reporting of integration and user acceptance tests, including example Tableau visualisations. Experience and Education 5 years of practical experience with Oracle VLDB 5 years of practical professional experience of the staff offered with ODI 3 years of practical professional experience of the staff offered with ODI automation using ODI SDK Experience in manufactured technical and userfacing documentation of data modelling and transformation design Practical professional experience with Data Vault and, specifically, Data Vault 2.0, or else provide convincing arguments of being able to learn and then apply Data Vault 2.0 methodology within three months Practical professional experience in modelling and handling spatiotemporal data in a selfservice BI context is desirable Prior knowledge in specifically modelling air traffic, sector and airspace configuration, staff rostering and allocation, flow measures, weather, delay, andor occurrences is desirable. About ATG Europe ATG Europe prides itself in employing Europes brightest minds, and for the last 40 years we have been a key player in delivering highly educated engineering professionals and scientist consultants for RD and Engineering environments throughout Europe. Our headquarters is located in the heart of the European space industry on the Noordwijk Space Business Park in the Netherlands, in close proximity of ESAESTEC. We have subsidiaries in Germany, Ireland and the United Kingdom. We are continually recruiting experienced engineers and scientists for exciting, full time positions based at our public and private customers. As an ATG consultant, you will be working on very diverse missions and assignments. This opens up unique opportunities to be engaged in innovative, stateoftheart projects and challenging you to perform to high standards and utilizing the full extent of your professional knowledge. What do we offer? ATG offers excellent working conditions and provide you with all the other necessary means to further your career. We believe that training and education, combined with regular assessments and a personal development plan, will create the best environment for growth. If needed, we also assist you with settling in your new home or finding the right school for your children. ATG will help in any way it can, including a relocation budget that is applicable for ATG staff as well as employees working at one of our clients. Interested? Submit your CV and personal details through our website at www.jointhebrightestminds.com. For further questions, you can also directly contact our recruitment consultant Bilge Ada directly on phone number 31 0 71 579 55 32.
Tags: support
data
development
warehouse
Category:Transportation and Logistics