Senior DW\ETL developer

Experience

Now I am looking for part time opportunity with availability up to 15-20h per week.

As a certified MCSA (Microsoft SQL Server 2012/2014)/Azure Data Engineer Associate with over ten years of versatile development experience, my focus has been on RDBMS and BI technologies.

Throughout my career, I have gained expertise in developing and implementing DWH and BI tools such as SQL Server 2008R2/2012/2014. I have also developed ETL processes using SSIS and Azure Data Factory, while leveraging my proficiency in T-SQL to develop and optimize stored procedures, views, and UDFs for maximum performance.

My BI development skills include proficiency in SSIS, SSRS, Talend and Azure data factory. In addition to my practical skills, I possess a solid understanding of relational databases and Data Warehouses.

Lastly, my English level is B1+

Skills

ETL SQL ssis T-SQL JSON SSRS XML REST API Snaplogic Git MS SQL Server Azure Data Factory Azure SQL MSSQL

Highlights

Create ETL solution using azure data factory that consumes data from a variety of sources like Azure SQL, csv, elasticsearch and store it to DW Azure SQL. After that, it sends the datasets to the client's sFTP. Delivery of dataset is fully configurable which means that we can define a list of datasets that will be delivered for a specific client.
As load performs once per day I've chouse serverless db. The overall price for client for ADF + Serverless DB is up to 150$ per month.

Creating SSIS solution which migrates data from CRM2011 to CRM 365. The problem was that we need to migrate about 40Gb of data and CozyRoc CRM destination provided very poor performance.
The solution used about 10 users and load data to a destination in chunks.
Overall performance was improved from about a month(rough estimation) to 8 hours.

Looking for

ETL project utilizing Azure data factory or SSIS. DB\DWH development