Konstantin Zhukov
Montreal,Quebec
Summary
Team oriented Data Engineer with versatile experience in different data domains. Experienced with database development, building enterprise data ETL processes using on-premises and cloud data.
Solid experience in database design, modeling, data warehousing, data analysis and performance tuning.
Passionate about data processing using various tools and frameworks.
Focused on building and maintaining reliable data pipelines alongside with learning and applying new technologies.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Ubisoft
Montréal, Canada
05.2021 - Current
- Accomplished a project that required creating the players telemetry data pipelines (100x TB) using PySpark, SparkSQL and Apache Airflow
- Upgrading and developing the existing data pipelines built in Informatica PowerCenter to supply data warehouse fact and dimension tables
- Developing and maintaining complex big data ELT data pipelines using Snowflake as a data platform
- Working on historical player data reload with billions of records involved
- Engineering complex SQL based transformations for transferring data into data platform
- Optimizing data processing by reducing the amount of blocking transformations, minimizing data duplication
- Performing the data quality checks and determined the frequency distribution of the tables loaded to Snowflake
- Successfully accomplished as tech lead a project related to data migration from HDFS files to Snowflake tables (50 ETLs have been optimized and switched)
- Actively collaborating with data architects and business analysts to ensure that data models fit business and technical sides
- Involved into day-to-day data pipelines monitoring and proactive issue escalation.
Senior ETL developer
Reitmans (Canada) Ltd
Montréal, Canada
11.2017 - 05.2021
- Developing and maintaining ETL processes using Informatica PowerCenter 10 to extract transform and load the data from multiple source systems (Google cloud platform, databases, flat files, xml, json)
- Working with Unstructured Data Transformation
- Creating complex SQL scripts, PL/SQL Stored procedures, packages, functions alongside with python and shell scripts for various data pipelines
- Hans on experience with GCP BigQuery and cloud data integration processes
- SQL queries performance tuning of existing and future data pipelines
- Participating in providing the project’s estimates for development
- Coordinating and monitoring the project progress to ensure the timely flow and complete delivery of the project
- Writing technical design documents according to the project requirements
- Working with project managers and data architects to create and document technical project proposals that include estimates, planning and schedules
- Evaluate technologies and build prototypes for continuous improvements in data integration.
Senior database developer
C-Technology Ltd Kyrgyzstan
10.2015 - 09.2017
- Developed banking enterprise systems by analyzing and converting business requirements to technical requirements, followed by designing, developing and implementing the solutions
- Assisted in decision team members including DBAs, developers and others, in understanding data and business requirements
- Performed business and technical analysis of various of projects
- Managed team of two systems analysts, distributed ongoing system support tasks among them
- Provided production deployment and production support as needed
- Developed complex database processes with PL/SQL, SQL scripts alongside with SQL based reports development and core banking application development
- Performed data integration processes with VISA card system
- Tested projects throughout software development life cycle (SDLC).
Database developer
Demir International Bank Kyrgyzstan
11.2011 - 10.2015
- Contributed to the development of technical design decisions involving the database
- Created SQL objects like tables, stored procedures, views, triggers and functions
- Developed Core Banking System application using Oracle Forms, performed reports using Oracle Application Express
- Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
Education
Data engineering Nano degree -
01.2020
Big Data Certificate -
Concordia University
01.2018
B.S - Software engineering
Kyrgyz-Russian Slavic University
01.2008
Skills
- TECHNICAL SKILLS
- Cloud and Data Platforms:
- GCP, AWS, Snowflake
- Databases: Oracle, MS SQL Server, BigQuery, PostgreSQL, Apache Cassandra, Hive
- Data processing tools: SparkSQL, PySpark, Apache Airflow
- Languages: Python, PL/SQL, SQL, T-SQL, Shell script
- Tools & Utilities: Informatica Power Center, Git, Jira
- Operating systems: Windows, Linux
Certification
Google cloud platform certified data engineer professional 2020
Data Engineering on Google cloud platform 2019
Oracle PL/SQL Developer Certified Associate 2016
Oracle Advanced PL/SQL Developer Certified Professional 2016
Timeline
Senior Data Engineer
Ubisoft
05.2021 - Current
Senior ETL developer
Reitmans (Canada) Ltd
11.2017 - 05.2021
Senior database developer
C-Technology Ltd Kyrgyzstan
10.2015 - 09.2017
Database developer
Demir International Bank Kyrgyzstan
11.2011 - 10.2015
Data engineering Nano degree -
Big Data Certificate -
Concordia University
B.S - Software engineering
Kyrgyz-Russian Slavic University
Google cloud platform certified data engineer professional 2020
Data Engineering on Google cloud platform 2019
Oracle PL/SQL Developer Certified Associate 2016
Oracle Advanced PL/SQL Developer Certified Professional 2016
Similar Profiles
Daniel PonceDaniel Ponce
UI Technical Designer at UbisoftUI Technical Designer at Ubisoft
Marc NotoMarc Noto
Associate Producer [ANVIL PIPELINE] at UBISOFTAssociate Producer [ANVIL PIPELINE] at UBISOFT
Marius Ionut SanduMarius Ionut Sandu
Manager Data Engineering at UBISOFTManager Data Engineering at UBISOFT