Profilbild von Emrah Kocak Senior Data Engineer, Business Intelligence Architect, Senior Data Warehouse Developer aus Muenchen

Emrah Kocak


Letztes Update: 16.05.2023

Senior Data Engineer, Business Intelligence Architect, Senior Data Warehouse Developer

Abschluss: B. Sc. Computer Engineering
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Grundkenntnisse) | englisch (gut)


Information Engineering Data Warehousing Business Intelligence ETL Datenbank Design Performance-Tuning




Data Warehousing
Database Design
ETL Development
Data Engineering
Performance Optimization
​Problem Solving


07/2022 - 02/2023
Senior Data Engineer
CyberSolutions GmbH
CyberSolutions GmbH
* Working as a Senior Data Engineer in BI team.
* Migrating existing ETL jobs from Talend to Data Virtuality.
* Modeling the database and setting up the business rules on Data Vault Builder.
* Responsible for the deployments.

01/2019 - 11/2022
Senior Data Engineer
* Worked as a Senior Data Engineer for Marketing Intelligence and CRM teams.
* Lead the maintenance and improvement activities of the ETL workflows on Pentaho Data
Integration Tool 8.1.
* Was responsible for the maintenance of the database of CRM&MI Datamart on SQL Server
* Managed the external integrations with the leading companies in the market.

Lead the Datamart Re-platforming project:
* Design and implementation of a new model (Dimensional Model) and ETL Workflows.
* ETL Tool selection process.
* Improvement the data quality of the Datamart.
* Separation of the Production and Development environments.
* Building a deployment mechanism from Dev to Prod environments.

01/2018 - 04/2019
Business Intelligence Architect
Volvo Group
Volvo Group - Poland
* Was responsible for 2 domains in DW.
* Main tasks are working as a guide for the developers, gathering the change request from
the business departments and applying them in the DW.
* Preparing the architectural documents for the projects.
* Design and maintenance the database model of the domains.
* Development of ETL packages.

01/2017 - 09/2018
Senior Data Warehouse Developer
Volvo Group
Volvo Group - Poland
* As a senior data warehouse developer, worked on EDW Migration from Oracle to Netezza
by using Informatica Power Center 10.1.1
* Main tasks were making the developments, unit tests, integration tests and promotions of
the ETL packages fitting with needs of new environment.

01/2012 - 12/2017
Senior Data Warehouse Developer
Yapı Kredi Bank / Uni Credit
Yapı Kredi Bank / Uni Credit - Turkey
* As a senior data warehouse developer, worked on Oracle 11g, 12c and one of the largest
Sybase IQ databases (~120 TB) in the World.
* Main tasks were ETL development, maintenance of the data model and daily refresh, data
consistency, data quality and data cleansing. ETL development on Informatica Power
Center, stored procedures, Unix Shell scripts and SSIS. Performance improvement works
on long running ETL jobs.
DW Modernization Project
* Started at the beginning of 2016 and planned for 3 years. It is a transformation project of
the data warehouse. A new DW model is being implemented on Oracle 12c. All ETL
processes are being developed on Informatica Power Center 9.6.1
* Lead 3 subject areas. Main tasks are coordinating the team, ETL development,
deployment, performance tuning, job scheduling and test data management.
* Had administrator role on Informatica Power Center and Informatica Analyst tools.

01/2011 - 10/2012
Senior Data Warehouse Developer
Garanti Factoring
Garanti Factoring - Turkey
* Acted as a senior data warehouse developer on a data warehouse platform in SQL Server
* Was responsible for all the process in the DW team, including requirement analysis, source
system analysis, source to target mappings, ETL developments on SSIS, creating reports on
SSRS, ASP.NET and Excel, unit tests, funcctional test, user acceptance tests, ETL scheduling
and maintenance, SQL Server database administration and Windows Server
* Made a mark by reducing the completion time of daily refreshes and making them stable
by solving the problems of all cronic problems.
* Automated all manual reports by using Excel and ASP.NET.

01/2010 - 06/2011
Data Warehouse Analyst
Turk Telekom
Turk Telekom - Turkey
* Acted as a junior DW Analyst at Turk Telekom which is the first integrated Telco Company
in Turkey.
* Was responsible for the source system analysis, database modeling, source to target
mappings, unit and functional tests.
* Built a data dictionary on Powerdesigner

01/2008 - 10/2009
Integration Specialist
Turk Telekom
Turk Telekom - Turkey
* As a junior MW developer was a member of the team which was responsible for the
management of the integration between all the system.
* Implemented the integration of Law and Collection systems by using Oracle SOA Suite

01/2007 - 09/2008
Savronik - Turkey
* Acted as a part time developer at Savronik, an electronics company on natianal defense
* Develeopment and maintenance of the Door Access Control System of the company.


In der Stadt München mit einem Radius von 250 km verfügbar
Profilbild von Emrah Kocak Senior Data Engineer, Business Intelligence Architect, Senior Data Warehouse Developer aus Muenchen Senior Data Engineer, Business Intelligence Architect, Senior Data Warehouse Developer