Data Integration - ETL - Informatica - Talend Senior Developer

TOURISM
DEVELOPMENT OF A DATA PLATTFORM
STANDORT: COLOGNE

* Construction and further development of a data warehouse with connection of heterogeneous data
* Partial project management for integration of financial data and data warehouse structures in
an Amazon AWS environment
* Migration of data and Informatica processes from a Sybase IQ database to an Exasol database
* Updating Control M and various Informatica versions
* In-house training for analysts on data structures and optimization of SQL queries
* Continuous development of the data model
* Controlling internal and external project participants

* Systems and applications: Powercenter, BMC Control M, Sybase IQ, Exasol, Confluence, SVN

Role: Sub-project manager, developer

FINANCE/STOCK EXCHANGE
DEVELOPMENT OF A FINANCE DATA WAREHOUSE
LOCATION: STUTTGART

* Continuous further development of the connection of a trading system to a data warehouse
* Support of business reporting
* Development of regulatory processes for regulatory exchange Development of a near-time layer
to enable intraday reporting and to be able to react to changes at short notice
* Extension of the data model
* Optimization of existing job routes
* Integration of unstructured data feeds to integrate financial data

* Systems and applications: Informatica Powercenter, Oracle , Toad for Oracle, Jira, BMC Control
M, UC4

Role: Consultant, Developer

AUTOMOTIVE
DEVELOPMENT AND OPERATION OF A CRM SYSTEM
LOCATION: STUTTGART

* Development and operation of a CRM system to integrate heterogeneous source data to support
the marketing department in generating potential customers
* Development of a dealer system to refer potential customers to local dealers
* Support and training of the marketing department to optimize reporting
* Close communication with the client to react promptly to new market developments
* Consolidation of data to increase data quality
* Development of regulatory processes
* Development of semi-automated deployment processes

* Systems and applications: Informatica Powercenter, Oracle, Toad for Oracle, BMC Control M,
Javascript

Role: Consultant, Developer