Peter Brungs - Data Warehouse Consultant (Development and Analysis)

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 Versicherung , 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 and Logistics . Peter also has some experience in Information Technology (IT) , Agriculture , and Biotechnology .

Q: Which business areas is Peter most experienced in?

Peter is most experienced in business areas like Business Intelligence , Information Technology (IT) , and Quality Assurance (QA) . 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 (IT) .

Q: Which business areas has Peter worked in recently?

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

Recommended expert

Cologne, Germany

Experience

Jan 2025 - Dec 2025

1 year

Karlsruhe, Germany

Remote

Data Warehouse Consultant (Development and Analysis)

Atruvia AG

Developed and extended ETL data 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 scripts in MS PowerShell and documented GIT deployment processes
Technologies: RedHat Linux, IBM DB2 with DB Visualizer, 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 Versicherung

Developed and modeled a new data warehouse core in consultation with the business department
Created ad hoc reports and risk analyses based on the DWH core for the business side
Supported the development of a business layer based on the DWH core
Defined and reviewed data mappings
Developed and extended ETL data 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 a new data compression feature into the data warehouse
Connected data from IBM CDC and the Kafka/Avro Schema Registry and Kafka Connect framework to IBM DataStage using the Java Integration Stage
Involved in topics: contract, partner, object, product, location, claim
Updated SAP BO reports, universes, and list-of-values
Tested and updated InfoBurst configurations
Reverse-engineered historical ETL processes and fixed issues
Monitored daily data processing and resolved loading issues in PL/SQL, Unix scripts, and ETL processes
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 ad hoc SQL queries and optimized their execution time through index tuning
Prototyped partition and tablespace distribution for large tables
Developed ETL data loading jobs in Python (Pandas) in an IntelliJ environment
Optimized data query performance in Oracle DB through indexes, pragmas, and partitioning
Technologies: Oracle 19c, TOAD, SQLDeveloper, 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 data loading jobs with IBM DataStage and Unix Bash scripting
Prototyped DataStage with Unix control and generic ETL data loading
Created and loaded error log tables and views
Created mapping specifications
Created XML-SQL queries, views, and extractions
Analyzed data quality and tested consistency
Integrated CRDM master data and RTGS/CLM transaction data with Target2
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 Versicherung

Developed and modeled a new data warehouse core in consultation with the business department
Created ad hoc reports and risk analyses based on the DWH core for the business side
Supported the development of a business layer based on the DWH core
Defined and reviewed data mappings
Developed and extended ETL data 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 a new data compression feature into the data warehouse
Connected data from IBM CDC and the Kafka/Avro Schema Registry and Kafka Connect framework to IBM DataStage using the Java Integration Stage
Involved in topics: contract, partner, object, product, location, claim
Updated SAP BO reports, universes, and list-of-values
Tested and updated InfoBurst configurations
Reverse-engineered historical ETL processes and fixed issues
Monitored daily data processing and resolved loading issues in PL/SQL, Unix scripts, and ETL processes
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

Introduced a new insurance data model based on IBM IAA (partner, contract, commission, claim, product business system) with a matching data warehouse architecture
Connected open data sources for banks using MS-SSIS ETL tool (Web Services/REST)
Migrated MS Project data into a Tableau application
Wrote a whitepaper 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 contact for resolving technical and functional issues
Analyzed data quality of contract and collection/debt collection data in a staging database and 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 collaboration 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 generic insurance data model in ETL using DataStage, populating data marts (star schema) and a hub-and-spoke architecture
Wrote ad-hoc queries for the management information system in PL/SQL with explain plans and parallelization
Designed and implemented data extractions based on business requirements for commission and 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 troubleshooting and feature expansion of ETL jobs in a CRM system
Performed functional testing of SOAP components and assisted in software enhancements
Designed and implemented 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, SAP GUI, DataStage 7.52, DB2, SoapUI, SAP NetWeaver

Jan 2008 - Dec 2012

5 years

Cologne, Germany

ETL Data Integration Expert

Talanx-HDI-Gerling Versicherung

Created 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 the database, including SQL optimization and guidelines for the database administrator
Managed 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 enhanced control scripts (ksh) for ETL and data extraction job scheduling
Maintained and improved a frontend tool for master data representation in a 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 DB interfaces using 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 a blueprint document 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 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 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 for ETL Process Review

Nordea Bank

Code review of DataStage ETL implementations and PowerCenter Informatica according to business transformation rules
Ensuring and improving data quality by comparing data, data structures and data models
Evaluating mapping rules against programmed stored procedures
Introducing a new documentation standard for stored procedures
Designing process improvements in the data warehouse and presenting 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 support for the business side to improve data quality
Creation of SQL programs for data analysis for Oracle DB
Design and programming of ETL routines for Ascential DataStage and improvement of 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
Controlling DataStage jobs with custom 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 support for 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 using Ascential Profile Stage
ETL concept and implementation of interfaces as part of 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 for version-controlled management of the data warehouse process with PHP on HP Unix
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
Creating dynamic spatial web applications with XML/XSLT and VRML
Designing dynamic web pages with JSP to display database content
Developing dialog-based Java applications for data entry
Analyzing and developing assembler modules and 3D visualization technologies
Development of insurance software on client-server and mainframe systems with DB2
Data migration from IBM mainframe DB2 to Windows and OS/2 environments
Quality management and testing of C/C++ software solutions for insurance data
Introducing faster database access solutions with SQL and C++ on DB2
Design of Java/JDBC and JSP web applications

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Insurance (18 years), Banking and Finance (10.5 years), Information Technology (2 years), Transportation (2 years), Agriculture (1 year), and Biotechnology (1 year).

Insurance

Banking and Finance

Information Technology

Transportation

Agriculture

Biotechnology

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (22 years), Information Technology (22 years), Quality Assurance (5 years), and Operations (1 year).

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 Data 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: Systems Analysis And System Integration
Methods: Quality Management
Methods: Release And Change
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 Businessobjects (+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 Relevant Plug-ins
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: Oop 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

State-certified Technical Assistant in Electrical Engineering · Electrical Engineering

University of Bonn

Diploma in Computer Science · Computer Science · Bonn, Germany

General University Entrance Qualification (Abitur)

Certifications & licenses

PRINCE2 Project Management

Profile

Created

May 2025

Last Update

February 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 Versicherung, Postfinance, and Deutsche Bundesbank.

Which industries is Peter most experienced in?

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

Which business areas is Peter most experienced in?

Peter is most experienced in business areas like Business Intelligence, Information Technology (IT), and Quality Assurance (QA). 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 (IT).

Which business areas has Peter worked in recently?

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

What is Peter's education?

Peter attended education in Electrical Engineering.

Does Peter have any certificates?

Peter has 1 certificate: PRINCE2 Project Management.

What is the availability of Peter?

Peter is immediately available full-time for suitable projects.

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.