Contact information

You can get this candidate's contact information from https://www.work.ua/resumes/10178436/

Work experience

Data engineer

from 01.2024 to now (2 years 10 months)
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

from 10.2022 to 03.2023 (6 months)
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

Education

Lviv Polytechnic National University

Master’s Degree in Information Systems and Technologies, Львів
Higher, from 2023 to 2024 (1 year)

Lviv Polytechnic National University

Bachelor’s Degree in Cyber Security, Львів
Higher, from 2018 to 2023 (5 years)

Additional education and certificates

Python

2020, 32 години
Certificate

Data Analytics Engineering Training, EPAM

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

Knowledge and skills

• 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

Language proficiencies

• Ukrainian — fluent
• English — average

Disability

3rd degree.
Цукровий діабет. Обмежень щодо роботи не маю.

Additional information

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.