Stefan Mayer

Concept and realization of a line research and preorder - design and implementation of the service-oriented architecture Optimization of existing services Code review and static code analysis from offshore projects DV-Concepts and further Development J2EE Application BL-T Performance measurement and tuning in the area of Oracle RDBMS and Java

Establishment of a group-wide enterprise Data Warehouse based on Oracle and Informatica Powercenter Implementation of interfaces from the sources into the staging area Design and implementation of ETL routes from staging into the Raw Vault Design and implementation of ETL routes from Raw Vault to Business Vault Consulting in the area of best practices and performance optimization Technologies: Informatica Powercenter 9.6.1, Oracle 12c, HORA, Data Vault 2.0, XML

Analysis of requirements and specifications Technical Documentation Implementation of various incoming and outgoing interfaces Implementation of workflows according to internal standards and best practices Testing the developed mappings and workflows

Concept, design and implementation of the Business Data Vault Layer Raw Data Vault Modeling support Java implementation of 'Domain Specific Language' for Raw and Business Data Vault objects PL/SQL development of ETL routines Technologies: Java (xtext, xtend), Eclipse, Oracle Exadata, Oracle SQL Developer

Modeling the Data Vault 2.0 Environment (Raw Data Vault, Business Data Vault, Information Mart) Coordination with the department about Business Keys and requirements Data Vault training for ETL developers Planning, estimation and implementation of ETL requirements Release implementation of developed ETL processes Documentation of the ETL implementation Technologies: Oracle 12c, Oracle SQL Developer, Jira, Confluence