János Kurics
Data Engineer Lead
Erfahrungen
Nov. 2023 - Mai 2025
1 Jahr 7 Monaten Budapest, Ungarn
Data Engineer Lead
Sanofi
- Design Data warehouse
- Data Modelling
- Lead activity
- Reverse Engineering
Juni 2023 - Okt. 2023
5 Monaten Budapest, Ungarn
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 - Mai 2023
7 Monaten Budapest, Ungarn
External Sr. BI Architect
MOL
- Model data marts
- Power BI report develop
- Design SQL patterns (e.g., hist)
- Implementation in datalake, 3NF, star schema layer
- Identify KPIs
- Data cube calculations
- Business analytics
- Coordinate activity
Apr. 2022 - Mai 2022
2 Monaten Lorem ipsum dolor sit amet
Viva Media GmbH
- External consulting about Postgres migration
- Handover performance tuning know-how about Postgres cloud service
Dez. 2021 - Nov. 2022
1 Jahr Budapest, Ungarn
External BI Consultant
Foxpost Hungary Plc.
- Power BI report development
- B2B consulting
- Prepare entire reporting layer
- Business analytics
Sept. 2020 - März 2021
7 Monaten Budapest, Ungarn
Backend & Oracle Developer / Freelancer
Generali Insurer
- Data integration
- Legacy SQL code reverse engineering
- Legacy business analyses correction
- SQL coding for Data Vault Model
Okt. 2019 - Juni 2020
9 Monaten Wien, Österreich
Backend & Oracle Developer / Freelancer
Wienenergie / Wien IT
- 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 discussions on the fly in rapid PoC style
- Add new PL/SQL packages
- SQL Optimization, eliminate performance issues of previous teams’ code
- ETL development, hash delta (SCD1, SCD2, SCD4)
- Extraction CRM source data from Big Data environment with Hive SQL
- Reconcile Hive SQLs from RDBMS concept to Cloudera
- Git scripts version controlling
- Configure Oracle Scheduler
- Release automation: Shell + GIT in Linux environment
Aug. 2018 - Sept. 2019
1 Jahr 2 Monaten Stockholm, Schweden
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 development of GSI (Golden Source of Instruments) DataStage 11 Hierarchical Stage to move one-many XSD MQ services to one table solution: entire redesign and implementation end to end restructure till the above staying layer’s and the derivation logic
- Rewrite Teradata 15 queries to TD 16 Intelliflex
- Massive Optimization of Rubix serial batch reports: reduced 40 min to 1-2 min per each item
- Responsibility: taking care of team member as last freelancer at Nordea Stars project
- Trustee communication and charged by the Swedish business people
- Highly competitive environment
Feb. 2018 - Mai 2018
4 Monaten Dublin, Irland
EDW Consultant – Data SME / Freelancer
Bank Of Ireland
- SQL optimization
- Stored procedures
- Investigation of EDW services
- Third-level support
Juni 2017 - Nov. 2017
6 Monaten Wien, Österreich
Technical Analyst / Developer / Freelancer
UniCredit Bank Austria
- Requirements gathering
- Create STM
- Design
- Implementation
- ETL
- Identifying business data elements
Aug. 2016 - März 2017
8 Monaten Neckarsulm, Deutschland
Consultant / BI Developer / Freelancer
LIDL Stiftung & Co. KG
- Improving DWH reports' quality
- SQL performance
- Created materialized views
- Presentation layer design
- Data integration process design
Okt. 2013 - Dez. 2015
2 Jahren 3 Monaten Deutschland
Sr. Active DWH Developer
Deutsche Telekom
- Develop modules on a given Ab initio framework: Aggregates, Input-, Output interface
- Developing SQL scripts and Ab initio micro graphs
- SQL optimization via DBQL, QCD usage
- Shell scripting
- Get business domain training in Darmstadt and Chemnitz
- Passed Goethe B2 intermediate language certificate
Apr. 2013 - Okt. 2013
7 MonatenConsultant
Arkon Zrt.
- Building DWH from scratch by a tiny project crew like PoC
- Install Greenplum on CentOS
- External tables, web external tables
- DWH analysis, design, SCD type 1,2,3 with functions + md5
- Framework design and implementation in Python & PGSQL
- Intensive cooperation with the client for frequent business analyst feedbacks
- BI layer design
- Investigate Greenplum tech ability for OLAP
Jan. 2011 - Nov. 2012
11 MonatenSenior Developer
Volksbank Hungary Zrt.
- Design DataMart
- Analyze business (source and DWH)
- Create mapping, design, and implementation
- DataStage ETL developing (SCD jobs)
- DataStage administration (e.g., via command lines)
- Revise vendors' delivery (Qualysoft, Omnit)
- Investigation of the complete DWH ETL system
- Manage and reconfigure IBM DataStage settings in server level
- Business analyst activity in 4a and 9a MNB reports
Aug. 2011 - Dez. 2011
5 Monaten Kopenhagen, Dänemark
Developer
Nordea
- Implement ETL initial and daily load for TRM (CRM tool of Teradata before Aprimo acquisition)
- Design data mart
Mai 2011 - Juni 2011
2 MonatenDeveloper
EADS
- Install all TTUs
- Kernel recompile
- Shell scripting, Perl
- Teradata database creation, profiles, roles, views, macros, procedures
- Data upload of XML files with TPT
- Email alerting with triggers + control table
- Report AJI
- Fast feedback to analyst, mapping analysis and corrections
- Viewpoint usage
- Successful PoC. EADS became Teradata customer
Nov. 2010 - Dez. 2010
2 Monaten Finnland
Developer
Kesko Finland
- Technical demonstration to win a new Teradata client
- TPT, CLI configuration
- Software installation on Win2003 server
- Database optimization for the demonstration
Apr. 2010 - Dez. 2010
9 MonatenDeveloper
Nokia Finland
- Migration project: Teradata to Teradata
- TPT scripts, Fastexport, and Fastload
- Informatica Powercenter
- Omniture data handling
- Own written TPT generator and datamover logic replace by TPT utility + control table
Nov. 2009 - März 2010
5 MonatenETL Lead Deputy / Developer
DHL IT S Prague
- DataStage design and implementation
- Coordinate responsibility regarding offshore Byelorussian team
- Contact activity with the client’s service owners
Juni 2009 - Nov. 2009
6 MonatenDeveloper
Vodafone Spain
- Migration from Sybase & Oracle to Teradata
- Develop Unix shell scripts, SQL scripts, BTEQ, MultiLoad, FastLoad
- Document development
- Testing
- Integration testing
Okt. 2006 - März 2007
6 MonatenDeveloper
Barclays Teradata Acquisition
- Prepared for Teradata
- Data acquisition from DB2 to Teradata
- Training on Teradata utilities
Mai 2006 - Sept. 2006
5 Monaten Lorem ipsum dolor sit amet
Sales Portal
- Sales portal for Satyam Sales team development
- PHP scripts, Oracle, PL/SQL packages
Okt. 2005 - Apr. 2006
7 MonatenDeveloper
British Petrol
- Replanting from Oracle Financial to SAP
- Support activities in Sun Solaris system
Sprachen
Ungarisch
Muttersprache
Englisch
Verhandlungssicher
Deutsch
Fortgeschritten
Ausbildung
Okt. 2006 - Juni 2009
University of Pannon
Master of Thesis: Theoretical comparison of Teradata, DB2 and Oracle databases · Information Technology, Mathematics · Veszprém, Ungarn
Okt. 1999 - Juni 2005
College of Gabor Denis of Information Technology
Bachelor of Thesis: Insurance seller dynamic web site · Budapest, Ungarn
Zertifikate & Bescheinigungen
Data Vault DVBC Training
Scalefree Gmbh
Goethe B2 Zertifikat
IBM Certified DataStage Solution Developer
ISEB Software Testing Certification
Oracle 9i SQL
Teradata Database Associate TDBL1-16.00
Teradata Vantage SQL TDBL4-16.20
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.