Data Engineer/Integration Developer

12/2021 – 12/2022

Managed projects for the development and implementation of integration solutions, ETL tools (based on SSIS);
Wrote integration requirements, developed functional and technical specifications for interfaces, and ETL packages;
Carried out documentation and transfer to operation of the ETL, interacted with IT support to identify problems, eliminates defects identified during the operation of the ETL;
Admistrated SQL Server
Managed and facilitated migration of DWH infrastructure
Develop data landscape (systems, data mapping, data pipelines, data flow diagrams)
Support and document the changes (data pipelines, data mapping) in data knowledge hub of my team
Prepared Airflow platform to migrate to open-source data flow technologies

Microsoft SQL Server Integration Services (SSIS), SQL, C#, Python

1/2021 – 12/2021

Communicated with the data science team to ascertain their data needs;
Communicated with owners of data sources;
Calculate the metrics of the mobile application service, funnels;
Stratified datasets for A/B testing
Build datamarts for A/B tests based on mobile app clickstream data;
Wrote ETL (SQL, Python) for loading external data into DWH;
Implemented automated launch (SSIS, Python);
Prepared a description of metrics and showcases on Confluence.

Microsoft SQL Server Integration Services (SSIS), Microsoft SQL-Server (MS SQL), SQL, Python

12/2019 – 1/2021

Designed and developed a DWH on the MS SQL Server platform;
Designed and developed OLAP cubes on the MS SSAS platform;
Analyzed external information systems and developed integration packages (MS SSIS) for data transfer to the DWH;
Developed reporting forms for business users (MS SSRS);
Updated the data in the DWH.

Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL-Server (MS SQL), SQL, Python