Recommended expert
János Kurics
Data Engineer Lead
Experience
Nov 2023 - May 2025
1 year 7 monthsBudapest, Hungary
Data Engineer Lead
Sanofi
- Design Data warehouse
- Data Modelling
- Lead activity
- Reverse Engineering
Jun 2023 - Oct 2023
5 monthsBudapest, 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 monthsBudapest, 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 monthsConsultant
Viva Media GmbH
- external consulting about postgres migration
- handover performance tuning know how about postgres cloud service
Dec 2021 - Nov 2022
1 yearBudapest, Hungary
External BI Consultant
Foxpost Hungary Plc.
- Power BI report develop
- b2b consulting
- prepare entire reporting layer
- business analytics
Sep 2020 - Mar 2021
7 monthsBudapest, 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 monthsVienna, 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 monthsStockholm, 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 monthsDublin, 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 monthsVienna, 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 monthsNeckarsulm, 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 monthsSr. 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 monthsConsultant
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 monthsBudapest, 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 monthsCopenhagen, Denmark
Developer
Nordea
- Implement ETL initial and daily load for TRM
- Design data mart
May 2011 - Jun 2011
2 monthsDeveloper
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 monthsDeveloper
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 monthsDeveloper
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 monthsETL 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 monthsDeveloper
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 monthsDeveloper
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 monthsDeveloper
Satyam Consultant Hungary (Sales Portal)
- Sales portal for Satyam Sales team
- PHP scripts, Oracle, PL/SQL packages
Oct 2005 - Apr 2006
7 monthsConsultant
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
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
NativeEnglish
AdvancedGerman
IntermediateEducation
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
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
Roland Horváth
Senior SAP BI, BW, BO Consultant
View Profile
Antal Toth
GRC Consultant
View Profile
Gerald Gastgeb
Data Warehouse Architect and Lead Data Modeler
View Profile
Axel Berron
Microsoft Fabric & Power BI Developer
View Profile
Stefan Corsten
SSIS Development
View Profile
Stefan Dangubic
BI Consultant in Controlling
View Profile
Alexander Zhirov
Senior Data Architect & Data Engineer
View Profile
Carsten Leschik
Business / Functional Analyst and Oracle Developer DWH
View Profile
Roland peter Schneider
Emigration and founding an LLC
View Profile
Kai Pankatz
Oracle Project Management and DBA
View Profile
Guino Ndjenndja
Senior Data Engineer
View Profile
Torsten Glunde
BI consultant
View Profile
Ben Spouse
Data Engineer/ ETL Developer
View Profile
Joachim Bleichert
Oracle consulting and development
View Profile
Marco Skulschus
Business Analyst, Data Warehouse Developer
View Profile
Germo Görtz
BI Developer
View Profile
Henok Abraham
Founder and Managing Director
View Profile
Stephan Martin
Sabbatical, professional development
View Profile
Jorge Machado
Data Architect
View Profile
Vitali Haberkorn
Power BI Expert
View Profile
Markus Groh
Data Solution Architect, Founder
View Profile
Amesh Parit
Data Developer
View Profile
Ashkan Zadeh
Microsoft Azure Senior Data Engineer / Senior Data Scientist
View Profile
Moez Seyedan
Data Engineer
View Profile
Ildar Allayarov
Senior Data Engineer
View Profile
Marek Werulik
Data Management Solution Architect
View Profile
Yannick Reinke
Power Platform Developer
View Profile
Stefan Wimmer
Architect/Software Developer/Infrastructure
View Profile
Philipp Grunert
Data Scientist & Data Engineer
View Profile
Nikolaus Jäger-grassl
Integration Architect
View Profile
