Контактна інформація

Отримати контакти цього кандидата можна на сторінці https://www.work.ua/resumes/10178436/

Досвід роботи

Data engineer

з 01.2024 по нині (2 роки 10 місяців)
DataMola LLC, Львів (IT)

DWH / Data Engineer with 3 years of commercial experience in Data Engineering, DWH and database development. Worked primarily with IBM DB2 and Oracle, and later with Azure SQL and Azure Data Factory as part of cloud migration. Experienced in SQL, Python, JavaScript and Microsoft SQL Server.

• Developed and supported ETL/ELT pipelines for 40+ external data sources, including APIs, SharePoint and file-based sources
• Built end-to-end integrations for new data sources: extraction, validation, transformation, loading, scheduling, testing and production deployment
• Worked with a custom configuration-driven ETL framework based on Python flows, SQL procedures and IBM DB2
• Developed and maintained stored procedures, views and complex SQL queries for data processing, reporting and application logic
• Supported DWH processing across landing/raw, historical and current-data layers
• Monitored production ETL processes, investigated failed loads, performed root cause analysis and handled data quality issues
• Optimized SQL procedures and high-volume data loads
• Participated in migration of existing ETL processes from the on-premise/custom environment to Microsoft Azure
• Rebuilt existing and developed new data pipelines in Azure Data Factory
• Loaded data from APIs and files into Azure Data Lake Storage Gen2 and processed it further in Azure SQL Database
• Developed parameterized ADF pipelines with incremental loading, triggers and secure credential handling via Azure Key Vault
• Supported and troubleshot Azure Data Factory pipelines in production and worked with Git-based deployment workflows

Technologies: IBM DB2, Oracle, MS SQL Server, Azure SQL, SQL, Python, JavaScript, Azure Data Factory, ADLS Gen2, Azure Key Vault, SQL Server Agent, PowerDesigner 16, Flyway, GitHub, Postman, Bruno, Docker, WinSCP.

Trainee/Junior Data Analyst

з 10.2022 по 03.2023 (6 місяців)
EPAM, Львів (IT)

Python Programming
• Data types, functions, decorators
• File handling (read/write operations)
• Working with databases (SQL integration)
• Object-Oriented Programming (OOP)
Data Analytics & Visualization
• Data analysis fundamentals
• Tableau: data exploration and visualization
• Power BI: data modeling and dashboards
• Practical workshops with Power BI

Освіта

Lviv Polytechnic National University

Master’s Degree in Information Systems and Technologies, Львів
Вища, з 2023 по 2024 (1 рік)

Lviv Polytechnic National University

Bachelor’s Degree in Cyber Security, Львів
Вища, з 2018 по 2023 (5 років)

Додаткова освіта та сертифікати

Python

2020, 32 години
Сертифікат

Data Analytics Engineering Training, EPAM

Липень 2022 - Вересень 2022, 3 місяці, 101 година
Сертифікат

Знання і навички

• SQL
• ETL
• ELT
• Data Warehouse
• Azure Data Factory
• Azure SQL Database
• ADLS Gen2
• Azure Key Vault
• IBM DB2
• Oracle Database
• MS SQL Server
• Python
• Data Quality
• DBMS
• SQL Server Agent
• PowerDesigner
• Flyway
• Git
• GitHub
• Bitbucket
• JavaScript
• Docker
• Postman
• Problem solving
• Analytical thinking
• Teamwork
• Communication

Знання мов

• Українська — вільно
• Англійська — середній

Інвалідність

Третя група.
Цукровий діабет. Обмежень щодо роботи не маю.

Додаткова інформація

I am a DWH / Data Engineer with 3 years of commercial experience working with IBM DB2, Oracle, SQL, Python and data integration.

My experience includes designing, developing and supporting ETL/ELT pipelines for 40+ external data sources, including APIs, SharePoint and file-based systems. I have built new integrations end-to-end, covering extraction, validation, transformation, loading, scheduling, testing and production deployment.

I have strong experience in SQL and database development, including stored procedures, views, complex queries, data transformations and performance optimization. I also implemented new backend/database functionality for custom dashboards and admin panels.

Later, I participated in migrating existing ETL processes to Microsoft Azure and developing new pipelines using Azure Data Factory, Azure SQL, ADLS Gen2 and Azure Key Vault.

I regularly worked with production pipelines, investigated failed loads and data anomalies, performed root cause analysis and resolved data quality and performance issues.

I also maintained PDM models in SAP PowerDesigner and performed a schema-level migration of 10+ DWH/application schemas to a new database server.