Default profile banner
AB

Akshay Bothara

@akshaybothara

Application Developer at Nex-Gen Cloud Services

Pune, MH

https://www.linkedin.com/in/akshay-bothara-665974189/

Nex-Gen Cloud ServicesUniversity, India

Akshay Bothara is a Data Engineer with 2.7 years of experience specializing in Big Data analytics. He is proficient in developing robust data pipelines using Python, PySpark, and Snowflake, and has experience with AWS services like S3 and EMR. He is skilled in transforming data from various RDBMS and Kafka sources for advanced analysis and data warehousing.

Experience

Application Developer

Nex-Gen Cloud Services

•Jun 2020 - Present•Pune, MH

Developed python scripts to Import data into the S3 Buckets from various RDBMS (Oracle, SQL) using Pyspark. Built a data pipeline to import data from S3 and performed transformations for ingestion into snowflake tables using Pyspark. Implemented Data Validation and Quality Checks, and wrote snowflake DDL scripts to create tables. Created multiple spark jobs for extraction and transformation of data to load into Snowflake data warehouse. Wrote Snowflake Queries for Data Analysis to meet the business requirements. Wrote unit tests for Spark transformations and helper methods. Raised JIRA for Infrastructure and Platform issues.

Nex-Gen Cloud Services

•Oct 2019 - Apr 2020•Pune, MH

Worked on a data pipeline to collect third party insurance quote data from Kafka. Transformed collected data using pyspark for features extractions and predictions. Dumped the transformed data into S3 to support downstream services.

Education

University, India

Bachelor’s in Engineering

May 2019

Skills

Python
MySQL
Oracle
Snowflake
HDFS
Sqoop
Hive
PySpark
PySpark-SQL
Apache Kafka
Pandas
NumPy
Microsoft Power BI
Amazon Web Services (S3, EC2, EMR, Athena, RDS)
PyCharm
Jupyter Notebook
IntelliJ Idea
JIRA
Linux