János Kurics - Data Engineer Lead

Q: Where is János based?

János is based in Budapest, Hungary .

Q: What languages does János speak?

János speaks the following languages: Hungarian (Native), English (Advanced), German (Intermediate) .

Q: How many years of experience does János have?

János has at least 14 years of experience. During this time, János has worked in at least 14 different roles and for 22 different companies . The average length of individual experience is 1 year and 7 months . Note that János may not have shared all experience and actually has more experience.

Q: What is János's latest experience?

János's most recent position is Data Engineer Lead at Sanofi .

Q: What companies has János worked for in recent years?

In recent years, János has worked for Sanofi , Foxpost Hungary Plc. , MOL (Magyar Olaj es Gazipari Nyrt.) , Viva Media GmbH , and Generali Insurer / Generali Zrt. .

Q: Which industries is János most experienced in?

János is most experienced in industries like Banking and Finance , Telecommunication , and Energy . János also has some experience in Transportation and Logistics , Information Technology (IT) , and Pharmaceutical .

Q: Which business areas is János most experienced in?

János is most experienced in business areas like Business Intelligence , Information Technology (IT) , and Quality Assurance (QA) .

Q: Which industries has János worked in recently?

János has recently worked in industries like Pharmaceutical , Transportation and Logistics , and Energy .

Q: Which business areas has János worked in recently?

János has recently worked in business areas like Business Intelligence and Information Technology (IT) .

Recommended expert

Budapest, Hungary

Experience

Nov 2023 - May 2025

1 year 7 months

Budapest, Hungary

Data Engineer Lead

Sanofi

Design Data warehouse
Data Modelling
Lead activity
Reverse Engineering

Jun 2023 - Oct 2023

5 months

Budapest, Hungary

External Data Architect

Foxpost Hungary Plc.

design data warehouse
data modelling
business analytics
consulting
Mastering the keys of two different systems for report servicing after migration

Nov 2022 - May 2023

7 months

Budapest, Hungary

External Sr. BI Architect

MOL (Magyar Olaj es Gazipari Nyrt.)

model data marts
Power BI report develop
design sql patterns (eg hist)
implementation in datalake, 3nf, star schema layer
identify KPIs
data cube calculations
business analytics
coordinate activity

Apr 2022 - May 2022

2 months

Consultant

Viva Media GmbH

external consulting about postgres migration
handover performance tuning know how about postgres cloud service

Dec 2021 - Nov 2022

1 year

Budapest, Hungary

External BI Consultant

Foxpost Hungary Plc.

Power BI report develop
b2b consulting
prepare entire reporting layer
business analytics

Sep 2020 - Mar 2021

7 months

Budapest, Hungary

Backend & Oracle Developer / Freelancer

Generali Insurer / Generali Zrt.

Data integration
legacy SQL code reverse engineering
legacy business analyses correction
SQL coding for Data Vault Model

Oct 2019 - Jun 2020

9 months

Vienna, Austria

Backend & Oracle Developer / Freelancer

Wienenergie / Wien IT (on behalf of Simplity GmbH)

Data vault V2.0 model usage / Hubs, Links, Satellite
Push forward an idle Proof of Concept
Reverse engineering legacy broken structure
Build up complete layers based on the architect and business people’s discussions on the fly in rapid PoC style
Add new PL/SQL packages
SQL Optimization, eliminate performance issues of previous teams’ code
ETL develop, hash delta (scd1, scd2, scd4)
Extraction CRM source data from Big Data env. with Hive SQL
Reconcile Hive SQLs from RDBMS concept to Cloudera
Git scripts version controlling
Configure Oracle Scheduler
Release automation: Shell + GIT in Linux env.

Aug 2018 - Sep 2019

1 year 2 months

Stockholm, Sweden

Consultant / Teradata Developer / Freelancer

Nordea Bank, Sweden

Transform Aptitude ETL tool’s generated ETL processes and Teradata procedures to one SQL view
Reverse Engineering legacy structure with data lineage creation / python programming
Provide high support for the BA to figure out the calculation’s logic of legacy applications
Adjusting Presentation Layer
Requirements gathering, backend side provided specification’s suggestion
Data integration
DataStage 11 usage for triggering the jobs
Redesign and full stack develop of GSI DataStage 11 Hierarchical Stage to move one-many XSD MQ Services to one table solution end to end
Rewrite Teradata 15 queries to TD 16 Intelliflex
Massive Optimization of Rubix serial batch reports: 40 min reduced to 1-2 min per each
Responsibility manor taking care of the team member
Trustee communication and charged by the Swedish business people

Feb 2018 - May 2018

4 months

Dublin, Ireland

EDW Consultant – Data SME / Freelancer

Bank Of Ireland

SQL optimization
Stored procedures
Investigation of EDW services
3rd level support

Jun 2017 - Nov 2017

6 months

Vienna, Austria

Technical Analyst / Developer / Freelancer

UniCredit Bank Austria (on behalf of Teradata Austria GmbH)

Requirements gathering
Create STM
Design and implementation
ETL
Identifying business data elements

Aug 2016 - Mar 2017

8 months

Neckarsulm, Germany

Consultant / BI Developer / Freelancer

LIDL Stiftung & Co. KG (on behalf of Teradata Deutschland GmbH)

Improving DWH reports quality
SQL performance tuning
Created materialized views
Presentation layer design
Data integration process design

Oct 2013 - Dec 2015

2 years 3 months

Sr. Active DWH Developer

Deutsche Telekom

Develop modules on a given Ab initio framework: Aggregates, Input-, Output interface
Develop SQL scripts and Ab initio micro graphs
SQL optimization via DBQL, QCD usage
Use Teradata 14, Viewpoint, RFHUtil, IBM MQ, qload, shell scripting

Apr 2013 - Oct 2013

7 months

Consultant

Arkon Zrt. (on behalf of BI Consulting Tanácsadó Kft.)

Build DWH from scratch on Greenplum EMC2
Install Greenplum on CentOS, external tables, web external tables
DWH analysis and design, SCD type 1,2,3 with functions + md5
Framework design and implementation in python & pgsql
Frequent cooperation with client for business analyst feedbacks
BI layer design (PL)
Investigate Greenplum tech ability for OLAP

Jan 2012 - Nov 2012

11 months

Budapest, Hungary

Sr. Developer

Volksbank Hungary Zrt.

Design DataMart
Business analysis (source and DWH)
Create mapping, design and implementation
DataStage ETL developing (SCD jobs)
DataStage administration via command lines
Revise vendor delivery
Investigation of complete DWH ETL system
Manage and reconfigure IBM DataStage settings at server level
Business analyst activity in MNB reports

Aug 2011 - Dec 2011

5 months

Copenhagen, Denmark

Developer

Nordea

Implement ETL initial and daily load for TRM
Design data mart

May 2011 - Jun 2011

2 months

Developer

EADS

PoC project to acquire new TD client
HP-UX: install all TTUs, kernel recompile, perl, shell scripting
Teradata: create database, profiles, roles, views, macros, procedures
Data upload of XML files with TPT, email alerting with triggers + ctrl table
Mapping analysis and corrections

Nov 2010 - Dec 2010

2 months

Developer

Kesko Finland

PoC technical demonstration to win a new Teradata client
TPT, CLI configuration, software installation on Win2003 server
Database optimization for the demonstration

Apr 2010 - Dec 2010

9 months

Developer

Nokia Finland

PoC project: first 1600 machine usage in EMEA
Migration project: Teradata to Teradata
Tools: Unix machine, Teradata DB, TPT scripts, Fastexport, Fastload, Informatica Powercenter, Omniture data handling
Own written TPT generator and datamover logic replacing by TPT utility

Nov 2009 - Mar 2010

5 months

ETL Lead Deputy / Developer

DHL IT S Prague

DataStage design and implementation
Coordinate offshore team responsibilities
Client contact activity
Tools: Unix OS server, Teradata DB, DataStage 7.51 ETL, Hp Openview Service Desk, Mercury, svn, importing from Oracle

Jun 2009 - Nov 2009

6 months

Developer

Vodafone Spain

Migration from Sybase & Oracle to Teradata
Develop unix shell scripts, SQL scripts, BTEQ, MultiLoad, FastLoad
Document development, Testing, Integration Testing
Business Object

Oct 2006 - Mar 2007

6 months

Developer

Barclays Teradata Acquisition

Data acquisition from DB2 to Teradata
Teradata, DB2, Mainframe, Unix, BTEQ, Multiload, Fastload, Unix shell scripting, JCL
Prepared for Teradata training in Budapest and Hyderabad

May 2006 - Sep 2006

5 months

Developer

Satyam Consultant Hungary (Sales Portal)

Sales portal for Satyam Sales team
PHP scripts, Oracle, PL/SQL packages

Oct 2005 - Apr 2006

7 months

Consultant

British Petrol

Replanting from Oracle Financial to SAP
Support activities in Sun Solaris system
Managing RFS and Spider database transmissions
Problem resolution and root cause analysis

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Banking and Finance (3.5 years), Telecommunication (3.5 years), Pharmaceutical (1.5 years), Transportation (1.5 years), Energy (1.5 years), and Information Technology (1.5 years).

Banking and Finance

Telecommunication

Pharmaceutical

Transportation

Energy

Information Technology

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (13 years), Information Technology (10.5 years), and Quality Assurance (0.5 years).

Business Intelligence

Information Technology

Quality Assurance

Skills

Operating Systems

Strong Uix, Linux, Mp-ras, Windows, Dos, Minor Knowledge On Mainframe And Sun Solaris

Rdbms

Snowflake, Azure Synapse Cloud, Mssql, Teradata 8,12, 13.10, 14, 15 , 16 Intelliflex; Oracle(9i, 10g), Db2 V9, Mysql, Sybase, Greenplum 4.2, Postgresql

Db Applications

Toad, Squirrel, Odbc Configuration On Server

Etl Tools

Informatica Cloud Service, Websphere Datastage 7.5, 8.1,11;odi, Informatica Power Center 9, Ab Initio 3.15.2, Azure Data Factory

Bi Tools

Microstrategy, Power Bi

Modeler Tools

Sqldbm, Sap Power Designer

Programming Languages

Power Bi Dax, Python , Unix Shell Script (Korn), Java, Php, C++, Javascript, Turbo Pascal, Perl, Pl/sql, Datastage’s Basic Language, Delphi, Pgsql

Application Programs

Git, Svn, Ms Office, Ms Visio, Hp Openservice Desk (Hpsd), Mercury, Jira,

Miscellaneous

Vrml, Html, Css, Sed, Awk, Xml,xsd, Wsdl, Rfhutil, Qload, Sljm

Recent Self Studies

Wherescape (3d, Red)

Languages

Hungarian

Native

English

Advanced

German

Intermediate

Education

Oct 2006 - Jun 2009

University of Pannon

Master · Information Technology, Mathematics · Veszprém, Hungary

Oct 1999 - Jun 2005

College of Gabor Denis of Information Technology

Bachelor · Budapest, Hungary

Certifications & licenses

IBM Certified DataStage Solution Developer Certifications

ISEB Software Testing Certification

Oracle 9i SQL

Teradata Database Associate TDBL1-16.00

Teradata Vantage SQL TDBL4-16.20

Profile

Created

January 2025

Last Update

June 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is János based?

János is based in Budapest, Hungary.

What languages does János speak?

János speaks the following languages: Hungarian (Native), English (Advanced), German (Intermediate).

How many years of experience does János have?

János has at least 14 years of experience. During this time, János has worked in at least 14 different roles and for 22 different companies. The average length of individual experience is 1 year and 7 months. Note that János may not have shared all experience and actually has more experience.

What roles would János be best suited for?

Based on recent experience, János would be well-suited for roles such as: Data Engineer Lead, External Data Architect, External Sr. BI Architect.

What is János's latest experience?

János's most recent position is Data Engineer Lead at Sanofi.

What companies has János worked for in recent years?

In recent years, János has worked for Sanofi, Foxpost Hungary Plc., MOL (Magyar Olaj es Gazipari Nyrt.), Viva Media GmbH, and Generali Insurer / Generali Zrt..

Which industries is János most experienced in?

János is most experienced in industries like Banking and Finance, Telecommunication, and Energy. János also has some experience in Transportation and Logistics, Information Technology (IT), and Pharmaceutical.

Which business areas is János most experienced in?

János is most experienced in business areas like Business Intelligence, Information Technology (IT), and Quality Assurance (QA).

Which industries has János worked in recently?

János has recently worked in industries like Pharmaceutical, Transportation and Logistics, and Energy.

Which business areas has János worked in recently?

János has recently worked in business areas like Business Intelligence and Information Technology (IT).

What is János's education?

János holds a Master in Information Technology, Mathematics from University of Pannon and a Bachelor from College of Gabor Denis of Information Technology.

Does János have any certificates?

János has 5 certificates. Among them, these include: IBM Certified DataStage Solution Developer Certifications, ISEB Software Testing Certification, and Oracle 9i SQL.

What is the availability of János?

János is immediately available full-time for suitable projects.

What is the rate of János?

János's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.