Akhila Sk

About Akhila Sk

Results-driven Data Engineer with 7 years of expertise in SQL-BI development, ETL…

Experience

1. Sr Data Engineer

   Kaiser Permanente

   Mar 2023 — Present · Peoria, IL, US

   Responsibilities:• Delivered 24x7 production support for health plan claims systems hosted on Azure, ensuring high availability and reliability.• Developed and optimized ETL pipelines using Azure Data Factory and SSIS to automate ingestion and transformation of healthcare claims data.• Built PySpark solutions on Azure Databricks for large-scale claims data processing.• Wrote and optimized complex T-SQL stored procedures and views for claims analytics and operational reporting.• Monitored production systems using Azure Application Insights and proactively resolved critical incidents.• Led root cause analysis for major incidents, collaborated with cross-functional teams, and implemented permanent fixes.• Designed dimensional data models for claims and healthcare analytics, improving query performance and reporting accuracy.• Automated production support tasks using PowerShell scripting and reduced system downtime by 20%.• Optimized query performance using advanced indexing, partitioning, and materialized views, significantly reducing latency in operational reporting.• Developed automated data pipelines with Azure Data Factory, AWS Glue, and Databricks for both real-time and batch processing, ensuring timely insights for predictive maintenance.• Integrated streaming data from IoT devices and ERP systems using Kafka and Kinesis, enabling real-time analytics and event-driven decision-making.• Established role-based access controls (RBAC) and implemented IAM policies across cloud platforms to secure sensitive production data.• Implemented advanced anomaly detection techniques using machine learning models on sensor and production data, enhancing predictive maintenance capabilities.• Automated CI/CD pipelines for database updates and ETL processes, reducing manual intervention and accelerating deployment cycles.