Ayushman Mishra

About Ayushman Mishra

Hi there, I am Ayushman I’m a Data Engineer with 3+ years of experience turning…

Experience

1. Project Engineer

   Wipro

   May 2022 — Present · Bengaluru, IN

   Developed and optimized complex Snowflake SQL queries using advanced techniques like window functions, recursive queries, and query profiling for performance bottleneck analysis.•Designed multi-cluster virtual warehouses with autoscaling for performance and cost efficiency.•Implemented materialized views with cost-benefit analysis, improving data refresh speeds for reporting use cases.•Used micro-partitioning and clustering keys to boost query performance by over 35% in large datasets.•Created Snowpipe pipelines for real-time data ingestion from Azure Blob Storage, utilizing Named Stages and direct loading methods.•Developed and deployed data pipelines for automating data integration and transformation tasks using Azure Data Factory.•Leveraged Time Travel and Zero Copy Cloning for data recovery and safe testing in production-like environments.•Integrated multiple data sources (SQL Server, Azure SQL, CSVs) and processed them via Azure Data Factory into Snowflake.•Implemented data transformations using mapping data flows, performing operations such as aggregations, filtering, and joins.•Developed an interactive dashboard using transaction and customer data from a SQL database, to provide real-time insights.•Shared actionable insights with stakeholders based on dashboard findings to support decision-making processes.•Handson experience on AppInsights to investigate customer\'s issue regularly.•Create Kusto queries as to generate the reports as per the requirements.•Worked on Azure key vaults for certificate renewals for application and service fabric clusters.•Handson experience using microsoft service bus explorer for deadletter, topics and queue monitoring.