János K.-Data Engineer Lead

Check rate
Experience
Data Engineer Lead
Sanofi
- Design data warehouse
- Data modelling
- Lead activities
- Reverse engineering
External Data Architect
Foxpost Hungary Plc.
- Design data warehouse
- Data modelling
- Business analytics
- Consulting
- Master the keys of two different systems for report servicing after migration
External Sr. BI Architect
MOL (Magyar Olaj es Gazipari Nyrt.)
- Model data marts
- Develop Power BI reports
- Design SQL patterns (e.g., hist)
- Implement data lake, 3nf, and star schema layers
- Identify KPIs
- Calculate data cubes
- Business analytics
- Coordinate activities
Consultant
Viva Media GmbH
- Provide external consulting on Postgres migration
- Transfer knowledge of performance tuning for Postgres cloud service
External BI Consultant
Foxpost Hungary Plc.
- Develop Power BI reports
- Provide B2B consulting
- Prepare the entire reporting layer
- Business analytics
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
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.
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
EDW Consultant – Data SME / Freelancer
Bank Of Ireland
- SQL optimization
- Stored procedures
- Investigation of EDW services
- 3rd level support
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
Consultant / BI Developer / Freelancer
LIDL Stiftung & Co. KG (on behalf of Teradata Deutschland GmbH)
- Improving DWH report quality
- SQL performance tuning
- Created materialized views
- Presentation layer design
- Data integration process design
Sr. Active DWH Developer
Deutsche Telekom
- Develop modules using a given Ab initio framework: Aggregates, Input-, Output interface
- Develop SQL scripts and Ab initio micro graphs
- SQL optimization using DBQL, QCD
- Use Teradata 14, Viewpoint, RFHUtil, IBM MQ, qload, shell scripting
Consultant
Arkon Zrt. (on behalf of BI Consulting Tanácsadó Kft.)
- Build a 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 the client to gather business analyst feedback
- BI layer design (PL)
- Investigate Greenplum's technical capabilities for OLAP
Sr. Developer
Volksbank Hungary Zrt.
- Design DataMart
- Business analysis (source and DWH)
- Create mappings, design and implementation
- Develop DataStage ETL (SCD jobs)
- DataStage administration via command lines
- Review vendor delivery
- Investigate the complete DWH ETL system
- Manage and reconfigure IBM DataStage settings at server level
- Business analyst activities for MNB reports
Developer
Nordea
- Implement ETL initial and daily loads for TRM
- Design data mart
Developer
EADS
- PoC project to acquire a new TD client
- HP-UX: install all TTUs, recompile the kernel, Perl, shell scripting
- Teradata: create databases, profiles, roles, views, macros, procedures
- Upload XML files with TPT, email alerts using triggers + control table
- Mapping analysis and corrections
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
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
- Replaced own written TPT generator and datamover logic with the TPT utility
ETL Lead Deputy / Developer
DHL IT S Prague
- DataStage design and implementation
- Coordinate offshore team responsibilities
- Client contact
- Tools: Unix OS server, Teradata DB, DataStage 7.51 ETL, Hp Openview Service Desk, Mercury, svn, importing from Oracle
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
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
Developer
Satyam Consultant Hungary (Sales Portal)
- Sales portal for the Satyam sales team
- PHP scripts, Oracle, PL/SQL packages
Consultant
British Petrol
- Migration from Oracle Financial to SAP
- Support activities on Sun Solaris systems
- Managing RFS and Spider database transmissions
- Problem resolution and root cause analysis
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Telecommunication, Pharmaceutical, Transportation, Energy, and Information Technology.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, and Quality Assurance.
Skills
Operating Systems
- Strong Uix, Linux, Mp-Ras, Windows, Dos; Basic Knowledge Of 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
Education
University of Pannon
Master · Information Technology, Mathematics · Veszprém, Hungary
College of Gabor Denis of Information Technology
Bachelor · Budapest, Hungary
Certifications & licenses
IBM Certified DataStage Solution Developer Certifications
Oracle 9i SQL
Teradata Database Associate TDBL1-16.00
Teradata Vantage SQL TDBL4-16.20
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
János is based in Budapest, Hungary.
János speaks the following languages: Hungarian (Native), English (Advanced), German (Intermediate).
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.
Based on recent experience, János would be well-suited for roles such as: Data Engineer Lead, External Data Architect, External Sr. BI Architect.
János's most recent position is Data Engineer Lead at Sanofi.
In recent years, János has worked for Sanofi, Foxpost Hungary Plc., MOL (Magyar Olaj es Gazipari Nyrt.), and Viva Media GmbH.
János is most experienced in industries like Banking and Finance, Telecommunication, and Energy. János also has some experience in Transportation, Information Technology, and Pharmaceutical.
János is most experienced in business areas like Business Intelligence, Information Technology, and Quality Assurance.
János has recently worked in industries like Pharmaceutical, Transportation, and Energy.
János has recently worked in business areas like Business Intelligence and Information Technology.
János holds a Master in Information Technology, Mathematics from University of Pannon and a Bachelor from College of Gabor Denis of Information Technology.
János has 5 certificates. Among them, these include: IBM Certified DataStage Solution Developer Certifications, ISEB Software Testing Certification, and Oracle 9i SQL.
The availability of János needs to be confirmed.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 6 Nov 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Engineer Lead
Nearby freelancers
Professionals working in or nearby Budapest, Hungary
