Database Developer, mit Schwerpunkt DataWarehousing, ETL, BigData hauptsächlich im Oracle Umfeld - SQL, PL/SQL, OWB, ODI
Aktualisiert am 28.09.2020
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.10.2020
Verfügbar zu: 100%
davon vor Ort: 100%
Englisch

Einsatzorte

Einsatzorte

Österreich, Schweiz, Deutschland

Deutschland bevorzugt, gerne auch Projekte im Ausland, sofern Projektsprache Englisch

nicht möglich

Projekte

Projekte

9 Monate
2019-02 - 2019-10

Implementation of a Datalandscape for Digitalisation- Requirements

Entwicklung und Test PL/SQL DataVault 2.0 Star Schema ...
Entwicklung und Test

Migration of existing DataMarts into a consolidated DataVault2.o landscape

Development of needed ETL components for dataload from Source – DataVault – Star - DataMart

testing and documentation

Oracle12c Oracle SQL Developer Atlassian Confluence Atlassian JIRA Oracle Data Integrator
PL/SQL DataVault 2.0 Star Schema ETL
industry: Finance
10 Monate
2018-03 - 2018-12

Application Management and Application Development: Antragsdatamart (ADM) for Internal and Regulatory Reporting

Konzeption / Entwicklung / Testen / Dokumentation Datenanalyse Datenmigration Datenbankdesign ...
Konzeption / Entwicklung / Testen / Dokumentation

Testing for Migration from Oracle 11 to Oracle 12

Application Architecture for a Contract Database for Budgeting of received EU/Sax fundings

Implementation of new functionality / enhancements to the application (ADM), testing and documentation

Oracle 11g Oracle 12c Oracle SQL Developer Toad for Oracle Atlassian JIRA
Datenanalyse Datenmigration Datenbankdesign Anwendungsdesign Anwendungsbetrieb Testdesign
industry: Finance
7 Monate
2017-07 - 2018-01

Application Management: Enterprise Datawarehouse (EDWH)

Anwendungsbetreuung Anwender-Support Anwendungsbetreuung ETL ...
Anwendungsbetreuung

Monitoring and management of EDWH monthly load cycle

coordination with EDWH technical services

Incident and issue management for EDWH

Coordination and management of test cycles for group datawarehouse releases to assure EDWH compliance

Oracle 12c Terradata 16 Oracle Data Integrator UC4 Atlassian JIRA Atlassian Confluence
Anwender-Support Anwendungsbetreuung ETL Anwendungsbetrieb DevOps test coordination
industry: Finance
3 Monate
2017-04 - 2017-06

Migration of JAVA application stack's logic layer to PostgreSQL

Analyse / Design / Implementation / Testen / Dokumentation / Anwendungsdesign Datenbankdesign
Analyse / Design / Implementation / Testen / Dokumentation /

analysis of existing java application

adaption and revision of logic

implementation and testing

documentation

JAVA PostgreSQL Atlassian JIRA SVN Pg/SQL
Anwendungsdesign Datenbankdesign
industry: automotive supply
2 Jahre 5 Monate
2014-09 - 2017-01

Implementation of BI Infrastructures Data Layer Data Definition and Data Modelling into DataVault

Analyse / Konzeption / Implementierung Datenanalyse System Integration Prozessanalyse ...
Analyse / Konzeption / Implementierung

Prototyp of ETL processes in ODI and OWB

Implementation of Data Quality definitions

Concept of an Integrated Data Layer

System architecture / design for integrating current data, reporting and processual demands into BI infrastructures

Data Layer

Processual and functional analysis of existing IT Reporting Infrastructure components – datamarts and further data sources / consumers focussing on integrational aspects

SAP Business Objects Oracle 11g Atlassian JIRA SAP CML SAP GP SAP TRM
Datenanalyse System Integration Prozessanalyse DataVault2.o Datenqualitätsmanagement
industry: finance
4 Monate
2014-05 - 2014-08

Implementation of ETL Processes: Migration of OWB into ODI mappings

Analyse / Entwicklung / Testen / Dokumentation ETL
Analyse / Entwicklung / Testen / Dokumentation

Flatfile and database load into stage with ODI Integration of ODI Knowledge modules

Oracle Data Integrator Oracle Warehouse Builder Oracle 11 Redmine SVN
ETL
industry: waist disposal and recycling
2 Jahre 5 Monate
2011-11 - 2014-03

Renewal of the IT base system: SAP (CML and GP), Subproject: Implementation Risk Datamart

Analyse / Konzeption / Implementierung / Testen Datenmigration Datenbankdesign
Analyse / Konzeption / Implementierung / Testen

Implementation of the Risk Management DataWarehouse

Migration of historical data into new Datamart (with goLive responsibility)

Oracle 11g Oracle Warehouse Builder Atlassian JIRA
Datenmigration Datenbankdesign
industry: finance
3 Monate
2011-08 - 2011-10

Enhancements to Frequent Flyer DWH

Entwicklung / Testen TSQL
Entwicklung / Testen

Implementation and Testing of a loading chain for DataWarehouse

Teradata 13 SVN
TSQL
industry: aviation
5 Monate
2011-06 - 2011-10

Teradata Systems Hardening

Entwicklung / Testen / Dokumentation ITIL
Entwicklung / Testen / Dokumentation

Requirements Engineering, Concept and Implementation of (ITIL-) Configuration Management for Teradata Servers

Teradata 12 Teradata 13 Perl Bash Shell
ITIL
industry: telecommunication
3 Monate
2011-02 - 2011-04

Change Request for the Risk Management Data Warehouse

Entwicklung / Testen
Entwicklung / Testen

Change Request 'Calculation of covered an noncovered credit §19 KWG', Implemented using cascading views and PL/SQL

Oracle 10g Toad for Oracle SVN

Aus- und Weiterbildung

Aus- und Weiterbildung

Diplom- Wirtschaftsinformatiker (TU)

 

Certified Oracle DataIntegrator Developer ( ODI 12c )

Certified Oracle Warehousebuilder Developer ( OWB 10 und OWB 11)

Certified Oracle XMLDB Developer

SAP R/3 HealthCare

Kompetenzen

Kompetenzen

Aufgabenbereiche

Change Management
Datenbankdesign
Datenbankentwicklung
Datenqualitätsmanagement
System Integration
Testcoordination
Testdesign

Produkte / Standards / Erfahrungen / Methoden

Anwender-Support
Anwendungsbetreuung
Anwendungsbetrieb
Anwendungsdesign
Atlassian Confluence
Atlassian JIRA
DataVault2.o
Datenanalyse
Datenmigration
Datenqualitätsmanagement
DevOps
Elk-Stack
Elastiqsearch, Kibana, Grafana
Git
ITIL
Oracle Data Integrator
Oracle SQL Developer
Oracle Warehouse Builder
Prozessanalyse
Redmine
Redmine
SAP Business Objects
SAP CML
SAP GP
SAP TRM
SVN
System Integration
Toad for Oracle
UC4

Betriebssysteme

Debian
Solaris 10
Ubuntu
Windows
desktop

Programmiersprachen

JavaScript
ES2015,ES2016...
nodejs
Perl
Pg/SQL
PL/SQL
Shell
bash, sh, ash,ksh...
TSQL
Vue

Datenbanken

DataVault 2.0
Datenbankdesign
ETL
Oracle 10g
Oracle 11
Oracle 11g
Oracle 12c
Oracle SQL Developer
Oracle12c
Pg/SQL
PostgreSQL
Star Schema
Teradata 12
Teradata 13
Teradata 16
TSQL

Datenkommunikation

Internet, Intranet
TCP/IP

Design / Entwicklung / Konstruktion

Konzeption / Implementierung von Data Warehouses

Star & Snowflake, DataVault

ETL

Database Version Management

Version Management (SVN, GIT)

Branchen

Branchen

Financial Services

Banking

Telecommunication

Einsatzorte

Einsatzorte

Österreich, Schweiz, Deutschland

Deutschland bevorzugt, gerne auch Projekte im Ausland, sofern Projektsprache Englisch

nicht möglich

Projekte

Projekte

9 Monate
2019-02 - 2019-10

Implementation of a Datalandscape for Digitalisation- Requirements

Entwicklung und Test PL/SQL DataVault 2.0 Star Schema ...
Entwicklung und Test

Migration of existing DataMarts into a consolidated DataVault2.o landscape

Development of needed ETL components for dataload from Source – DataVault – Star - DataMart

testing and documentation

Oracle12c Oracle SQL Developer Atlassian Confluence Atlassian JIRA Oracle Data Integrator
PL/SQL DataVault 2.0 Star Schema ETL
industry: Finance
10 Monate
2018-03 - 2018-12

Application Management and Application Development: Antragsdatamart (ADM) for Internal and Regulatory Reporting

Konzeption / Entwicklung / Testen / Dokumentation Datenanalyse Datenmigration Datenbankdesign ...
Konzeption / Entwicklung / Testen / Dokumentation

Testing for Migration from Oracle 11 to Oracle 12

Application Architecture for a Contract Database for Budgeting of received EU/Sax fundings

Implementation of new functionality / enhancements to the application (ADM), testing and documentation

Oracle 11g Oracle 12c Oracle SQL Developer Toad for Oracle Atlassian JIRA
Datenanalyse Datenmigration Datenbankdesign Anwendungsdesign Anwendungsbetrieb Testdesign
industry: Finance
7 Monate
2017-07 - 2018-01

Application Management: Enterprise Datawarehouse (EDWH)

Anwendungsbetreuung Anwender-Support Anwendungsbetreuung ETL ...
Anwendungsbetreuung

Monitoring and management of EDWH monthly load cycle

coordination with EDWH technical services

Incident and issue management for EDWH

Coordination and management of test cycles for group datawarehouse releases to assure EDWH compliance

Oracle 12c Terradata 16 Oracle Data Integrator UC4 Atlassian JIRA Atlassian Confluence
Anwender-Support Anwendungsbetreuung ETL Anwendungsbetrieb DevOps test coordination
industry: Finance
3 Monate
2017-04 - 2017-06

Migration of JAVA application stack's logic layer to PostgreSQL

Analyse / Design / Implementation / Testen / Dokumentation / Anwendungsdesign Datenbankdesign
Analyse / Design / Implementation / Testen / Dokumentation /

analysis of existing java application

adaption and revision of logic

implementation and testing

documentation

JAVA PostgreSQL Atlassian JIRA SVN Pg/SQL
Anwendungsdesign Datenbankdesign
industry: automotive supply
2 Jahre 5 Monate
2014-09 - 2017-01

Implementation of BI Infrastructures Data Layer Data Definition and Data Modelling into DataVault

Analyse / Konzeption / Implementierung Datenanalyse System Integration Prozessanalyse ...
Analyse / Konzeption / Implementierung

Prototyp of ETL processes in ODI and OWB

Implementation of Data Quality definitions

Concept of an Integrated Data Layer

System architecture / design for integrating current data, reporting and processual demands into BI infrastructures

Data Layer

Processual and functional analysis of existing IT Reporting Infrastructure components – datamarts and further data sources / consumers focussing on integrational aspects

SAP Business Objects Oracle 11g Atlassian JIRA SAP CML SAP GP SAP TRM
Datenanalyse System Integration Prozessanalyse DataVault2.o Datenqualitätsmanagement
industry: finance
4 Monate
2014-05 - 2014-08

Implementation of ETL Processes: Migration of OWB into ODI mappings

Analyse / Entwicklung / Testen / Dokumentation ETL
Analyse / Entwicklung / Testen / Dokumentation

Flatfile and database load into stage with ODI Integration of ODI Knowledge modules

Oracle Data Integrator Oracle Warehouse Builder Oracle 11 Redmine SVN
ETL
industry: waist disposal and recycling
2 Jahre 5 Monate
2011-11 - 2014-03

Renewal of the IT base system: SAP (CML and GP), Subproject: Implementation Risk Datamart

Analyse / Konzeption / Implementierung / Testen Datenmigration Datenbankdesign
Analyse / Konzeption / Implementierung / Testen

Implementation of the Risk Management DataWarehouse

Migration of historical data into new Datamart (with goLive responsibility)

Oracle 11g Oracle Warehouse Builder Atlassian JIRA
Datenmigration Datenbankdesign
industry: finance
3 Monate
2011-08 - 2011-10

Enhancements to Frequent Flyer DWH

Entwicklung / Testen TSQL
Entwicklung / Testen

Implementation and Testing of a loading chain for DataWarehouse

Teradata 13 SVN
TSQL
industry: aviation
5 Monate
2011-06 - 2011-10

Teradata Systems Hardening

Entwicklung / Testen / Dokumentation ITIL
Entwicklung / Testen / Dokumentation

Requirements Engineering, Concept and Implementation of (ITIL-) Configuration Management for Teradata Servers

Teradata 12 Teradata 13 Perl Bash Shell
ITIL
industry: telecommunication
3 Monate
2011-02 - 2011-04

Change Request for the Risk Management Data Warehouse

Entwicklung / Testen
Entwicklung / Testen

Change Request 'Calculation of covered an noncovered credit §19 KWG', Implemented using cascading views and PL/SQL

Oracle 10g Toad for Oracle SVN

Aus- und Weiterbildung

Aus- und Weiterbildung

Diplom- Wirtschaftsinformatiker (TU)

 

Certified Oracle DataIntegrator Developer ( ODI 12c )

Certified Oracle Warehousebuilder Developer ( OWB 10 und OWB 11)

Certified Oracle XMLDB Developer

SAP R/3 HealthCare

Kompetenzen

Kompetenzen

Aufgabenbereiche

Change Management
Datenbankdesign
Datenbankentwicklung
Datenqualitätsmanagement
System Integration
Testcoordination
Testdesign

Produkte / Standards / Erfahrungen / Methoden

Anwender-Support
Anwendungsbetreuung
Anwendungsbetrieb
Anwendungsdesign
Atlassian Confluence
Atlassian JIRA
DataVault2.o
Datenanalyse
Datenmigration
Datenqualitätsmanagement
DevOps
Elk-Stack
Elastiqsearch, Kibana, Grafana
Git
ITIL
Oracle Data Integrator
Oracle SQL Developer
Oracle Warehouse Builder
Prozessanalyse
Redmine
Redmine
SAP Business Objects
SAP CML
SAP GP
SAP TRM
SVN
System Integration
Toad for Oracle
UC4

Betriebssysteme

Debian
Solaris 10
Ubuntu
Windows
desktop

Programmiersprachen

JavaScript
ES2015,ES2016...
nodejs
Perl
Pg/SQL
PL/SQL
Shell
bash, sh, ash,ksh...
TSQL
Vue

Datenbanken

DataVault 2.0
Datenbankdesign
ETL
Oracle 10g
Oracle 11
Oracle 11g
Oracle 12c
Oracle SQL Developer
Oracle12c
Pg/SQL
PostgreSQL
Star Schema
Teradata 12
Teradata 13
Teradata 16
TSQL

Datenkommunikation

Internet, Intranet
TCP/IP

Design / Entwicklung / Konstruktion

Konzeption / Implementierung von Data Warehouses

Star & Snowflake, DataVault

ETL

Database Version Management

Version Management (SVN, GIT)

Branchen

Branchen

Financial Services

Banking

Telecommunication

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.