Profileimage by Anonymous profile, Datenbank Entwickler
available
Contact

Last update: 21.08.2021

Datenbank Entwickler

Graduation: Pannon University
Hourly-/Daily rates: show
negotiable, remote
Languages: German (Limited professional) | English (Full Professional) | Hungarian (Native or Bilingual)

Keywords

Datawarehouse / DWH Teradata SQL Oracle Abinitio Informatica Datastage SQL Unix shell scripting Linux

Attachments

CV Janos Kurics.docx

Skills

2019.10 - 2020.06 Wienenergie independent MDM, Data Vault, Oracle 19, reverse eng, fix legacy
2018.08 – 2019.09 Nordea Bank SE independent Decommission legacy model, Aptitude ETL to DataStage 11.3, massive SQL opt, Teradata 16
2018.02 – 2018.05 Bank of Ireland independentSQL optimization, Informatica
2017.06 – 2017.11 Bank of Austria independentcoordinate, develop, STM, requirements gathering
2016.08 – 2017.03 Lidl Deutschland independentrestructure presentation layer, support, SQL opt
2013.10 – 2015.12 Deutsche Telekom ITSH develop modules on a given Ab initio framework project lang: only German
2013.04 – 2013.10 Arkon Zrt.BIconsulting build DWH from sketch, PoC with Greenplum
2012.01 – 2012.12 Volksbank HU (Sberbank HU)employeeBA activity in MNB reports (ALM), design DM, DataStage dev, design, adm, revise vendors delivery, src from AS400, Mainframe (midas)
2011.07 – 2011.12 Nordea Bank DK Teradata Design DM, Initial and daily load impl scripts
2011.05 – 2011.06 EADS - AirbusTeradata PoC winning new Teradata client. Role: senior TD consultant.
2010.12 – 2011.06 Kesko Teradata PoC winning new TD client, tech demonstration
2010.04 – 2010.12 Nokia FI Teradata PoC of 1600, Informatica, OVI store, omniture
2009.11 – 2010.03 DHL CZ Teradata deputy of ETL lead, Teradata DB, DataStage 7.51
2009.06 – 2009.11 Vodafone SP Teradata migration from Sybase & Oracle to Teradata
2006.10 – 2007.03 Barclays UK SatyamTeradata acquisition sourcing from Mainframe,  Multiload, Fastload, Unix shell script, JCL
2005.10 – 2006.04 British Petrol SatyamReplanting from Oracle Financial to SAP

Project history

10/2019 - 06/2020
Oracle Developer
Wienenergie / Simplity (500-1000 employees)
Energy, water and environment
master data management project

-data vault V2.0 model
-significantly push forward a Proof of Concept from idle state
-reverse engineering legacy broken structure
-add new PL/SQL packages
-SQL optimization
-ETL develop (scd1, scd2)

08/2018 - 09/2019
Teradata Developer
Nordea Bank (500-1000 employees)
Banks and financial services
Teradata 15 ->16 Intelliflex
Datastage 11.3, xsd services
Python scripting
Entire BI batch reports (Rubix, IRB) SQL optimization
Data lineage creation from exported sql ddl text files with own written python script.
simplify legacy Aptitude ETL tool's steps into one SQL view logic

02/2018 - 05/2018
Data SME
Bank of Ireland (500-1000 employees)
Banks and financial services
DWH consulting
Teradata
Informatica
sql optimization

06/2017 - 11/2017
Stream Lead
Unicredit Bank (500-1000 employees)
Banks and financial services
UniCredit Business Integrated Solutions Austria
on behalf of Teradata Austria

-stream leader, technical analyst
-requirements gathering
-check necessary prerequisites
-create stm
-implementation

FSLDM environment
Teradata 15

08/2016 - 03/2017
Teradata Developer
Lidl (500-1000 employees)
Consumer goods and retail
Lidl Dienstleistung GmbH & Co. KG
via Teradata Deutschland GmbH
consulting, developer

10/2013 - 12/2015
Sr. Active Warehouse Developer
Deutsche Telekom (50-250 employees)

EKO project: I was improving dwh quality, SQL performance, created mat views

 

Location: Neckarsulm

Teradata 15, Viewpoint, SQL Scripts, Active Batch, SVN

Project language: English / German

(some emails, meetings were in German)

Onsite

04/2013 - 10/2013
DWH/BI Consultant
Arkon Zrt. (50-250 employees)
Other

http://biconsulting.hu/
Complete DWH build up from sratch. Oracle solution adoption into postgres/Greenplum DB


01/2012 - 11/2012
Sr. Datawarehouse Developer
Sberbank
I worked in the IT HQ of the bank where a small DWH team needed to do many things.

Tasks:
Design Datamarts
Analyst the business (source and dwh)
Create mapping, design and implementation
DataStage ETL Developing (SCD jobs)
Datastage Administration
Revise vendors delivery
Investigation of the complete dwh etl system
Manage and reconfigurate datastage settings in server level
Support the service if it was needed

09/2008 - 12/2011
Consultant
Teradata (500-1000 employees)
Internet and Information Technology
Main activities:
Internal Teradata consultant for the local PS Teradata organisations.

PoC project wining new TD client: EADS, Kesko, Nokia
PoC project in Nokia the first 1600 series lead in EMEA Ovi Store
ETL coordinator activity in DHL CZ
Database design and develop
Teradata database and tools
Multiple projects handling in the same time
Held trainings about teradata tech & practical project experience
for new collagues 3 times for 3-4 days.

Contact form

Contact details