Peter Brungs - Data Warehouse Consultant...

Q: Where is Peter based?

Peter is based in Cologne, Germany and can operate in on-site , hybrid , and remote work models.

Q: What languages does Peter speak?

Peter speaks the following languages: German (Native), English (Advanced), French (Elementary) .

Q: How many years of experience does Peter have?

Peter has at least 22 years of experience. During this time, Peter has worked in at least 12 different roles and for 15 different companies . The average length of individual experience is 1 year and 4 months . Note that Peter may not have shared all experience and actually has more experience.

Q: What is Peter's latest experience?

Peter's most recent position is Data Warehouse Consultant (Development and Analysis) at Atruvia AG .

Q: What companies has Peter worked for in recent years?

In recent years, Peter has worked for Atruvia AG , Mobiliar Insurance , PostFinance , and Deutsche Bundesbank .

Q: Which industries is Peter most experienced in?

Peter is most experienced in industries like Insurance , Banking and Finance , and Transportation . Peter also has some experience in Information Technology , Agriculture , and Biotechnology .

Q: Which business areas is Peter most experienced in?

Peter is most experienced in business areas like Business Intelligence , Information Technology , and Quality Assurance . Peter also has some experience in Operations .

Q: Which industries has Peter worked in recently?

Peter has recently worked in industries like Banking and Finance , Insurance , and Information Technology .

Q: Which business areas has Peter worked in recently?

Peter has recently worked in business areas like Business Intelligence , Information Technology , and Quality Assurance .

Recommended expert

Cologne, Germany

Experience

Jan 2025 - Dec 2025

1 year

Karlsruhe, Germany

Remote

Data Warehouse Consultant (Development and Analysis)

Atruvia AG

Developed and enhanced ETL loading jobs with IBM DataStage and optimized SQL in an IBM DB2 environment as part of the Agree21 data migration
Analyzed data quality and developed test procedures
Created PowerShell scripts and documented GIT deployment processes
Technologies: RedHat Linux, IBM DB2 with DBVisualizer, IBM InfoSphere DataStage 11.7, JIRA, TortoiseGIT, TortoiseSVN, PowerShell scripts

Jan 2022 - Dec 2025

4 years

Bern, Switzerland

Data Warehouse Consultant (Development and Analysis)

Mobiliar Insurance

Developed and modeled a new data warehouse core in coordination with the business unit
Performed ad hoc analyses and risk assessments based on the DWH core for business users
Assisted in building a business layer based on the DWH core
Defined and reviewed data mappings
Developed and enhanced ETL loading jobs with IBM DataStage and PL/SQL in Oracle, IBM DB2 (with IDAA), and MS SQL environments
Analyzed data quality and developed test procedures
Prototyped QuerySurge routines and integrated them into IBM DataStage
Introduced new data compression functionality into the data warehouse
Integrated data from IBM CDC and the Kafka/Avro Schema Registry and Kafka Connect framework using IBM DataStage and the Java integration stage
Involved in the areas: contract, partner, object, product, location, claims
Updated SAP BO reports, universes, and lists of values
Tested and updated InfoBurst configurations
Reverse engineered historical ETL processes and fixed errors
Monitored daily data processing and resolved loading issues in PL/SQL, Unix scripts, and ETL jobs
Technologies: RedHat Linux, MS SQL, IBM DB2 and Oracle 19c (JSON SQL), AQT/TOAD/SQL Developer, IBM InfoSphere DataStage 11.7, IBM CDC 11.4, Kafka/Avro framework, Schema Registry, QuerySurge, Enterprise Architect, JIRA, TortoiseGIT, SAP BO, InfoBurst

Jan 2021 - Dec 2021

1 year

Bern, Switzerland

Data Warehouse Consultant (Development and Analysis)

PostFinance

Analyzed data quality and tested consistency
Created and optimized runtime of ad hoc SQL queries with index tuning
Prototyped partition and tablespace distribution for large tables
Developed ETL loading jobs in Python (Pandas) in an IntelliJ environment
Optimized query performance in Oracle DB using indexes, pragmas, and partitioning
Technologies: Oracle 19c, TOAD, SQL Developer, IntelliJ with Python (Pandas), JIRA, TortoiseGIT

Jan 2020 - Dec 2023

4 years

Frankfurt, Germany

Data Warehouse Consultant (Development and Analysis)

Deutsche Bundesbank

Modeled core data warehouse (Data Vault 2.0) for international banking data
Developed ETL loading jobs with IBM DataStage and Unix Bash scripting
Prototyped DataStage with Unix control and generic ETL loading
Created and loaded error log tables and views
Created mapping specifications
Wrote XML-SQL queries, views, and extractions
Analyzed data quality and tested consistency
Integrated Target2 master data (CRDM) and transaction data (RTGS/CLM)
Technologies: IBM DB2, DBVisualizer, IBM InfoSphere DataStage 11.7, SAP PowerDesigner, JIRA, TortoiseSVN

Jan 2016 - Dec 2020

5 years

Bern, Switzerland

Data Warehouse Consultant (Development and Analysis)

Mobiliar Insurance

Developed and modeled a new data warehouse core in coordination with the business unit
Performed ad hoc analyses and risk assessments based on the DWH core for business users
Assisted in building a business layer based on the DWH core
Defined and reviewed data mappings
Developed and enhanced ETL loading jobs with IBM DataStage and PL/SQL in Oracle, IBM DB2 (with IDAA), and MS SQL environments
Analyzed data quality and developed test procedures
Prototyped QuerySurge routines and integrated them into IBM DataStage
Introduced new data compression functionality into the data warehouse
Integrated data from IBM CDC and the Kafka/Avro Schema Registry and Kafka Connect framework using IBM DataStage and the Java integration stage
Involved in the areas: contract, partner, object, product, location, claims
Updated SAP BO reports, universes, and lists of values
Tested and updated InfoBurst configurations
Reverse engineered historical ETL processes and fixed errors
Monitored daily data processing and resolved loading issues in PL/SQL, Unix scripts, and ETL jobs
Technologies: RedHat Linux, MS SQL, IBM DB2 and Oracle 19c (JSON SQL), AQT/TOAD/SQL Developer, IBM InfoSphere DataStage 11.7, IBM CDC 11.4, Kafka/Avro framework, Schema Registry, QuerySurge, Enterprise Architect, JIRA, TortoiseGIT, SAP BO, InfoBurst

Jan 2014 - Dec 2016

3 years

Auckland, New Zealand

Manager and Solutions Architect

Ernst & Young

Introduction of a new insurance data model based on IBM IAA (partner, contract, commission, claim, product business system) with a matching data warehouse architecture
Connecting open data sources with MS-SSIS ETL tool (WebServices/REST) for banks
Migrating MS Project data into a Tableau application
Writing a white paper on big data architectures based on Hadoop and related distributions
Technologies: IBM IAA, MS SQL Server (SSIS/SSRS), SAP PowerDesigner, Big Data (Hadoop), Tableau

Jan 2014 - Dec 2014

1 year

Wiesbaden, Germany

Team Lead and Data Migration Expert

SOKA-Bau Versorgungskasse

Led the team and acted as the contact person for resolving technical and functional issues
Performed data quality analysis of contract and debt collection data in a staging database and in the SAP GUI
Migrated data from external source systems into a new SAP FS-CD system
Conducted as-is analysis, created data mappings, and performed data analysis in cooperation with the business department
Technologies: IBM DB2, UNIX, SAP GUI, SQL analytic queries, and VBS scripts

Jan 2012 - Dec 2013

2 years

Heidelberg, Germany

Data Warehouse Consultant

Janitos

Technical lead in developing a neutral insurance data model in ETL with DataStage, populating data marts (star schema) and implementing a hub-and-spoke architecture
Created ad-hoc queries for the management information system in PL/SQL using explain and parallelization
Designed and implemented data extractions following business requirements for commission-claim analysis
Optimized data extraction SQL for large data volumes
Version control with SVN
Technologies: Oracle 11g (PL/SQL), Oracle Data Modeler, SVN, SAP BO, DataStage 8.7, Talend

Jan 2012 - Dec 2012

1 year

Walldorf, Germany

IBM Websphere DataStage Specialist

SAP

Supported bug fixes and added features to ETL jobs of a CRM system
Performed functional testing of SOAP components and supported software enhancements
Designed and built ETL jobs for data extraction
Created development and test documentation for DataStage
Optimized data extraction SQL for large data volumes in the CRM system
Integrated DataStage web services into SAP NetWeaver
Technologies: Windows Server 2003/2008, SAPGUI, DataStage 7.52, DB2, SoapUI, SAP NetWeaver

Jan 2008 - Dec 2012

5 years

Cologne, Germany

ETL Expert in Data Integration

Talanx-HDI-Gerling Versicherung

Developed technical specifications and concepts for migrating data from external sources into a decision support database system with master data management (MDM)
Modeled data and designed databases, including SQL optimization and guidelines for the database administrator
Handled version control with Jenkins and an in-house tool
Designed and implemented SQL scripts and ETL jobs for data analysis and extraction
Migrated data from external systems and integrated it into the data model using SQL-Loader scripts on UNIX
Extended ETL mappings and documented them according to business requirements
Conducted unit tests (TAT/UAT) and prepared test documentation
Designed and built a web-based monitoring tool for error analysis using Java (JSP) and web server integration
Created and extended control scripts (ksh) for ETL and data extraction in job scheduling
Maintained and enhanced a frontend tool for displaying master data in web format
Technologies: AIX, DB2, Oracle 10, DataStage 7.52, SQL/XML, Tomcat, Java, Shell, Eclipse, Jenkins

Jan 2008 - Dec 2008

1 year

Frankfurt, Germany

Informatica ETL DWH Consultant

EuroHypo

Implementation, documentation and unit tests of ETL mappings
Configuration and execution of unit tests
Extension of existing ETL mappings according to business requirements
Impact analysis and documentation of ETL mapping extensions for SAP systems
Programming PL/SQL stored procedures
GUI programming of diagnostic tools for database interfaces with C#
Technologies: AIX 6.1, Oracle 10, Informatica 7.1.3, TOAD 9.5, PL/SQL, Stored Procedures

Jan 2007 - Dec 2007

1 year

Leverkusen, Germany

Review and Optimization of ETL Processes in Master Data Management

Bayer CropScience

Review of the Data Warehouse architecture and implementation of the master data project
Design of blueprint documentation for the master data project (SDLC planning, configuration management)
Analysis of the existing data model in the source system (SAP) and target system (Oracle)
Planning of a reporting data model and mapping solutions
Data modeling of the master data system including data profiling and design of a new data model
Planning of data extraction and data transfer between source and target systems
Translation of business requirements into technical specifications for ETL
Technologies: IBM AIX, SAP, Oracle 10, DataStage 7.52, TOAD 9.5, PL/SQL, Stored Procedures

Jan 2007 - Dec 2007

1 year

Stockholm, Sweden

Data Warehouse Consultant, ETL Process Review

Nordea Bank

Code review of DataStage ETL implementations and PowerCenter Informatica based on business transformation rules
Ensuring and improving data quality by comparing data, data structures and data model
Evaluating mapping rules against programmed stored procedures
Introduction of a new documentation standard for stored procedures
Designing process improvements in the data warehouse and presenting them to management
Technologies: IBM AIX, MS SQL Server, DataStage 7.52, SQL, Stored Procedures

Jan 2006 - Dec 2006

1 year

Vienna, Austria

ETL Expert in Basel II Implementation

Raiffeisen Zentral Bank

Data and relationship validation of entities and supporting the business side to improve data quality
Creating SQL programs for data analysis in Oracle DB
Designing and programming ETL routines for Ascential DataStage and improving existing solutions
Testing and integration in the IBM AIX environment and Oracle database for the Fermat analysis tool
Documentation and creation of ETL mappings based on business requirements
Managing DataStage jobs with custom-developed UNIX scripts
Technologies: IBM AIX, Oracle 10, DataStage 7.52, KSH scripts, SQL, Stored Procedures, SVN

Jan 2006 - Dec 2006

1 year

Munich, Germany

Data Warehouse ETL Expert

Versicherungskammer Bayern

Validation of the data model with SQL scripts and supporting the modelers on fact and dimension tables
Programming ETL routines with DataStage EE (parallel jobs)
Testing and integration in the IBM AIX environment and IBM DB2 databases with Ascential Profile Stage
ETL concept and implementation of interfaces within the ETL and data warehouse project
Technologies: Windows, Unix, Oracle, Ascential DataStage 7.52 EE

Jan 2004 - Dec 2005

2 years

Brussels, Belgium

IS Solutions Analyst

DHL GCC Europe

Programming ETL routines for the Ascential DataStage data warehouse with performance analysis, tuning, testing, and integration in an HP Unix environment and IBM DB2 databases
Defining data extraction and setting data transfer standards in Unix scripts and SQL
Ensuring data and process quality by defining standards for Ascential DataStage implementation
Defining country-specific database interface standards for Oracle, IBM, and MS SQL
Specifying frontend and backend standards for a web user interface to manage the versioned data warehouse process using PHP on HP-UX
Technologies: HP Unix, Oracle, DB2, DataStage/ProfileStage 7.5, Erwin, PHP, Unix scripts

Cologne, Germany

Consultant

Training in object-oriented programming technologies, database applications, and computer architectures
Developing dynamic spatial web applications using XML/XSLT and VRML
Designing dynamic web pages using JSP to display database content
Developing dialog-based Java applications for data collection
Analyzing and developing assembler modules and 3D visualization technologies
Developing insurance software on client-server and mainframe systems with DB2
Migrating data from IBM mainframe DB2 to Windows and OS/2 environments
Quality management and testing of C/C++ software solutions for insurance data
Implementing faster database access solutions with SQL and C++ under DB2
Designing Java/JDBC and JSP internet applications

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Insurance, Banking and Finance, Information Technology, Transportation, Agriculture, and Biotechnology.

Insurance

Banking and Finance

Information Technology

Transportation

Agriculture

Biotechnology

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Information Technology, Quality Assurance, and Operations.

Business Intelligence

Information Technology

Quality Assurance

Operations

Skills

Data Warehouse
Business Intelligence
Big Data
Programming
Industries: Insurance
Industries: Banking
Industries: Logistics
Industries: Chemicals
Industries: Government
Industries: Software Vendors
It: Data Warehouse Design And Architecture
It: Data Migration And Integration
It: Big Data Applications
It: Metadata Management
It: Programming
It: Data And Process Quality Assurance
Domain: Health/life/auto/property Insurance
Domain: Master Data And Crm
Domain: Basel Ii / Target 2
Methods: Project Management
Methods: Requirements Management
Methods: Data Modeling
Methods: Software Engineering And Sdlc
Methods: System Analysis And System Integration
Methods: Quality Management
Methods: Release And Change Management
Methods: Training And User Coaching
Etl Tools: Ibm Datastage
Etl Tools: Informatica Powercenter
Etl Tools: Pentaho / Talend Data Integration
Etl Tools: Microsoft Ssis
Big Data: Kafka Framework With Connect, Avro Serialization, Schema Registry (Json)
Reporting Tools: Tableau
Reporting Tools: Sap Business Objects (+Ds)
Reporting Tools: Cognos
Data Modeling: Oracle Sql Developer Data Modeler
Data Modeling: Sap / Sybase Powerdesigner
Data Modeling: Ca Erwin Data Modeler
Programming Languages: C/c++/c# (Stl, Mfc, Generic Programming/templates)
Programming Languages: Java (Jsp, Servlets, Applets, J2ee (Struts/hibernate), Swing/awt)
Programming Languages: Python
Programming Languages: Php
Development Tools: Eclipse Environment With Corresponding Plugins
Development Tools: Ms Visual Studio
Development Tools: Make / Ant / Maven
Scripting Languages: Javascript / Vbscript
Scripting Languages: Shell (Ksh, Bash, Csh, Powershell)
Markup Languages: Xml/xslt
Markup Languages: Html
Markup Languages: Vrml
Virtualization: Vmware
Virtualization: Virtualpc
Operating Systems: Windows
Operating Systems: Linux/unix
Operating Systems: Os/2
Operating Systems: Mvs/os390
Databases: Ibm Db2 (Sql/xml+xpath/xquery), Ibm Cdc 11.4
Databases: Oracle (Sql, Pl/sql)
Databases: Mysql
Databases: Sybase
Databases: Ms Sql Server
Databases: Teradata
Databases: Firebird
Database Tools: Aqt
Database Tools: Toad 9.5
Database Tools: Dbvisualizer
Database Tools: Squirrel
Database Tools: Sql Developer
Database Tools: Sql Scripts
Database Tools: Rapidsql
Database Tools: Phpmyadmin
Database Tools: Oo Programming With Embedded Sql User-defined Functions / Stored Procedures (Pl/sql, Transact-sql)
Database Tools: Querysurge
Software: Samba
Software: Version Control (Subversion / Cvs / Pvcs / Git), Tortoise
Software: Apache/tomcat Web Server
Software: Gnu Toolchain
Software: Directory Server (Ldap)
Office Applications: Ms Word
Office Applications: Ms Excel
Office Applications: Ms Access
Office Applications: Ms Powerpoint
Office Applications: Ms Visio
Office Applications: Ms Project
Protocols: Http
Protocols: Tcp/ip
Protocols: Ppp
Protocols: Client/server With Socket Programming

Languages

German

Native

English

Advanced

French

Elementary

Education

Oct 1990 - Mar 1998

University of Bonn (Friedrich Wilhelm University)

Diploma in Computer Science · Computer Science · Bonn, Germany

Jul 1985 - Jun 1988

Adolf Kolping College, Kerpen-Horrem

General University Entrance Qualification (Abitur) · Technical Assistant in Electrical Engineering (TAE) · Kerpen, Germany

Jul 1985 - Jun 1988

Adolf Kolping College, Kerpen-Horrem

State-Certified Technical Assistant in Electrical Engineering · Electrical Engineering

Certifications & licenses

Prince2 Project Management

Statistics

Experience

Total positions 17

Experience in Insurance 18 y

Avg length 1 y 11 m

Longest experience 4 y 11 m

Global Experience

Countries worked in 6 (Germany, Switzerland, New Zealand, Sweden, Austria, +1)

Primary country Germany

Expertise

Recent roles Data Warehouse Consultant (Development and Analysis), Manager and Solutions Architect, Team Lead and Data Migration Expert

Main industries Insurance, Banking and Finance, Information Technology

Main business areas Business Intelligence, Information Technology, Quality Assurance

Qualifications

Certifications earned 1

Profile

Created

May 2025

Last Update

March 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Peter based?

Peter is based in Cologne, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Peter speak?

Peter speaks the following languages: German (Native), English (Advanced), French (Elementary).

How many years of experience does Peter have?

Peter has at least 22 years of experience. During this time, Peter has worked in at least 12 different roles and for 15 different companies. The average length of individual experience is 1 year and 4 months. Note that Peter may not have shared all experience and actually has more experience.

What roles would Peter be best suited for?

Based on recent experience, Peter would be well-suited for roles such as: Data Warehouse Consultant (Development and Analysis), Manager and Solutions Architect, Team Lead and Data Migration Expert.

What is Peter's latest experience?

Peter's most recent position is Data Warehouse Consultant (Development and Analysis) at Atruvia AG.

What companies has Peter worked for in recent years?

In recent years, Peter has worked for Atruvia AG, Mobiliar Insurance, PostFinance, and Deutsche Bundesbank.

Which industries is Peter most experienced in?

Peter is most experienced in industries like Insurance, Banking and Finance, and Transportation. Peter also has some experience in Information Technology, Agriculture, and Biotechnology.

Which business areas is Peter most experienced in?

Peter is most experienced in business areas like Business Intelligence, Information Technology, and Quality Assurance. Peter also has some experience in Operations.

Which industries has Peter worked in recently?

Peter has recently worked in industries like Banking and Finance, Insurance, and Information Technology.

Which business areas has Peter worked in recently?

Peter has recently worked in business areas like Business Intelligence, Information Technology, and Quality Assurance.

What is Peter's education?

Peter attended University of Bonn (Friedrich Wilhelm University) for Computer Science.

Does Peter have any certificates?

Peter has 1 certificate: Prince2 Project Management.

What is the availability of Peter?

Peter will be available full-time from April 2026.

What is the rate of Peter?

Peter's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.