• Worked closely with Business Analysts and Product Owners to gather the business requirements and propose the ETL solution using Azure Data Factory, T-SQL.• Developed ADF pipelines with multiple activities like metadata, lookup, copy, notebooks, USQL, web, webhook, hive, streaming, etc to support ETL and ELT architectural loads. • Installed, Configured, and maintained self-service Integration Runtimes to connect with ON premises SQL Servers, and migrated on-premises SQL data into Azure… Show more • Worked closely with Business Analysts and Product Owners to gather the business requirements and propose the ETL solution using Azure Data Factory, T-SQL.• Developed ADF pipelines with multiple activities like metadata, lookup, copy, notebooks, USQL, web, webhook, hive, streaming, etc to support ETL and ELT architectural loads. • Installed, Configured, and maintained self-service Integration Runtimes to connect with ON premises SQL Servers, and migrated on-premises SQL data into Azure SQL Database.• Worked on developing mappings using various ADF transformations like Source, Lookup, Filter, Expression, Aggregator, Joiner, Select, and Sink for transforming data. • Analyse, design, and build Modern data solutions using Azure PaaS service to support visualization of data. Understand the current Production state of the application and determine the impact of new implementation on existing business processes. • Created dynamic Linked Services and Datasets using Parameters to establish the connection from a variety of sources (on-prem and cloud) to pre-process and preview the data.• Automated control flow pipelines using triggers and used LogicApps to capture failover emails.• Created complex load views to load data into various Staging, slowly changing dimensions (SCD1, SCD2) Dimension and Fact tables, and Complex SQL scripts to retrieve data from multiple tables by efficient joins using partitioned and indexed columns.• Transformed data into user-friendly visualization to give business users a complete view of their business using Power BI features like DAX, Power Query, Interactions, bookmarks, etc. Show less