Akrati Rawat

Qlik to Azure Migration: Involved in the Qlik to Azure migration project, utilizing Azure Databricks for data transformations and implementing the Medallion Architecture, focusing on loading data into the Silver Layer. Optimized data processing using left-anti join, partitioning, and schema tuning, reducing processing time by 15%. Mars PPA Scaling: Built and maintained daily data refresh pipelines for multiple countries using Azure Data Factory, ensuring timely and reliable data ingestion. Performed daily data transformations based on business requirements to standardize and prepare data. Developed an EDA (Exploratory Data Analysis) scorecard to analyze data quality, trends, and key project metrics. Implemented a Data Quality Framework to ensure data reliability and validation across pipelines. Supported ad-hoc requirements from stakeholders, delivering quick solutions to address evolving business needs. Materials Migration: Designed an automated testing framework to validate ETL pipelines and data migration processes. Validated source-to-target data, ensuring data consistency between source and destination tables. Conducted column-level validation to verify correct data mapping an