K pavan Kumar

I’m an Azure Data Engineer with 6+ years of experience building BI applications, ETL pipelines, and data models using Azure services. I focus on turning diverse data sources into reliable, high-performance data platforms for analytics and self-service reporting.

At Infosol Technosol Pvt Ltd., I’ve developed Azure Data Factory pipelines to ingest and transform data into Azure cloud (ADLS). I’ve implemented exception handling with email alerts for pipeline failures/success, and used mapping data flows for visual data wrangling and transformation.

In my recent work (Unity Health Partners), I led the design and implementation of scalable data warehousing and data lake solutions on the Azure Data Platform. I built reusable, parameterized ADF pipeline templates, automated business reporting, and monitored/troubleshot pipeline performance to keep data flows dependable.

I also deliver analytics with Power BI dashboards and complex T-SQL (including CTEs and ranking functions) with performance tuning. Alongside ETL and orchestration (Get Metadata, Lookup, For Each, Wait, Execute Pipeline), I’ve worked with Azure streaming for sub-second results and ETL using Databricks with PySpark/Spark SQL.