Alexander Kornienko, Developer in Alanya/Antalya, Turkey
Alexander is available for hire
Hire Alexander

Alexander Kornienko

Verified Expert  in Engineering

Bio

Alexander is an experienced data engineer with a strong background in data warehouses, ETL, and data migration. As a data product owner, developer, analyst, and architect, he played a key role in multiple large-scale projects while managing end-to-end processes and maintaining the data warehouse with 350+ TB, 100+ data marts, and 500+ users. Alexander managed a team of data engineers and mentored several junior colleagues, helping them to advance their professional growth.

Portfolio

Sberbank
Teradata, SQL, Oracle DBA, Greenplum, Apache Hive, Parquet...
Russian Standart Bank
Oracle Data Integrator (ODI), Teradata, Oracle, ETL, Database Modeling...
Rosbank
Sybase PowerDesigner, Database Modeling, Databases, Database Design...

Experience

  • SQL - 15 years
  • Data Engineering - 10 years
  • ETL - 10 years
  • Teradata - 8 years
  • Data Migration - 6 years
  • SQL Server Integration Services (SSIS) - 5 years
  • Microsoft SQL Server - 4 years
  • Oracle Data Integrator (ODI) - 4 years

Availability

Part-time

Preferred Environment

Teradata, Microsoft SQL Server, Oracle Data Integrator (ODI), SQL Server Integration Services (SSIS), Greenplum, Apache Airflow, Apache Hive, Hue, Python, Oracle

The most amazing...

...thing I've worked on is a job control project to launch and monitor 1,000+ jobs in the bank, with 100+ data marts, 200+ ETL processes, and 400+ business users.

Work Experience

Senior Data Engineer and Product Owner of Data Team

2016 - 2022
Sberbank
  • Migrated 100+ data marts, 200+ ETL processes, and 400+ business users from Teradata MPP to Greenplum. Duplicated data marts in Greenplum laboratory, built ETL procedure between Teradata and Greenplum, and transferred calculations without Teradata.
  • Analyzed load balance performance of 350+ TB, 400+ business users, and less than 20 throttles. Configured the system parameters, monitored and optimized heavy queries, managed the workload, scheduled user procedures, and provided support.
  • Led the customer golden record project to rebuild 50+ data marts with customer and product data using a new customer identification. Designed the architecture, developed ETL procedures and data marts, performed tests, and provided support.
  • Managed the job control project to develop a tool for launching all ETL processes in one package with job dependencies, source increment checks, load balance, and regular launches.
  • Supervised the project of the next best offer to provide daily calculations of the next best offers for the bank's retail customers and select the most appropriate one based on the scoring model. Developed, optimized, and supported all procedures.
  • Developed data marts for data scientists. The data were from 20+ different sources, while data marts were designed and built with 1,000+ fields such as customer, product, and transaction data.
Technologies: Teradata, SQL, Oracle DBA, Greenplum, Apache Hive, Parquet, Microsoft SQL Server, Hue, Oracle Data Integrator (ODI), Apache Airflow, SQL Server Integration Services (SSIS), ETL, Data Modeling, Data Migration, Data Engineering, API Connectors, Data Analytics, Data Analysis, Oracle PL/SQL, PL/SQL Developer, PostgreSQL, PL/SQL, Databases, Database Design, Query Optimization, Business Intelligence (BI), Data Warehousing, T-SQL (Transact-SQL), DevOps, Data Science, ETL Development, Data Pipelines, Database Architecture, Oracle Database, SQL Performance, Performance Tuning, SQL DML

Head Specialist of DWH Teradata

2015 - 2016
Russian Standart Bank
  • Built a tool for launching all ETL processes in one daily package with job dependencies, checking increment on sources, load balance, and regular launches of more than 100 jobs by schedule.
  • Developed pipelines with Oracle Data Integrator, built the final data warehouse in Teradata, and used Oracle, Microsoft SQL, and Sybase as sources.
  • Provided daily calculations of the next best offers for the bank's retail customers and automated the choice of the most appropriate one based on the scoring model.
Technologies: Oracle Data Integrator (ODI), Teradata, Oracle, ETL, Database Modeling, Data Modeling, Data Migration, Data Engineering, Data Analytics, Oracle PL/SQL, PL/SQL Developer, Databases, Database Design, Query Optimization, Business Intelligence (BI), Data Warehousing, ETL Development, Data Pipelines, Microsoft Data Transformation Services (now SSIS), Oracle Database, Oracle ODI, T-SQL (Transact-SQL), SQL Performance, Performance Tuning, SQL DML

Data Architect

2013 - 2015
Rosbank
  • Built the process of managing the availability, usability, integrity, and security of the data in enterprise systems based on internal data standards and policies for controlling data usage.
  • Helped manage the project, appoint responsible persons for data governance strategy for retail data warehouse, including metadata, integration, reference books, and documents, negotiate with business experts, and prepare documents.
  • Collected data from different sources and designed and built data marts with pension payments data for the following use by data analysts.
Technologies: Sybase PowerDesigner, Database Modeling, Databases, Database Design, Data Warehousing

ETL Developer

2011 - 2012
Croc
  • Created a data warehouse and BI reports for the manufacturing company. The data was extracted from three other sources, transformed and aggregated, and loaded into data marts using ODI. Cognos was a tool for creating reports in this project.
  • Developed a data warehouse and BI reports for a healthcare company. The data was extracted from the sources, transformed and aggregated, and loaded into data marts using MS SSIS.
  • Oracle BI was a tool for creating reports in this project.
Technologies: Oracle Data Integrator (ODI), Oracle, SQL Server Integration Services (SSIS), Oracle BI, Data Migration, ETL, Data Engineering, Oracle PL/SQL, PL/SQL Developer, Databases, Database Design, Query Optimization, Business Intelligence (BI), Data Warehousing, ETL Development, Oracle Database, Oracle ODI, T-SQL (Transact-SQL), SQL DML

ETL Developer

2008 - 2010
S&T Russia
  • Created a data warehouse and BI reports for an insurance company. The data was extracted from five other sources, transformed and aggregated, and loaded into data marts using ODI. MicroStrategy was a tool for creating reports in this project.
  • Migrated all ETL procedures from IBM Data Stage to Oracle Data Integrator. There was reverse engineering of 100+ procedures on IBM Data Stage, developing and supporting the scripts and algorithms on ODI.
  • Created ETL pipelines for data warehouse on MSSQL with SSIS for big food companies.
Technologies: MicroStrategy, Oracle, Data Migration, Database Modeling, Microsoft SQL Server, ETL, Oracle Data Integrator (ODI), Data Engineering, Oracle PL/SQL, PL/SQL Developer, PL/SQL, Databases, Business Intelligence (BI), Data Warehousing, T-SQL (Transact-SQL), ETL Development, Microsoft Data Transformation Services (now SSIS), Oracle Database, Oracle ODI, SQL DML

Experience

Job Control of Daily Executing Packages

The project's main goal was to develop a tool for launching all ETL processes in one package containing dependencies between jobs and source increment checks, resulting in a decreased time of daily processes, load balance, and regular launches.

Customer Golden Record Project for Bank

The main goal of the project was to rebuild 50+ data marts with customer and product data with the usage of a new customer identificatory (a golden record).
I built new data marts and provided a bulk check of the attribute quality for usage in already done ML models.

Migration from Teradata MPP to Greenplum for Bank

The project's main goal was to migrate 100+ data marts, 200+ ETL processes, and 400+ business users from Teradata MPP to Greenplum. The drawback of Teradata was its performance and TCO. Firstly, we duplicated data marts in the Greenplum laboratory and built an ETL procedure between Teradata and Greenplum. Secondly, we transferred calculations and filled data marts with data from the sources without Teradata in the pipeline.

Education

2007 - 2009

Master's Degree in Informatics and Applied Mathematics

Moscow Institute of Physics and Technology - Moscow, Russia

2003 - 2007

Bachelor's Degree in Applied Mathematics

Moscow Institute of Physics and Technology - Moscow, Russia

Skills

Tools

Apache Airflow, Hue, Sybase PowerDesigner

Languages

SQL, SQL DML, T-SQL (Transact-SQL), Python

Paradigms

ETL, Database Design, Business Intelligence (BI), Oracle ODI, Agile, DevOps

Platforms

Oracle Data Integrator (ODI), Oracle Database, Oracle

Storage

Teradata, Microsoft SQL Server, SQL Server Integration Services (SSIS), Database Modeling, Oracle PL/SQL, PL/SQL Developer, PL/SQL, Databases, SQL Performance, Greenplum, PostgreSQL, Data Pipelines, Database Architecture, Oracle DBA, Apache Hive

Other

Data Migration, Data Engineering, Query Optimization, Data Warehousing, ETL Development, Microsoft Data Transformation Services (now SSIS), Performance Tuning, Applied Mathematics, MicroStrategy, Data Analytics, Data Analysis, Data Modeling, Computer Science, Parquet, Oracle BI, API Connectors, Data Science

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring