• 4+ years of experience in designing and developing database, data warehousing and Business Intelligence using Microsoft technologies Power BI, Excel, SSIS and SQL Server.• Developed SSIS packages, custom Azure Data Factory pipeline activities for on-cloud ETL processing.• Hands on experience in creating pipelines in Azure Data Factory V2 using activities like Move &Transform, Copy, filter, for each, Get Metadata, Lookup, Data bricks etc.• Excellent knowledge on integrating Azure Data Factory V2/V1 with variety of data sources and processing the data using the pipelines, pipeline parameters, activities, activity parameters, manually/window based/event-based job scheduling.• Working on creating Pipelines, linked services, blob storage containers, mapping data flows, activities (Data movement, data transform and control activities), datasets, triggers, Parameters, and variables.• Designing and maintaining dimensional data model with Star Schema having multiple facts and slowly changing dimension (SCD) tables.• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse anddata marts.• Worked on Data Warehouse design, implementation, and support (SQL Server, Azure SQL DB, Azure SQL Data warehouse, Teradata).• Extensive knowledge and Hands on experience implementing cloud data lakes like Azure Data Lake Gen1 and Azure Data Lake Gen2.• Providing Azure technical expertise including strategic design and architectural mentorship, assessments, POCs, etc., in support of the overall sales lifecycle or consulting engagement process.• Extracted and transformed SQL Server Source data to Azure data lake using Azure Data factory.• Good experience in Power Query, Power Pivot and Power View for creating the effective reports and dashboards in Power BI. • Demonstrated proficiency in Python, Spark and SQL, with experience in utilizing data science libraries for machine learning• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.• Strong experience in creating dashboards using Power BI visualizations.• Experience working on Custom Visualizations like Chiclet Slicer, Pulse Chart etc.• Expertise in working with Azure cloud platform and AWS services, including AWS Glue and EMR for data extraction and transformation.• Proficient in creating content packs and creating roles to implement Row Level Security (RLS) for the reports.
