János Kurics
Data Engineer Lead
Experience
Data Engineer Lead
Sanofi
Project: Diamond USA EDW Design Data warehouse Data Modelling Lead activity Reverse Engineering. Technologies: Snowflake, SqlDbm, Data Vault 2.0, Informatica IICS, Power BI
External Data Architect
Foxpost Hungary Plc.
Lead in DWH as a vendor design data warehouse data modelling business analytics consulting. Mastering the keys of two different systems for report servicing after migration. Technologies: SAP Power Designer, Data Vault 2.0, Power BI
External Sr. BI Architect
MOL
Project CTO_Dashboard: 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. Technologies: Microsoft Azure Synapse Cloud, Power BI, MSSQL on premise source, DataLake, Python Data Framework, Power Designer, SQL scripts, data marts, reporting layer. Using Agile method
External Consultant
Viva Media GmbH
Project Migration PoC Oracle to Postgres: External consulting about postgres migration handover performance tuning know how about postgres cloud service
External BI Consultant
Foxpost Hungary Plc.
Project Reporting Service: Power BI report develop b2b consulting prepare entire reporting layer business analytics. Technologies: Power BI, Airflow, Hadoop, MSSQL, Postgres, report redmine, json
Backend & Oracle Developer
Generali Insurer
Project Data Vault Model Implementation: Data integration legacy SQL code reverse engineering legacy business analyses correction SQL coding for Data Vault Model. Technologies: Oracle, Data Vault, ODI
Backend & Oracle Developer
Wienenergie / Wien IT
Project Master Data Management / Data Quality Management: 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.
Technologies: Oracle 19c, PL/SQL packages, Hive, Hadoop, Cloudera, data lineage, Oracle Scheduler, Git, Confluence
Teradata Developer
Nordea Bank
Project model migration: 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 (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: 40 min reduced to 1-2 min per each. For a 2 months disabled BI user could go live again in production. Recent covid-19 news names it "Nordea Credit Risk Calculator".
Responsibility manor taking care of the team member like the last freelancer at Nordea Stars project. Trustee communication and charged by the Swedish business people. Highly competitive environment.
Technologies: Teradata 15 -> 16 Intelliflex, DataStage 11, SQL Optimization, Python: Data lineage, scrum, git, confluence, jira. Using Agile method
EDW Consultant
Bank Of Ireland
SQL optimization, stored procedures, investigation of EDW services, 3rd level support. Technologies: Teradata 15, GCFR Teradata Framework, Informatica Powercenter 9, Control-M, jira
Technical Analyst / Developer
UniCredit Bank Austria
Requirements gathering, create STM, design, implementation, ETL, identifying business data elements (BDE). Technologies: Teradata 15, DataStage 8.01, SQL scripts, FSLDM. Using Agile method
BI Developer
LIDL Stiftung & Co. KG
EKO project: Improving DWH reports quality, SQL performance, created mat views, presentation layer. Design data integration process. Technologies: Teradata 15, Viewpoint, SQL Scripts, Active Batch, SVN, Ab initio, scrum, agile method
Senior Active DWH Developer
Deutsche Telekom
Active Warehouse Develop modules on a given Ab initio framework: Aggregates, Input-, Output interface. Developing SQL scripts and Ab initio micro graphs.
Technologies: Teradata 14, Viewpoint, SQL Bteq Scripts, SQL optimization via DBQL, QCD usage, Abinitio 3.15.2 – Micrograph, Services (xsd,wsdl), RFHUtil, IBM MQ-s, qload, shell scripting
Get business domain training in Darmstadt and Chemnitz
Backend Developer
Arkon Zrt.
Build DWH from scratch by tiny project crew like PoC on Greenplum EMC2. 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. Friendly and intensive cooperation with the client for frequent business analyst feedbacks. BI layer design (PL) ODI ETL Tool. Investigate Greenplum tech ability for OLAP
Senior Datawarehouse Developer
Volksbank Hungary
Design DataMart Analyst the business (source and DWH). Create mapping, design and implementation DataStage ETL developing (SCD jobs). Datastage Administration. 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
Developer
Nordea
Windows NT Implement ETL initial and daily load for TRM (CRM tool of Teradata before Aprimo acquisition). Design data mart
Developer
EADS
PoC project to acquire new TD client by 4 tech people. 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. Fast feedback to the analyst, doing mapping analysis and corrections. Report AJI, Viewpoint usage. Successful PoC. EADS became Teradata customer
Developer
Kesko Finland
PoC project: 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. Own written TPT generator and datamover (similar to Oracle Goldengate) logic replace by TPT utility + control table. Completely own written and designed method. Technologies: Unix machine, Teradata DB, TPT scripts, Fastexport, Fastload, Informatica Powercenter, Omniture data handling
ETL Lead Deputy / Developer
DHL IT S Prague
DataStage design, implementation, coordinate responsibility regarding the offshore Byelorussian team, contact activity with the client's service owners. Technologies: Unix OS server, Teradata DB, DataStage 7.51 ETL, Hp Openview Service Desk, Mercury business tracking system, svn file sharing tool, importing from Oracle
Developer
Vodafone Spain
Migration from Sybase & Oracle to Teradata. Develop unix shell scripts, SQL scripts, BTEQ, MultiLoad, FastLoad, document the development, Testing, Integration Testing, Business Object
Developer
Barclays Bank
Prepared for Teradata in 3 months training in Budapest in Hungary and another 3 months in Hyderabad, India. Data Acquisition from DB2 to Teradata. Technologies: Teradata, DB2, Mainframe, Unix, BTEQ, Multiload, Fastload, Unix shell script, JCL. The customer stopped the project because US mortgage problems made business decrease
Developer
Satyam
Sales portal for Satyam Sales team. Technologies: PHP scripts, Oracle, PL/SQL packages
Support Specialist
British Petrol
Replanting from Oracle Financial to SAP. Support activities in Sun Solaris system. Managing RFS and Spider database transmissions, problem resolution and route cause analysis related to customer's internal databases