Alex Liasun

Data Engineer @Stantec

Performed data gathering and gap analysis of source feeds, created dimensional and fact tables, created data dictionaries, taxonomies, created attribute transformations.Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services -(Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.Developed Azure Data Factory (ADF) ETL pipelines that process the data using different activities like copy activity, data flow activities, if activity, for each activity, web activity, look up, stored procs, set variable.