AB
verfügbar

Letztes Update: 06.09.2022

ETL Senior Developer, Snowflake, Informatica, Ab inito, Airflow, Teradata, Oracle

Abschluss: nicht angegeben
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: dänisch (gut) | deutsch (verhandlungssicher) | englisch (verhandlungssicher) | russisch (Muttersprache)

Skills

Hadoop Apache, Spark/Python, Teradata, MS-SQL, Oracle RDBMS, different ETL tools, Oracle, Integrator, SSIS, Informatica Power Center, Business Object Data Integrator, CRM, TRM, MicroStrategy, OBIEE, MSBI, Data Warehouse architecture, Business Intelligence, OLAP, Logical Data Modeling (Telco and Finance, Modeling, Dimensional Modeling design, Big Data technology, coding for data analysis, ETL, Python, SQL, Teradata database platforms, Cloud based Data Warehouse solution - Snowflake, Data Modeling, SQL programming, PL-SQL programming, ETL-tools, Oracle Data Integrator, Objects, Power BI, SQL Server BI, DWH, Dimensional Model implementation, Data Science, Data Pipeline, DataBase, Postgres, PostGIS, Azure Cloud Infrastructure, Docker, Kubernetes, Airflow, Argo, Postman, JIRA, large data, Oracle Database, Oracle DBMS, 12c, MS-SQL Database programming, SQLServer, MicroStrategy Schema, SQL Server, Big Data, Scrum, Agile, Dimensional Modeling, Informatica Power Center tool, Teradata 15.10 platform, SSIS ETL, RDBMS, Hadoop, Azure Cloud, Cloudera, Kafka, Master Data Management, Data Profiling, Unix, Shell, Hadoop (HDFS, Hive, Pig, SAS, Microsoft TFS, Agile/Scrum, PL-SQL, Oracle SQL, Oracle 11g, MS SQL- Server, PowerBI, HDFS, MapReduce, Data Warehouse, Center tool, Teradata 13.10 platform, ETL- design, telecommunication, Teradata RDBMS, Data Mining, Business Objects, Informatica, Power Center, Oracle warehouse Builder, Objects Crystal Reports, C++

Projekthistorie

03/2021 - bis jetzt
Senior Data Engineer
Securitas AB (Sonstiges, >10.000 Mitarbeiter)

Creation of Risk prediction Model (crime risk) for Global Data Platform. Data Engineering and BackEnd Development. Working together with Data Science Team and solving tasks for gathering data, integration within Global Data Model, optimization of Data Pipeline Execution.

Tasks and Activities:

  • ELT Pipeline Development and Maintenance
  • Snowflake DataBase Development

 

Tools and Technologies:

  

  • Snowflake, Postgres, PostGIS
  • Azure Cloud Infrastructure
  • Python 3.8, Go
  • Docker, Kubernetes, Airflow, Argo, Postman
  • JIRA

05/2020 - 03/2021
ETL Senior Developer
Global Foundries

Project for creation of BRE and ETL functionality for production chain optimization and KPI
reporting.
Development AbInitio native ETL transformations for processing large data volumes up to 1 bln.
records.

Tasks and Activities:
* ETL Development with AbInitio GDE
* Oracle Database Development

Tools and Technologies:
* Oracle DBMS 12c
* AbInitio GDE 3.5, AbInitio BRE
* JIRA

09/2018 - 04/2020
ETL Senior Developer
LIDL

Creation or DWH and BI Solution for LIDL in the Corporate Headquarter in Germany
Migration Project for the Core DataWarehouse (DWH 2.0).


Tasks and Activities:
* Teradata Database Development
* ETL Development with AbInitio GDE
* MicroStrategy 10.3 Architectural Model (Facts, Dimensions, Metrics, Attributes)

Tools and Technologies:
* Teradata
* MicroStrategy 10.3,
* AbInitio GDE 3.5
* JIRA

06/2018 - 09/2018
ETL Developer
APM Terminals(via VPT Aps)

Creation or DWH and BI Solution for MED 2 Teminal in Tangier, Morocco

Tasks and Activities:

* Design of Logical/Physical Data Model for Core DWH and Semantic Layer (Dimensional
Modeling).
* MS-SQL Database programming
* ETL Development with Informatica Power Center 10
* MicroStrategy 10.3 Architectural Model (Facts, Dimensions, Metrics, Attributes)

Tools and Technologies:

* MS-SQLServer
* MicroStrategy 10.3,
* Informatica Power Center 10.00
* JIRA

06/2016 - 05/2018
Technical Lead / Data Architect
Maersk Line

http://www.maersk.com
June 2016- May 2018


Global container shipment leader. Project for Data enablement from Company DWH to Access Layer,
MicroStrategy Schema, SQL Server BI, Export Layer for different company departments and for Big Data
projects.
My role was was Technical Lead /Data Architect.

Tasks and Activities:

* Analysis of business requirements. Interview with Subject Matter Experts.
* Team Leadership. Scrum/Agile environment. Communication with Technical and Business Product
owners.
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design)
* Design of PDM for Core DWH and Semantic Layer (Dimensional Modeling).
* MicroStrategy Schema Architecture, SQL Server BI.
* Optimizing Informatica Power Center tool for Teradata 15.10 platform (implementation of
Push-down option), SSIS ETL procedures.
* Contribution to the ETL-Framework and architecture. Optimization of Stage Load, Stage to
Target Load and optimization of current ETL-procedures. Removing of workload "bottlenecks"

Tools and Technologies:

* Teradata RDBMS, MS-SQLServer
* ERwin Data Modeler
* MicroStrategy 10.3, Power BI
* Informatica Power Center 10.00 (general ETL and for Data Lake creation), SSIS
* JIRA
* Hadoop(Azure Cloud), Cloudera, Kafka, Python

06/2015 - 05/2016
Data Architect/Modeler
SDC

www.sdc.dk
June 2015- May 2016


Big Danish company, IT service provider for 120 medium-small financial institution in Scandinavia.
Company has big portfolio of products and services which covers the whole IT infrastructure in
banking.
My role was in BI&Decision Support department. Main activity was creation of Dimensional Access
Layer on basis of EDWH and other informational systems. Project was organized as Agile/Scrum team.


Tasks and Activities:

* Analysis of business requirements. Interview with Subject Matter Experts.
* Leading a Team as Scrum Master
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design)
* Design of Semantic Layer (Dimensional Modeling).
* Contribution to the ETL-Framework and architecture. Optimization of Stage Load, Stage to
Target Load and optimization of current ETL-procedures. Removing of workload "bottlenecks"
* Master Data Management and Source Data Profiling

Tools and Technologies:


* Teradata RDBMS 15.10, SQL
* Unix, Shell
* Hadoop (HDFS, Hive, Pig, Scoop)
* SAS DI Studio
* Microsoft TFS

04/2014 - 05/2015
Senior Developer/Analyst
Nordea Bank-Capital Markets

, Copenhagen, Denmark
www.nordea.com
April 2014 - May 2015


Largest Scandinavian Bank, one of the European greatest banking groups, Investment Banking
Branch(Nordea Capital Markets)

Tasks and Activities:

* Analysis of business requirements. Interview with Subject Matter Experts.
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design)
* Design of PDM for Core DWH and Semantic Layer (Dimensional Modeling).
* Contribution to the ETL-Framework and architecture. Optimization of Stage Load, Stage to
Target Load and optimization of current ETL-procedures. Removing of workload "bottlenecks"
* Master Data Management and Source Data Profiling

Projects: *Maintenance and Improvements for Trading General Ledger - Was performing role of an
Analyst who analyses user requirements and provide guidance for developers.

*Implementation of Swedish LCR (Liquidity Coverage Ration) Complex project in
Agile/Scrum environment with close cooperation with business. My role was Senior Database Developer
(PL-SQL, Oracle SQL, Shell). Tasks were performed on "nose to tail " basis from the interview with
key stakeholders to final test or delivered functionality together with business.

Tools and Technologies:


* Oracle 11g, MS SQL- Server
* OBIEE, PowerBI
* Teradata RDBMS 14.10, SQL
* Unix, Shell
* Hadoop, HDFS, MapReduce
* Data Stage
* JIRA

08/2013 - 03/2014
Teradata Expert - external consultant(via Teradata Corp)
Société Générale Bank

, Paris, France
www.societegenerale.fr
August 2013 - March 2014


Large French Bank, one of the European greatest banking groups.


Tasks and Activities:

* Migration of current application on Oracle to the Teradata RDBMS
* Responsible for the ETL-migration and Data Model migration
* Performance optimization and Teradata features implementation for the current applications

Tools and Technologies:

* Teradata RDBMS 14.10, SQL
* Oracle 11g
* OBIEE
* Unix, Shell
* Data Stage
* C

06/2012 - 11/2012
Database Analystexternal consultant

http://www.maerskline.com
November 2012 - June 2012


Global container shipment leader. Project of creation Sustainable Data Warehouse solution and
migration of financial and marketing reporting from raw source data to the Integrated Layer.

Tasks and Activities:

* Analysis of business requirements. Interview with Subject Matter Experts.
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design)
* Design of PDM for Core DWH and Semantic Layer (Dimensional Modeling).
* Optimizing Informatica Power Center tool for Teradata 13.10 platform(implementation of
Push-down option).
* Contribution to the ETL-Framework and architecture. Optimization of Stage Load, Stage to
Target Load and optimization of current ETL-procedures. Removing of workload "bottlenecks"
* Master Data Management and Source Data Profiling

Tools and Technologies:

* Teradata RDBMS
* ERwin Data Modeler
* Informatica Power Center

05/2012 - 10/2012
LDM/PDM Designer, ETL optimization consultant
Teradata Corp

Stockholm Sweden
http://www.telia.se
May 2012-October 2012


Pan-Scandinavian telecom operator. Project for creation company central DataWarehouse solution.

Tasks and Activities:

* Analysis of business requirements. Interview with stakeholders and Subject Matter Experts.
Requirements management.
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design,
Reporting requirements, Data source matrix with mapping rules).
* Master Data Management and Source Data Profiling
* Contribution to the ETL-Framework and architecture (Design of Stage layer, definition of
TPT-templates for procedures running via Informatica Power Center)


Tools and Technologies:

* Oracle and Teradata RDBMS
* ERwin Data Modeler
* Business Object, OBIEE
* Informatica Power Center

03/2011 - 05/2012
DataWarehouse Business Analyst - external consultant(via Teradata Corp)
UniCredit Global Information Services

Information Services, Vienna
www. http://www.unicreditgroup.eu/en/home.htm
March 2011 -May2012


UniCredit group unit which is outsourcing IT-activities for a corporate divisions in Central
European Countries.

Tasks and Activities:

* Analysis of business requirements.
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design,
Reporting requirements, Data source matrix with mapping rules).




Tools and Technologies:

* Oracle and Teradata RDBMS
* MicroStrategy
* Data Stage

02/2010 - 05/2011
DataWarehouse Consultant
Indra Sistemas Czech Republic

www.indracompany.com
February 2010 -May 2011



Technological Corporation with more then 25 000 employees all over the world. Specialized on IT
outsourcing , consultancy, logistic and defence solutions.
Activity in Czech Republic is solutions for telecommunication, energy, transport, financial
services.
I was hired on the project Software Factory for BI Department in Telefonica O2 Czech Rep.
My role is Data Warehouse Consultant/BI Analyst.

Tasks and Activities:

* Analysis of business requirements.
* Creation of technical design and analytical documents (LDM/PDM design, ETL- design,
Reporting requirements, Data source matrix with mapping rules).
* Development (SQL, ETL (Informatica workflows)).
* Managing activities for TRM project (requirements analysis, architectural tasks)

Tools and Technologies:

* Oracle and Teradata RDBMS
* MicroStrategy
* Informatica Power Center
* TRM

06/2007 - 02/2010
Senior DataWarehouse Consultant
Teradata Corp.

Technological Corporation with more then 6000 employees. Specialized on DataWarehouse industry and
CRM applications.
I was hired as Professional Service Consultant for Eastern European team. On different projects my
role was BI Analyst/DataWarehouse Developer. I have participated in projects for creation
DataWarehouse from scratch, creation of Data Mining solutions for marketing, creation of analytical
and mandatory reporting for marketing, financial and network quality needs for Telco Industry.
I was part of pre-sales team for Financial Industry as Technology Consultant.

Tasks and Activities:

* Analysis of Business Requirements.
* Creation of technical design and analytical documents (ETL- design, Reporting Requirements,
LDM/PDM Design, Data source matrix with mapping rules).
* ETL Development.
* Reporting Design.


Tools and Technologies:

* Teradata RDBMS
* MicroStrategy and Business Objects
* Oracle Data Integrator, Informatica Power Center

05/2006 - 06/2007
Data Warehouse Developer
Citia BTC

Ukrainian based company with British investments with big portfolio of Telco and Financial companies
on local market. Financial and IT consulting for corporate reporting and BI needs.
My role was Data Warehouse Developer.

Task and Activities:

* Development of ETL-applications according to functional specification
* Source system technical analysis
* Optimization of current workload
* Creation of procedures and datamarts for reporting

Tools and Technologies:

* Oracle RDBMS, SQL, PL-SQL
* Business Objects Data Integrator, Oracle warehouse Builder
* Business Objects Crystal Reports, Oracle e-Business Suite

07/2004 - 06/2006
Oracle Developer
eMICT

www.emict.com

Ukrainian based IT-company specialized on development solutions for lottery and e-Gambling industry.

Tasks and Activities:

* SQL, PL-SQL development according to functional specification
* Optimization of current solutions (Performance tuning)
* Creation of procedures and datamarts for reporting

Tools and Technologies:

* Oracle RDBMS, SQL, PL-SQL

03/2002 - 06/2004
Oracle Developer
R-Style

www.emict.com

Ukrainian based IT-company with Russian investments specialized on development solutions for Banking
and Financial industry.

Tasks and Activities:

* SQL, PL-SQL,C++ development according to functional specification
* Optimization of current solutions (Performance tuning)
* ETL-Development
* Creation of procedures and datamarts for reporting

Reisebereitschaft

Weltweit verfügbar
Profilbild von Anonymes Profil, ETL Senior Developer, Snowflake, Informatica, Ab inito, Airflow, Teradata, Oracle ETL Senior Developer, Snowflake, Informatica, Ab inito, Airflow, Teradata, Oracle
Registrieren