Akshay Oak
@Akshayoak08
Data Engineer at Bits in Glass
Pune, Maharashtra, India
Cloud-focused Data Engineer with 2.6 years of experience working on Azure-based data platforms. Strong expertise in Azure Data Factory, Azure Databricks, PySpark, SQL and Data Lake architectures. Adept at building and maintaining end-to-end data pipelines, ensuring data reliability, performance optimization, and seamless integration for reporting and analytics use cases.
Experience
Data Engineer
Bits in Glass
Contributed to a cloud-based Azure data platform using Azure Data Factory, Azure Databricks, and Azure Data Lake Storage (ADLS Gen2) to enable scalable data ingestion and transformation. Implemented the Medallion architecture (Bronze, Silver, and Gold layers) in Databricks to enhance data quality, governance, and analytics readiness. Integrated Azure Databricks notebooks with Azure Data Factory pipelines, enabling automated, parameterized, and scheduled data processing workflows. Built and optimized PySpark transformation pipelines to cleanse, enrich, and standardize data ingested from multiple enterprise source systems. Developed reusable Databricks notebooks and modular PySpark frameworks to improve ETL scalability, code maintainability, and development efficiency. Partnered with analytics and reporting teams to deliver curated, analytics-ready datasets consumed by Power BI and downstream reporting solutions.
Data Engineer
Inteliment
Streamlined data acquisition processes to improve data availability and reduce turnaround time for BI and ETL teams. Analyzed existing data pipelines to identify inefficiencies and dependencies impacting downstream reporting and analytics. Developed, optimized, and maintained SQL queries in Azure Synapse Analytics and SQL Server for extracting and transforming enterprise datasets. Designed and implemented SQL Server tables, views, and stored procedures to support Power BI and Power Apps integration. Resolved complex data issues related to real-time data ingestion, query performance, and latency in live application workflows. Implemented data validation and error-handling logic to ensure accuracy, consistency, and reliability of datasets. Delivered curated datasets and optimized SQL models enabling efficient Power BI dashboards and ETL pipelines. Collaborated with BI, ETL, application, and analytics teams to align data outputs with reporting and business requirements.
Education
Smt. Kashibai Navale College of Engineering, Pune
Bachelor in Engineering
Mechanical Engineering
Capstone Project - Autonomous Drone ICIIIST - 2023 paper published for “Autonomous Drone”
Sou. Venutai Chavan Polytechnic, Pune
Technical Diploma
Mechanical Engineering
Capstone Project - Dual Axis Solar Tracking System
Licenses & Certifications
Databrick Certified Data Engineer Associate
Databricks
Credential ID: 136861362
View CredentialDatabricks Certified Data Engineer Professional
Databricks
Credential ID: 162087587
View Credential