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
- 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 - May 2022
2 months Lorem ipsum dolor sit amet
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 development
- B2B consulting
- Prepare entire reporting layer
- Business analytics
Sep 2020 - Mar 2021
7 monthsBudapest, Hungary
Backend & Oracle Developer / Freelancer
Generali Insurer
- 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
- 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 - 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 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 - May 2018
4 monthsDublin, Ireland
EDW Consultant – Data SME / Freelancer
Bank Of Ireland
- SQL optimization
- Stored procedures
- Investigation of EDW services
- Third-level support
Jun 2017 - Nov 2017
6 monthsVienna, Austria
Technical Analyst / Developer / Freelancer
UniCredit Bank Austria
- Requirements gathering
- Create STM
- Design
- Implementation
- ETL
- Identifying business data elements
Aug 2016 - Mar 2017
8 monthsNeckarsulm, Germany
Consultant / BI Developer / Freelancer
LIDL Stiftung & Co. KG
- Improving DWH reports' quality
- SQL performance
- Created materialized views
- Presentation layer design
- Data integration process design
Oct 2013 - Dec 2015
2 years 3 monthsGermany
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 - Oct 2013
7 monthsConsultant
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 2012 - Nov 2012
11 monthsSenior 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 - Dec 2011
5 monthsCopenhagen, Denmark
Developer
Nordea
- Implement ETL initial and daily load for TRM (CRM tool of Teradata before Aprimo acquisition)
- Design data mart
May 2011 - Jun 2011
2 monthsDeveloper
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 - Dec 2010
2 monthsFinland
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 - Dec 2010
9 monthsDeveloper
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 - Mar 2010
5 monthsETL 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
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
Oct 2006 - Mar 2007
6 monthsDeveloper
Barclays Teradata Acquisition
- Prepared for Teradata
- Data acquisition from DB2 to Teradata
- Training on Teradata utilities
May 2006 - Sep 2006
5 months Lorem ipsum dolor sit amet
Sales Portal
- Sales portal for Satyam Sales team development
- PHP scripts, Oracle, PL/SQL packages
Oct 2005 - Apr 2006
7 monthsDeveloper
British Petrol
- Replanting from Oracle Financial to SAP
- Support activities in Sun Solaris system
Languages
Hungarian
NativeEnglish
AdvancedGerman
Intermediate Education
Oct 2006 - Jun 2009
University of Pannon
Master's Thesis: Theoretical comparison of Teradata, DB2 and Oracle databases · Information Technology, Mathematics · Veszprém, Hungary
Oct 1999 - Jun 2005
College of Gabor Denis of Information Technology
Bachelor's Thesis: Insurance seller dynamic web site · Budapest, Hungary
Certifications & licenses
Data Vault DVBC Training
Scalefree Gmbh
Goethe B2 Certificate
IBM Certified DataStage Solution Developer
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
