Summary
Overview
Work History
Education
Skills
Certification
Project 1
Project 2
Timeline
Generic

Bala Kishore Kotyada

Visakhapatnam

Summary

Azure Databricks Data Engineer with hands-on experience building scalable ETL pipelines and data models using PySpark, Spark SQL, and Delta Lake. Databricks Certified Data Engineer Associate, skilled in handling large datasets, implementing SCD Type 1 and 2, optimizing performance, and delivering end-to-end solutions using the Medallion architecture on ADLS Gen2.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Engineer II

OneSubsea (Schlumberger)
Pune
02.2022 - 07.2025
  • Built scalable data pipelines in Azure Databricks using PySpark and Delta Lake.
  • Implemented Medallion architecture for raw to refined data flow.
  • Designed and applied SCD Type 1 and Type 2 on dimension tables.
  • Improved query performance by using partitioning and Z-Ordering.
  • Built Databricks SQL queries for Power BI reports used by stakeholders.

Engineer II

TechnipFMC
Hyderabad
07.2019 - 11.2020
  • Developed robust FEA automation scripts tailored for various analysis types including fatigue, lifting, and impact.
  • Modularized code for reusability across multiple projects and simulation workflows.
  • Collaborated with design and QA teams to integrate automated outputs into standardized reporting and documentation.

Engineer I

Cameron (Schlumberger)
Coimbatore
09.2016 - 06.2019
  • Developed Python scripts to automate repetitive Finite Element Analysis (FEA) tasks, reducing manual processing time.
  • Automated pre-processing workflows including model setup, mesh generation, boundary condition assignment, and load application in ANSYS/Abaqus.
  • Created post-processing tools to extract stress, strain, and deformation results, and generate standardized Excel and image reports.
  • Integrated custom macros and Python APIs to streamline bolt modeling, fatigue evaluation, and lifting assessment procedures.

Education

Postgraduate Diploma in Oil & Gas - Cameron (Schlumberger) - GET

Kumaraguru College of Technology
Coimbatore

Bachelor of Engineering - Mechanical

Karunya University
Coimbatore

Skills

  • Languages: Python, SQL
  • Big Data Technologies: PySpark, Delta Lake, Databricks
  • Adls Gen 2, Azure Data Factory
  • Databricks Tools & Features: Databricks Workflows (Jobs), Unity Catalog, Autoloader
  • Data Modeling: Star & Snowflake Schema, SCD Type 1 & 2
  • BI & Reporting: Power BI, Databricks SQL
  • Tools: Git, JIRA

Certification

Databricks Certified Associate Data Engineer

Project 1

Subsea Equipment Lifecycle

 Built an end-to-end Azure Databricks pipeline using Delta Live Tables (DLT) to track subsea equipment lifecycle, enabling automated ingestion, data quality checks, and Remaining Useful Life (RUL) analytics to support predictive maintenance and BI reporting. Subsea Spare Parts Forecasting | Azure Databricks, Created a scalable data pipeline in Azure Databricks using PySpark and Delta Lake to forecast spare parts demand and compute reorder points. Designed Snowflake schema and implemented SCD Type 1 & 2 to support reliable Power BI reporting and proactive inventory management.

Project 2

Subsea Spare Parts Forecasting

Created a scalable data pipeline in Azure Databricks using PySpark and Delta Lake to forecast spare parts demand and compute reorder points. Designed Snowflake schema and implemented SCD Type 1 & 2 to support reliable Power BI reporting and proactive inventory management.

Timeline

Engineer II

OneSubsea (Schlumberger)
02.2022 - 07.2025

Engineer II

TechnipFMC
07.2019 - 11.2020

Engineer I

Cameron (Schlumberger)
09.2016 - 06.2019

Postgraduate Diploma in Oil & Gas - Cameron (Schlumberger) - GET

Kumaraguru College of Technology

Bachelor of Engineering - Mechanical

Karunya University

Similar Profiles

CREATE PROFILE
Bala Kishore Kotyada