Michael Ternes - Senior DWH Developer

Q: Where is Michael based?

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

Q: What languages does Michael speak?

Michael speaks the following languages: German (Native), English (Advanced), Italian (Advanced) .

Q: How many years of experience does Michael have?

Michael has at least 12 years of experience. During this time, Michael has worked in at least 8 different roles and for 9 different companies . The average length of individual experience is 1 year and 1 month . Note that Michael may not have shared all experience and actually has more experience.

Q: What is Michael's latest experience?

Michael's most recent position is ETL Developer at Insurance service provider .

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

In recent years, Michael has worked for Insurance service provider , Telecommunications provider with a branch in Munich , In-house development , HD PLUS GmbH , and Uniqa Versicherungen .

Q: Which industries is Michael most experienced in?

Michael is most experienced in industries like Telecommunication , Information Technology , and Media and Entertainment . Michael also has some experience in Insurance and Retail .

Q: Which business areas is Michael most experienced in?

Michael is most experienced in business areas like Business Intelligence , Information Technology , and Project Management . Michael also has some experience in Operations .

Q: Which industries has Michael worked in recently?

Michael has recently worked in industries like Telecommunication , Information Technology , and Insurance .

Q: Which business areas has Michael worked in recently?

Michael has recently worked in business areas like Business Intelligence , Information Technology , and Project Management .

Recommended expert

Munich, Germany

Check rate

Experience

Aug 2025 - Present

1 year

ETL Developer

Insurance service provider

DWH for customer and financial data

Extension of the DWH with new data sources
Report development
Data quality management

Methodology: Scrum

Tools: Atlassian Confluence & Jira

Databases: Microsoft SQL Server

Programming languages: SQL, T-SQL

ETL: Microsoft SQL Server Integration Services (SSIS)

Frontend platform: PowerBI, Microsoft Reporting Services

May 2024 - Jul 2025

1 year 3 months

Munich, Germany

DWH Developer

Telecommunications provider with a branch in Munich

DWH for CRM

Development of a datamart for IFRS 15
Development of an APEX application for master data maintenance

Methodology: Scrum

Environment: Oracle 19c

Modeling: Data Vault 2.0

Tools: Atlassian Confluence & Jira

Databases: Oracle, Databricks

Programming languages: SQL, PL/SQL

Frontend platform: Oracle Apex

Jan 2024 - Present

2 years 7 months

Project manager and developer

In-house development

Development of an application for data analysis

Methodology: Scrum

Environment: Postgres, Flask

Programming languages: SQL, Bash, Python

Apr 2022 - May 2024

2 years 2 months

Munich, Germany

DWH Developer

Telecommunications provider with a branch in Munich

DWH for CRM and technical infrastructure

Extension of the core DWH with technical assets and infrastructure
Performance tuning of long-running load processes
Support with system operations
Management of Cognos metadata with Framework Manager and Transformer

Methodology: Scrum

Environment: Oracle 19c

Reporting: Cognos BI 11, Tableau

Programming languages: SQL, PL/SQL, Bash, Python

Oct 2020 - Mar 2022

1 year 6 months

DWH Developer

HD PLUS GmbH

DWH for CRM

Detailed design of KPI requirements
Connection of new data sources
Implementation of ETL flows

Methodology: Scrum

Environment: PostgreSQL, Oracle

Tools: datasqill, DataGrip, git

Programming languages: SQL, Bash

Mar 2020 - Dec 2021

1 year 10 months

Solution Architect

Uniqa Versicherungen

Development of a database for portfolio analysis

Gathering requirements (use cases, budget targets)
Provisioning a PostgreSQL database with AWS RDS
Provisioning a container with Apache Airflow
Installing a Tableau server in AWS
Modeling the data structure according to Data Vault 2.0
Regular import of source data
Implementing the data flow from staging area to data mart with Informatica PowerCenter

Method: Scrum

Environment: Amazon Web Services, PostgreSQL, Tableau

Tools: Informatica PowerCenter, Docker, Airflow, PyCharm, DataGrip, git

Programming languages: SQL, PL/pgSQL, Python

Dec 2017 - Dec 2019

2 years 1 month

Technical Project Manager, Solution Architect

GEMA/ICE (International Copyright Enterprise)

Migration of applications from GEMA IT to ICE IT

Consolidation of systems
Replacing systems through new development based on AWS
Operating replication between core system and DWH using GoldenGate

Method: Scrum

Environment: Oracle 12g, Oracle Exadata, Oracle GoldenGate, Databricks, Amazon Web Services

Tools: git, Atlassian Confluence

Programming languages: PL/SQL, Python

Jul 2017 - Nov 2017

5 months

Project Manager

GEMA/ICE (International Copyright Enterprise)

Setting up a colocation site to operate an Oracle Exadata half rack

Subprojects:

Hardware sizing
WAN connection
Deployment of firewall and VPN
Deployment of Exadata
Migration of the production database

Jul 2015 - Dec 2023

8 years 6 months

Munich, Germany

Cognos Consultant

Telecommunications service provider with a branch in Munich

Design and implementation of reports based on Asset Management and Request Management
Metadata management
Consulting on migration from Cognos to Power BI

Environment: Windows 8/10, Oracle 12g, Cognos BI 10

Tools: Remedy, Atlassian Jira

Programming languages: SQL

Feb 2015 - Jun 2017

2 years 5 months

Principal Consultant DWH/ETL/BI

GEMA

Creating a data warehouse to support reporting in the Backoffice Online area

Creating the overall architecture
Modeling the data structures
Setting up replication with GoldenGate
Creating an ETL framework based on PL/SQL

Environment: Oracle Linux, Oracle 12g, Oracle Database Appliance (ODA) X5-2

Tools: SQL Developer, Oracle GoldenGate

Programming languages: PL/SQL

Apr 2014 - Jul 2016

2 years 4 months

Principal Consultant DWH/ETL/BI

REWE Zentralfinanz

Design and implementation of the migration of the master data interface for articles to GDSN

Environment: Windows 7, SQL Server 2010

Tools: SQL Server Integration Services 2010

Programming languages: SQL, XSLT

Industry Experience

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

Experienced in Telecommunication, Information Technology, Media and Entertainment, Insurance, and Retail.

Telecommunication

Information Technology

Media and Entertainment

Insurance

Retail

Business Area Experience

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

Experienced in Business Intelligence, Information Technology, Project Management, and Operations.

Business Intelligence

Information Technology

Project Management

Operations

Summary

Consultant for Business Intelligence/Data Warehousing/ETL with more than 15 years of experience

Skills

Database Development With A Focus On Dwh & Data Mart
Interface Role Between Business And It
Modeling Of Dwh Systems And Processes
Analysis And Tuning Of Sql Queries
Requirements Analysis, Project Management, And Optimization Of The Development Process
Portfolio/Investment Management, Asset Management
Banking
Insurance
Telecommunications
Retail
Media

Oracle Database +++

Pl/Sql
Exadata
Apex (Application Express)
Goldengate
Performance Tuning

Microsoft Sql Server +++

T-Sql
Ssis (Integration Services)
Ssrs (Reporting Services)
Powerbi
Fabric

Postgresql +++

Pl/Pssql
Migration From Oracle To Postgres

Python +++

Jupyter Notebooks
Pandas
Numpy
Flask
Pyspark

Tools

Git
Svn
Apache Airflow
Jira
Confluence

Languages

German

Native

English

Advanced

Italian

Advanced

Education

TU Ilmenau

Diploma · Business Informatics

Certifications & licenses

Amazon Certified Cloud Practitioner

Cognos Enterprise Business Intelligence Solutions Professional certification

Statistics

Experience

Total positions 11

Experience in Telecommunication 10 y

Avg length 2 y 3 m

Longest experience 8 y 5 m

Global Experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Recent roles ETL Developer, DWH Developer, Project manager and developer

Main industries Telecommunication, Information Technology, Media and Entertainment

Main business areas Business Intelligence, Information Technology, Project Management

Qualifications

Highest degree Master

Certifications earned 2

Profile

Created

July 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Michael based?

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

What languages does Michael speak?

Michael speaks the following languages: German (Native), English (Advanced), Italian (Advanced).

How many years of experience does Michael have?

Michael has at least 12 years of experience. During this time, Michael has worked in at least 8 different roles and for 9 different companies. The average length of individual experience is 1 year and 1 month. Note that Michael may not have shared all experience and actually has more experience.

What roles would Michael be best suited for?

Based on recent experience, Michael would be well-suited for roles such as: ETL Developer, DWH Developer, Project manager and developer.

What is Michael's latest experience?

Michael's most recent position is ETL Developer at Insurance service provider.

What companies has Michael worked for in recent years?

In recent years, Michael has worked for Insurance service provider, Telecommunications provider with a branch in Munich, In-house development, HD PLUS GmbH, and Uniqa Versicherungen.

Which industries is Michael most experienced in?

Michael is most experienced in industries like Telecommunication, Information Technology, and Media and Entertainment. Michael also has some experience in Insurance and Retail.

Which business areas is Michael most experienced in?

Michael is most experienced in business areas like Business Intelligence, Information Technology, and Project Management. Michael also has some experience in Operations.

Which industries has Michael worked in recently?

Michael has recently worked in industries like Telecommunication, Information Technology, and Insurance.

Which business areas has Michael worked in recently?

Michael has recently worked in business areas like Business Intelligence, Information Technology, and Project Management.

What is Michael's education?

Michael holds a Master in Business Informatics from TU Ilmenau.

Does Michael have any certificates?

Michael has 2 certificates. These include: Amazon Certified Cloud Practitioner and Cognos Enterprise Business Intelligence Solutions Professional certification.

What is the availability of Michael?

Michael is immediately available full-time for suitable projects.

What is the rate of Michael?

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