Matthias Scherer - IBM InfoSphere DataStage Senior Consultant

Q: Where is Matthias based?

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

Q: What languages does Matthias speak?

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

Q: How many years of experience does Matthias have?

Matthias has at least 38 years of experience. During this time, Matthias has worked in at least 11 different roles and for 16 different companies . The average length of individual experience is 2 years and 11 months . Note that Matthias may not have shared all experience and actually has more experience.

Q: What is Matthias's latest experience?

Matthias's most recent position is IBM InfoSphere DataStage Senior Consultant at KKH (Kaufmännische Krankenkasse Hannover) .

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

In recent years, Matthias has worked for KKH (Kaufmännische Krankenkasse Hannover) , Deutsche Bundesbank , Hanseatic Bank , and BG-Phoenics .

Q: Which industries is Matthias most experienced in?

Matthias is most experienced in industries like Information Technology (IT) , Banking and Finance , and Aerospace and Defense . Matthias also has some experience in Chemical , Insurance , and Manufacturing .

Q: Which business areas is Matthias most experienced in?

Matthias is most experienced in business areas like Information Technology (IT) , Business Intelligence , and Quality Assurance (QA) . Matthias also has some experience in Project Management and Finance .

Q: Which industries has Matthias worked in recently?

Matthias has recently worked in industries like Chemical , Insurance , and Banking and Finance .

Q: Which business areas has Matthias worked in recently?

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

Recommended expert

Hallbergmoos, Germany

Experience

Dec 2023 - Dec 2025

2 years 1 month

Hanover, Germany

IBM InfoSphere DataStage Senior Consultant

KKH (Kaufmännische Krankenkasse Hannover)

Data migration from BVS to BITMARCK 21c|ng
Test case creation; test execution and result analysis of the ETL processes
Consulting on detailed planning and test execution
Job review
Development
Documentation
Error analysis & fixing / new development
System environment: Windows 10; IBM InfoSphere DataStage 11.7.x; IBM DB2 z/OS; IBM DB2 LUW; PL/SQL; SQL; DBeaver 25.x; MS Office 365; Atlassian JIRA

Apr 2023 - Nov 2023

8 months

Frankfurt, Germany

IBM InfoSphere DataStage Senior Consultant

Deutsche Bundesbank

Test case creation; test execution and result analysis of the ETL processes
Consulting on detailed planning and test execution
Job review
Development
Documentation
Error analysis & fixing / new development
System environment: Windows 10; IBM InfoSphere DataStage 11.7; IBM DB2 z/OS; PL/SQL; SQL; Db Visualizer Pro 11.x; MS Office Pro 2016 Plus; Atlassian JIRA; Oracle 12c & 19c

Sep 2021 - Mar 2023

1 year 7 months

Hamburg, Germany

IBM InfoSphere DataStage Senior Consultant

Hanseatic Bank

Development of various input interfaces for BAIS (Banking Supervision Information System) in the area of bank control/reporting (e.g. FinRep/Liqui/WIFSta)
Documentation
Error analysis
System environment: Windows 10; IBM InfoSphere DataStage 11.7; IBM DB2 UDB for AS/400; PL/SQL; SQL; Db Visualizer Pro 10.x; MS Office Pro 2016 Plus; MS 365; Atlassian JIRA; Oracle 12c & 19c

Mar 2017 - Jul 2021

4 years 5 months

Munich, Germany

IBM InfoSphere DataStage Senior Consultant

BG-Phoenics

Implementation of the DWH for BG RCI (Raw Materials/Chemicals)
Integration of District Administration 7 into BGN
Development of DataStage jobs
Creation of business and mapping concepts for the DWH
Testing and review of ETL jobs (test and defect management)
Documentation
Error analysis
Support in operations
Migration from DB2 to SAP HANA & EDB
System environment: Windows 8.1 Pro Client & Windows 10; IBM InfoSphere DataStage 9.1.2 & 11.3; IBM DB2; SAP HANA; Enterprise DB (Postgres); PL/SQL; SQL; Squirrel 3.5.x; IBM Lotus Notes 9.x; Office 365; HP Service Manager 7 & 9; IBM Rational Synergy; Git for Windows; Atlassian JIRA

Feb 2017 - Dec 2017

11 months

Landshut, Germany

Senior Consultant in Controlling

E.ON

Interface development MS Excel <--> MS Access
Consulting in data management
Consulting in interface management
Consulting in performance tuning and optimization
System environment: Windows 7 Pro Client 64-bit; SQL; MS Access 2010; MS Excel 2010

Jul 2016 - Feb 2017

8 months

Saarbrücken, Germany

IBM InfoSphere DataStage Senior Consultant

Cosmosdirekt

Development of DataStage jobs in the CRM area
Creating functional and mapping concepts for the DWH
Testing and reviewing ETL jobs (test and defect management)
Documentation
Error analysis
System environment: Windows 7 Professional Client 64-bit; IBM InfoSphere DataStage 9.1; Oracle 11g; PL/SQL; SQL; AIX 7.1; SQL Navigator 6.7x; IBM Lotus Notes 8.5

Jan 2016 - Apr 2016

4 months

Munich, Germany

Data Quality Senior Consultant

Data quality analysis within the DWH
Creating functional and mapping concepts
Testing and reviewing ETL jobs (test and defect management)
Documentation
Error analysis
System environment: Windows 7 Enterprise Client 64-bit; IBM InfoSphere DataStage 9.x; Oracle 11.x; PL/SQL; SQL

Oct 2015 - Dec 2015

3 months

Nuremberg, Germany

IBM InfoSphere DataStage Senior Consultant

ING-DiBA

Migration from Oracle Warehouse Builder (OWB) to IBM DataStage 11.3x for the DWH
Creating functional and mapping concepts
Developing, testing and reviewing ETL jobs (test and defect management)
Documentation
Error analysis
Scheduling and organization (Automatic One Automation, formerly UC4)
Staff coaching
System environment: Windows 7 Enterprise Client 64-bit; IBM InfoSphere DataStage 11.3x; Oracle 11.x and 12.x; Oracle Warehouse Builder (OWB) 11g; TOAD 11.x; Automatic One Automation – UC4 Vers. 10; PL/SQL; SQL

Mar 2015 - Jul 2015

5 months

IBM InfoSphere DataStage Senior Consultant

Hagemeyer Deutschland

Development of jobs for migrating from IBM Cognos Data Manager 10.2.x to IBM DataStage 11.3.x for the DWH
Creating functional and mapping concepts
Developing, testing and reviewing ETL jobs
Documentation
Error analysis
Scheduling and organization
Staff coaching
System environment: Windows 7 Professional Client; IBM InfoSphere DataStage 11.3x on Windows; IBM Cognos Data Manager 10.2x; IBM DB2 10.5x; IBM (Lotus) Notes 9.0x; IBM Data Studio 4.1.x; PL/SQL; SQL

Sep 2014 - Mar 2015

7 months

Hanover, Germany

IBM InfoSphere DataStage Senior Consultant

Nord/LB

SPOT (Single Point of Truth) – development
Creating functional and mapping concepts
Developing, testing and reviewing ETL jobs (test and defect management) within the DWH
Documentation
Error analysis
Loan data model migration for the bank
Loan IQ – business analysis implementations
Scheduling and organization
System environment: Windows XP Client; IBM InfoSphere DataStage 8.7x on Linux; IBM DB2 9.5x; Rational ClearCase 7.1x; Lotus Notes 8.5x; PL/SQL; SQL

Jul 2010 - Aug 2014

4 years 2 months

Munich, Germany

IBM InfoSphere DataStage Senior Consultant

Unicredit

Creating business and mapping concepts
Building, testing, and reviewing ETL jobs (test and defect management) within the DWH
Documentation
Project coordination
Error analysis
Staff coaching
Migration from 7.5x to 8.1 to 8.5x
System environment: Windows XP Client and Windows Vista Client; IBM InfoSphere DataStage DS/EE 7.5.2, 8.1, 8.5x and 8.7x on SunOS 5.9, AIX 5.3 and Linux Grid; Serena ChangeMan Dimensions 3.x and 10.x; IBM DB2; Oracle 9i/10.x; Teradata; TOAD 8.6.10; PL/SQL; SQL; Mercury Quality Center 9.x

Feb 2010 - May 2010

4 months

IBM InfoSphere DataStage Senior Consultant

Versicherungskammer Bayern

Creating ETL jobs to reload fact tables to the new sales structure within the DWH
Modifying jobs to access the new sales structure
Building new jobs for the core load
Building new jobs for the dimension load
Building new jobs for loading fact tables
Developer testing
Documentation
Error analysis across the whole data warehouse process
Process planning and organization
Staff coaching
System environment: Windows XP Client; IBM InfoSphere DataStage DS/EE 7.5.1 (Parallel Extender) on AIX 5.3; IBM DB2; PL/SQL; SQL

Aug 2007 - Jan 2010

2 years 6 months

Munich, Germany

Consultant EuroSIG Data Migration

Hypovereinsbank IS (HVB IS)

Building a migration platform with IBM DataStage EE 7.5.2 & IBM WebSphere DataStage 8.x on SunOS 5.9 / AIX 5.3 with IBM DB2 and Oracle 9i/10.x for DWH data migration
Analyzing, developing, implementing, and testing complex transformation rules in close cooperation with business units
Preparing test and handover concepts and developing complex control flows
Performance tuning of DataStage jobs
Performance analysis and tuning of end-to-end processes
Staff coaching
System environment: Windows XP Client; IBM DataStage DS/EE 7.5.2 and 8.x on SunOS 5.9 / AIX 5.3; Serena ChangeMan Dimensions; IBM DB2; Oracle 9i/10.x; TOAD 8.6.10; PL/SQL; SQL

Jun 2007 - Jul 2007

2 months

Munich, Germany

Consultant Wealth Management (MiFID - Triple'A)

Hypovereinsbank IS (HVB IS)

Extending the T2 interface to Triple'A with DataStage TX and Sybase SQL: analysis, development/implementation, extension, and adjustment of DataStage TX mappings for data transformation and providing import data for Triple'A
Analyzing and extending complex Sybase SQL statements for data extraction and generating data files for import into Triple'A
System environment: Windows XP Client; IBM DataStage TX 7.5.1 on SunOS 5.9; Sybase 12.51; Triple'A 4.12.2; Serena ChangeMan Dimensions 3.1.3.3; PL/SQL; SQL

Sep 2005 - May 2007

1 year 9 months

Unterföhring, Germany

Consultant

Pro7

Coordinating developers
Code review within the complex DWH
Creating test plans and scenarios (test planning, preparation, and execution)
Setting up the component structure
Process optimization of load runs (approx. 1,200 runs)
Running the data warehouse using a batch concept
Creating and executing migration concepts
Developing and implementing ETL processes
System environment: Windows XP Client; IBM DataStage 7.1r1 on SunOS 5.9; Informix 7 and 10; Rational Software Suite; Business Objects 5.1; Informix Server Studio JE 5.1; SQL Navigator; PL/SQL; SQL

Apr 2004 - Aug 2005

1 year 5 months

Munich, Germany

Freelance Data Warehouse Consultant for Munich Re

Siemens Business Services

Setup of a complete DataStage system environment (test, integration, and production) with DataStage 7.x, Windows Server 2003, Oracle 9.x, SAP BW 3.5x
Interface development with Ascential DataStage 7.5x between SAP BW 3.5x and external systems using the Open Hub architecture
System environment: Windows Server 2003; Windows 2000 client; SAP BW 3.5x; Oracle 9i; Ascential DataSage 7.5x; SAP FS-RI; Mercury TestDirector 8.x; TOAD; SQL Navigator; PL/SQL; SQL

May 2000 - Mar 2004

3 years 11 months

Munich, Germany

Freelance Data Warehouse Consultant for Infineon

Siemens Business Services

Development, implementation, and maintenance of a DataStore 'Production Order Status' with DataStage 3.6 and Oracle 8.1.7
Analysis, implementation, and maintenance of metrics in the 'Balanced Scorecard' project with DataStage 4.03
Analysis and development of metrics in the 'Process Performance Measurement' project with DataStage 4.03
Analysis and development of a DataStore 'Cycle Time Monitoring' with DataStage 6.x
Experience with MetaStage 2.x and the DataStage XML pack
SQL and PL/SQL programming
System environment: SUN-UNIX; Windows NT; Ascential DataStage 3.6-6.x; Oracle 8.x

Mar 1999 - Apr 2000

1 year 2 months

Munich, Germany

Consultant for Data Warehouse Design and Setup

Siemens AG

DB2 on MVS OS/390 (basic knowledge)
ETL tool Informix DataStage; programming
Metadata management with MetaStage
Hyperion Essbase as front-end database
SAP R/3 load pack for DataStage
System environment: MVS OS/390; Windows NT; SAP R/3; DataStage 3.6

Mar 1995 - Feb 1999

4 years

Munich, Germany

Freelance IT Generalist

Siemens AG

Oracle 7.1 database administration
SUN system administration Solaris 2.4
User support on Novell 3.11 and Windows NT 4.0
Access database programming
Point of contact for intranet solutions, hardware and software procurement, MS Office product line
Collaboration on the introduction of the SAP R/3 PS module
System environment: SUN-UNIX; Windows NT; Novell; SAP R/3

Jul 1985 - Dec 1993

8 years 6 months

Germany

First Lieutenant

Bundeswehr (Luftwaffe)

Final rank: First Lieutenant
Further training: SUN system administrator Solaris 2.4; Oracle database administrator; Certified Internet Engineer; basic SAP R/3; Essbase; DataStage/MetaStage; DB2 on MVS

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 Information Technology (14 years), Banking and Finance (9 years), Aerospace and Defense (8.5 years), Chemical (4.5 years), Insurance (4 years), and Manufacturing (4 years).

Information Technology

Banking and Finance

Aerospace and Defense

Chemical

Insurance

Manufacturing

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 Information Technology (31.5 years), Business Intelligence (24 years), Quality Assurance (10 years), Project Management (4.5 years), and Finance (1.5 years).

Information Technology

Business Intelligence

Quality Assurance

Project Management

Finance

Skills

Sun System Administrator Solaris 2.4
Oracle Database Administrator (Oracle 7)
Cie – Certified Internet Engineer
Sap R/3 – Basic Knowledge (Ps Module)
Hyperion Essbase (Multidimensional Database)
Ibm Datastage/metastage (Formerly Ascential Software)
Db/2 For Os/390 On Mvs

Languages

German

Native

English

Advanced

French

Elementary

Education

Oct 1986 - Mar 1990

University of the Federal Armed Forces

Diplom-Informatics graduate (univ.), Applied Computer Science and Software Development in a Team · Computer Science · Munich, Germany · 2,34

Certifications & licenses

CIE – Certified Internet Engineer

Profile

Created

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 Matthias based?

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

What languages does Matthias speak?

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

How many years of experience does Matthias have?

Matthias has at least 38 years of experience. During this time, Matthias has worked in at least 11 different roles and for 16 different companies. The average length of individual experience is 2 years and 11 months. Note that Matthias may not have shared all experience and actually has more experience.

What roles would Matthias be best suited for?

Based on recent experience, Matthias would be well-suited for roles such as: IBM InfoSphere DataStage Senior Consultant, Senior Consultant in Controlling, Data Quality Senior Consultant.

What is Matthias's latest experience?

Matthias's most recent position is IBM InfoSphere DataStage Senior Consultant at KKH (Kaufmännische Krankenkasse Hannover).

What companies has Matthias worked for in recent years?

In recent years, Matthias has worked for KKH (Kaufmännische Krankenkasse Hannover), Deutsche Bundesbank, Hanseatic Bank, and BG-Phoenics.

Which industries is Matthias most experienced in?

Matthias is most experienced in industries like Information Technology (IT), Banking and Finance, and Aerospace and Defense. Matthias also has some experience in Chemical, Insurance, and Manufacturing.

Which business areas is Matthias most experienced in?

Matthias is most experienced in business areas like Information Technology (IT), Business Intelligence, and Quality Assurance (QA). Matthias also has some experience in Project Management and Finance.

Which industries has Matthias worked in recently?

Matthias has recently worked in industries like Chemical, Insurance, and Banking and Finance.

Which business areas has Matthias worked in recently?

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

What is Matthias's education?

Matthias attended University of the Federal Armed Forces for Computer Science.

Does Matthias have any certificates?

Matthias has 1 certificate: CIE – Certified Internet Engineer.

What is the availability of Matthias?

Matthias will be available full-time from March 2026.

What is the rate of Matthias?

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