Entwicklung/Architektur Data Integration mit Informatica PowerCenter, XML-Verarb./unstrukturierte Daten mit Informatica B2B DT (DataTransformation)
Aktualisiert am 31.08.2021
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.09.2021
Verfügbar zu: 100%
davon vor Ort: 100%
InformaticaPowerCenter
InformaticaDataTransformation(XML)
BMC Control-M
MSSQL
Atlassian JIRA
Deutsch
Muttersprache
Englisch
fließend

Einsatzorte

Einsatzorte

Zürich (+100km)
Schweiz
nicht möglich

Projekte

Projekte

11 Monate
2018-05 - 2019-03

Enhancing the existing data warehouse

ETL developer Scrum PL/SQL
ETL developer

Activities:

  • Desinging and creating load processes or enhancements
  • Production support
  • Creating quality checks
  • Integration into batch processes
  • Instructing new team members
IBM InfoSphere DataStage SparxSystems Enterprise Architect Arvato streamworks QuerySurge
Scrum PL/SQL
Bern
3 Jahre 4 Monate
2014-11 - 2018-02

Introducing Informatica B2B DT for complex XML processing

B2B DT (Data Transformation) expert/developer
B2B DT (Data Transformation) expert/developer

Activities:

  • Administration support
  • Developer support
  • Development to process Way4 interfaces, PinMailer, CardProduction, Letters, Statements
  • Cooperation with Credit Card manufacturer Gemalto (formerly Trüb)
  • Cooperation with SPS (Swiss Post Solutions)
Informatica PowerCenter Oracle XML Informatica B2B DT
UBS Card Center AG, Zürich, Switzerland
8 Monate
2014-04 - 2014-11

Arvato was setting up Informatica PIM (product information management) for his customer Gerry Weber to control the Gerry Weber internet shop. Due to the acquisition of its vendor Heiler Software by Informatica, a quality tool was missing

Developer
Developer

Project description:
Arvato was setting up Informatica PIM (product information management) for his customer Gerry Weber to control the Gerry Weber internet shop. Due to the acquisition of its vendor Heiler Software by Informatica, a quality tool was missing (formerly an integrated third party tool). This gap was filled by a B2B DT service providing a validation module

Activities:

  • Installation and configuration of Informatica PowerCenter and B2B DT
  • Analyse the high level requirements
  • Developing several B2B DT services
  • Instructing the developer team
Informatica PowerCenter Oracle XML
Arvato, München
1 Jahr 3 Monate
2013-02 - 2014-04

Re-design of the existing "Teflos" system to extract check-in details for complex data analysis

Developer
Developer

Activities:

  • Installation and configuration of Informatica B2B DT
  • Developing several B2B DT Services of mid-complexity
  • Business analysis support
  • Instructing the developer team
Informatica PowerCenter Oracle XML
Lufthansa Revenue Services, Norderstedt
6 Monate
2012-10 - 2013-03

In order to send risk metrics to external provider MSCI Inc. to perform extended risk management calculations, data had to be extracted out of Oracle and to be converted into XML format according to the provider's XML structure

architect/administrator/developer
architect/administrator/developer

Activities:

  • Installation and configuration of Informatica B2B DT (PowerCenter was in place for several years9
  • Developing a complex B2B DT Service to convert risk metrics data from relational model (DB) to XML
  • Handover and instruction of the developer team
Informatica PowerCenter Oracle XML
Dekabank, Frankfurt/Main
6 Monate
2012-04 - 2012-09

Complex business rules, that could not be applied to SAP system directly, had to be applied to the data by bypassing the datastream to a system of PowerCenter mappings and re-inserting them again

developer
developer

Activities:

  • Extracting data out of SAP tables, applying complex business logic, mostly to enrich and to aggregate the existing data
Informatica PowerCenter Oracle
DZ Bank, Frankfurt/Main
6 Monate
2011-10 - 2012-03

This project was an initiative to introduce Informatica PowerCenter, B2B DT (DataTransformation) and B2B DX (DataExchange) to the global wholesale department

Developer
Developer

Activities:

  • Installation and configuration of the Informatica platform on 4 environments
  • Creating concepts of administration (user privileges, administration of PowerCenter objects, deployment)
  • Instructing the developer team (onsite and remote)
Oracle XML Informatica PowerCenter
ADIDAS, Herzogenaurach
9 Monate
2011-01 - 2011-09

The gCRM project (global customer relationship management) is designed receive customer data from multiple online platforms (daily updates via XML) in order to find the ?golden? version and to provide the clean data for customer advertising campaigns.

architect/administrator
architect/administrator

Activities:

  • Creating the all-over MDM data model
  • Configuring the MDM hub server
    • Cleansing rules
    • Match rules
  • Creating the PowerCenter workflows to process XML files provided by the source systems daily
  • Creating the PowerCenter workflows to provide updates backwards to all source systems
Oracle XML
Panasonic, Hamburg
1 Jahr 3 Monate
2009-11 - 2011-01

The GPL (Global Payment Link) project is about receiving and sending payments, payment format conversion with Informatica B2B DT (DataTransformation)

Developer
Developer

Messages are received in the formats AIR, BACS, ISO8583, MT103, MT202, NewBankline, PACS004, PACS008 plus the relevant PAN’s (Payment Advices) and PSN’s (Payment Status Notifications) and are being processed and converted by Informatica B2B DT (Data Transformation) into the formats BAI2, MT940, MT942, NewBankline, BFF, MT198, MT900, MT910, MT198, MT298 and PACS002 transformiert.

Activities:

  • Implementing DT services according to mapping rule documents
  • Testing the services and adapting them to the specific requirements
  • Instructing analysts how to use Informatica B2B DT studio as a validation tool
  • Documentation of the developed services and test approval
Informatica PowerCenter B2B XML Oracle
Royal Bank of Scotland, London
7 Monate
2009-04 - 2009-10

Assisting to build a best practices package for automated deployment of PowerCenter objects.

Developer
Developer

Activities:

  • Support at designing and building the installer
  • Test execution
  • Documentation
  • Installation
  • Training (enablement)
Oracle XML
PowerFramework (Deployment Framework)
2 Monate
2009-02 - 2009-03

Statistix project was created to analyze SWIFT messages

Developer
Developer

Project description:
Statistix project was created to analyze SWIFT messages. Bond-related Clearstream messages MT564 and MT566 transmitted by Merva are transformed using Informatica B2B DT, subsequent processing using Informatica PowerCenter establishes relations between events to monitor in due time dispatch of correspondent messages.

Activities:

  • Review of requests and existing process implemantations
  • Design and implementation of subsequent aggregation levels
  • Mentoring ETL developers
  • Documentation of the entire development and test approval
Oracle XML
Deutsche Börse AG, Frankfurt
3 Monate
2008-10 - 2008-12

Purchase Data Warehouse was created to collect business transactions out of STAR system (previously GAS system) to display real savings in order to calculate bonuses

Developer
Developer

Activities:

  • Enhancement of existing workflows of STAR system using PowerCenter 7 (later PowerCenter 8).
  • Mapping design following mapping instructions of medium complexity.
  • Mapping design implementing functional requests by the project leader
  • Performance tuning and consolidating existing mappings
  • Quality assurance, trouble shooting, bugfixing
Oracle MS SQL Server
Volkswagen AG, Wolfsburg
1 Jahr 3 Monate
2007-07 - 2008-09

Consulting at implementation of Book-of-Standards compliant technology, at most points including the implementation, participation at establishing a further so called ?Gravitationzentrum? (internal name for a specialized Data Warehouse), the ?Sales GZ?

Developer
Developer

Activities:

  • Prototype design, mostly later unmodified used for production.
  • Project KometPro (currently KKP): Mapping design following mapping requests
  • Project Berichtswesen Deutschland (reporting system for Germany): Migration of ETL processes existing in C# to Informatica PowerCenter technology and integration into SalesGZ; mapping design following pseudo SQL, partly redesigned processes
  • Projects Konzernvertriebspartnerstammdaten (KVPS, enterprise distribution partner master data) , Masterdata Management (MDM) und Work Atmosphere: Mapping design following requests
Oracle MS SQL Server DB/2
Volkswagen AG, Wolfsburg
3 Monate
2007-04 - 2007-06

Purchase Data Warehouse was created to collect business transactions out of STAR system (previously GAS system) to display real savings in order to calculate bonuses

Developer
Developer

Activities:

  • Enhancement of existing workflows of STAR system using PowerCenter 7 (later PowerCenter 8).
  • Mapping design following mapping instructions of medium complexity.
  • Mapping design implementing functional requests by the project leader
  • Performance tuning and consolidating existing mappings
  • Quality assurance, trouble shooting, bugfixing
Oracle MS SQL Server
Volkswagen AG, Wolfsburg

Aus- und Weiterbildung

Aus- und Weiterbildung

09.1987 - 01.1991: Professional education to Radio- und Fernsehtechniker (radio and television technican) at Rat und Tat GmbH (Karstadt AG) in Braunschweig

Since 2000: Seminars/training:

  • Networking
  • Programming (VB6, Java, C#, JavaScript)
  • Database administration and development (Oracle, MS SQL Server)
  • Informatica PowerCenter
  • Informatica MDM
  • Informatica B2B DT (Silver Certification)

Position

Position

Senior Consultant Informatica Specialist

Kompetenzen

Kompetenzen

Top-Skills

InformaticaPowerCenter InformaticaDataTransformation(XML) BMC Control-M MSSQL Atlassian JIRA

Aufgabenbereiche

Deployment
very good
Konfigurationsmanagement
good
Konzeption: Realisierung
good
Konzeption: Techn. Architektur
good
Release-Management
good
Schulung / Coaching / Präsentation
very good
Testen, Debugging, Tuning
very good

Produkte / Standards / Erfahrungen / Methoden

Informatica B2B DT
very good
Informatica B2B DX
basic
Informatica MDM
basic
Informatica PowerCenter
very good
Scrum
XML
very good

Betriebssysteme

Linux
Windows

Programmiersprachen

C/C++/C#
Java
PL/SQL
Shell-Script
VBA
Visual Basic

Datenbanken

DB/2
good
MS SQL Server
good
Oracle
very good

Datenkommunikation

Arvato streamworks

Berechnung / Simulation / Versuch / Validierung

QuerySurge

Design / Entwicklung / Konstruktion

IBM InfoSphere DataStage
SparxSystems Enterprise Architect

Branchen

Branchen

  • Financial industry
  • Clothing industry
  • Transportation industry
  • Financial service provider
  • Sports industry
  • Entertainment technology
  • Automotive industry

Einsatzorte

Einsatzorte

Zürich (+100km)
Schweiz
nicht möglich

Projekte

Projekte

11 Monate
2018-05 - 2019-03

Enhancing the existing data warehouse

ETL developer Scrum PL/SQL
ETL developer

Activities:

  • Desinging and creating load processes or enhancements
  • Production support
  • Creating quality checks
  • Integration into batch processes
  • Instructing new team members
IBM InfoSphere DataStage SparxSystems Enterprise Architect Arvato streamworks QuerySurge
Scrum PL/SQL
Bern
3 Jahre 4 Monate
2014-11 - 2018-02

Introducing Informatica B2B DT for complex XML processing

B2B DT (Data Transformation) expert/developer
B2B DT (Data Transformation) expert/developer

Activities:

  • Administration support
  • Developer support
  • Development to process Way4 interfaces, PinMailer, CardProduction, Letters, Statements
  • Cooperation with Credit Card manufacturer Gemalto (formerly Trüb)
  • Cooperation with SPS (Swiss Post Solutions)
Informatica PowerCenter Oracle XML Informatica B2B DT
UBS Card Center AG, Zürich, Switzerland
8 Monate
2014-04 - 2014-11

Arvato was setting up Informatica PIM (product information management) for his customer Gerry Weber to control the Gerry Weber internet shop. Due to the acquisition of its vendor Heiler Software by Informatica, a quality tool was missing

Developer
Developer

Project description:
Arvato was setting up Informatica PIM (product information management) for his customer Gerry Weber to control the Gerry Weber internet shop. Due to the acquisition of its vendor Heiler Software by Informatica, a quality tool was missing (formerly an integrated third party tool). This gap was filled by a B2B DT service providing a validation module

Activities:

  • Installation and configuration of Informatica PowerCenter and B2B DT
  • Analyse the high level requirements
  • Developing several B2B DT services
  • Instructing the developer team
Informatica PowerCenter Oracle XML
Arvato, München
1 Jahr 3 Monate
2013-02 - 2014-04

Re-design of the existing "Teflos" system to extract check-in details for complex data analysis

Developer
Developer

Activities:

  • Installation and configuration of Informatica B2B DT
  • Developing several B2B DT Services of mid-complexity
  • Business analysis support
  • Instructing the developer team
Informatica PowerCenter Oracle XML
Lufthansa Revenue Services, Norderstedt
6 Monate
2012-10 - 2013-03

In order to send risk metrics to external provider MSCI Inc. to perform extended risk management calculations, data had to be extracted out of Oracle and to be converted into XML format according to the provider's XML structure

architect/administrator/developer
architect/administrator/developer

Activities:

  • Installation and configuration of Informatica B2B DT (PowerCenter was in place for several years9
  • Developing a complex B2B DT Service to convert risk metrics data from relational model (DB) to XML
  • Handover and instruction of the developer team
Informatica PowerCenter Oracle XML
Dekabank, Frankfurt/Main
6 Monate
2012-04 - 2012-09

Complex business rules, that could not be applied to SAP system directly, had to be applied to the data by bypassing the datastream to a system of PowerCenter mappings and re-inserting them again

developer
developer

Activities:

  • Extracting data out of SAP tables, applying complex business logic, mostly to enrich and to aggregate the existing data
Informatica PowerCenter Oracle
DZ Bank, Frankfurt/Main
6 Monate
2011-10 - 2012-03

This project was an initiative to introduce Informatica PowerCenter, B2B DT (DataTransformation) and B2B DX (DataExchange) to the global wholesale department

Developer
Developer

Activities:

  • Installation and configuration of the Informatica platform on 4 environments
  • Creating concepts of administration (user privileges, administration of PowerCenter objects, deployment)
  • Instructing the developer team (onsite and remote)
Oracle XML Informatica PowerCenter
ADIDAS, Herzogenaurach
9 Monate
2011-01 - 2011-09

The gCRM project (global customer relationship management) is designed receive customer data from multiple online platforms (daily updates via XML) in order to find the ?golden? version and to provide the clean data for customer advertising campaigns.

architect/administrator
architect/administrator

Activities:

  • Creating the all-over MDM data model
  • Configuring the MDM hub server
    • Cleansing rules
    • Match rules
  • Creating the PowerCenter workflows to process XML files provided by the source systems daily
  • Creating the PowerCenter workflows to provide updates backwards to all source systems
Oracle XML
Panasonic, Hamburg
1 Jahr 3 Monate
2009-11 - 2011-01

The GPL (Global Payment Link) project is about receiving and sending payments, payment format conversion with Informatica B2B DT (DataTransformation)

Developer
Developer

Messages are received in the formats AIR, BACS, ISO8583, MT103, MT202, NewBankline, PACS004, PACS008 plus the relevant PAN’s (Payment Advices) and PSN’s (Payment Status Notifications) and are being processed and converted by Informatica B2B DT (Data Transformation) into the formats BAI2, MT940, MT942, NewBankline, BFF, MT198, MT900, MT910, MT198, MT298 and PACS002 transformiert.

Activities:

  • Implementing DT services according to mapping rule documents
  • Testing the services and adapting them to the specific requirements
  • Instructing analysts how to use Informatica B2B DT studio as a validation tool
  • Documentation of the developed services and test approval
Informatica PowerCenter B2B XML Oracle
Royal Bank of Scotland, London
7 Monate
2009-04 - 2009-10

Assisting to build a best practices package for automated deployment of PowerCenter objects.

Developer
Developer

Activities:

  • Support at designing and building the installer
  • Test execution
  • Documentation
  • Installation
  • Training (enablement)
Oracle XML
PowerFramework (Deployment Framework)
2 Monate
2009-02 - 2009-03

Statistix project was created to analyze SWIFT messages

Developer
Developer

Project description:
Statistix project was created to analyze SWIFT messages. Bond-related Clearstream messages MT564 and MT566 transmitted by Merva are transformed using Informatica B2B DT, subsequent processing using Informatica PowerCenter establishes relations between events to monitor in due time dispatch of correspondent messages.

Activities:

  • Review of requests and existing process implemantations
  • Design and implementation of subsequent aggregation levels
  • Mentoring ETL developers
  • Documentation of the entire development and test approval
Oracle XML
Deutsche Börse AG, Frankfurt
3 Monate
2008-10 - 2008-12

Purchase Data Warehouse was created to collect business transactions out of STAR system (previously GAS system) to display real savings in order to calculate bonuses

Developer
Developer

Activities:

  • Enhancement of existing workflows of STAR system using PowerCenter 7 (later PowerCenter 8).
  • Mapping design following mapping instructions of medium complexity.
  • Mapping design implementing functional requests by the project leader
  • Performance tuning and consolidating existing mappings
  • Quality assurance, trouble shooting, bugfixing
Oracle MS SQL Server
Volkswagen AG, Wolfsburg
1 Jahr 3 Monate
2007-07 - 2008-09

Consulting at implementation of Book-of-Standards compliant technology, at most points including the implementation, participation at establishing a further so called ?Gravitationzentrum? (internal name for a specialized Data Warehouse), the ?Sales GZ?

Developer
Developer

Activities:

  • Prototype design, mostly later unmodified used for production.
  • Project KometPro (currently KKP): Mapping design following mapping requests
  • Project Berichtswesen Deutschland (reporting system for Germany): Migration of ETL processes existing in C# to Informatica PowerCenter technology and integration into SalesGZ; mapping design following pseudo SQL, partly redesigned processes
  • Projects Konzernvertriebspartnerstammdaten (KVPS, enterprise distribution partner master data) , Masterdata Management (MDM) und Work Atmosphere: Mapping design following requests
Oracle MS SQL Server DB/2
Volkswagen AG, Wolfsburg
3 Monate
2007-04 - 2007-06

Purchase Data Warehouse was created to collect business transactions out of STAR system (previously GAS system) to display real savings in order to calculate bonuses

Developer
Developer

Activities:

  • Enhancement of existing workflows of STAR system using PowerCenter 7 (later PowerCenter 8).
  • Mapping design following mapping instructions of medium complexity.
  • Mapping design implementing functional requests by the project leader
  • Performance tuning and consolidating existing mappings
  • Quality assurance, trouble shooting, bugfixing
Oracle MS SQL Server
Volkswagen AG, Wolfsburg

Aus- und Weiterbildung

Aus- und Weiterbildung

09.1987 - 01.1991: Professional education to Radio- und Fernsehtechniker (radio and television technican) at Rat und Tat GmbH (Karstadt AG) in Braunschweig

Since 2000: Seminars/training:

  • Networking
  • Programming (VB6, Java, C#, JavaScript)
  • Database administration and development (Oracle, MS SQL Server)
  • Informatica PowerCenter
  • Informatica MDM
  • Informatica B2B DT (Silver Certification)

Position

Position

Senior Consultant Informatica Specialist

Kompetenzen

Kompetenzen

Top-Skills

InformaticaPowerCenter InformaticaDataTransformation(XML) BMC Control-M MSSQL Atlassian JIRA

Aufgabenbereiche

Deployment
very good
Konfigurationsmanagement
good
Konzeption: Realisierung
good
Konzeption: Techn. Architektur
good
Release-Management
good
Schulung / Coaching / Präsentation
very good
Testen, Debugging, Tuning
very good

Produkte / Standards / Erfahrungen / Methoden

Informatica B2B DT
very good
Informatica B2B DX
basic
Informatica MDM
basic
Informatica PowerCenter
very good
Scrum
XML
very good

Betriebssysteme

Linux
Windows

Programmiersprachen

C/C++/C#
Java
PL/SQL
Shell-Script
VBA
Visual Basic

Datenbanken

DB/2
good
MS SQL Server
good
Oracle
very good

Datenkommunikation

Arvato streamworks

Berechnung / Simulation / Versuch / Validierung

QuerySurge

Design / Entwicklung / Konstruktion

IBM InfoSphere DataStage
SparxSystems Enterprise Architect

Branchen

Branchen

  • Financial industry
  • Clothing industry
  • Transportation industry
  • Financial service provider
  • Sports industry
  • Entertainment technology
  • Automotive industry

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.