Sachin Kumar Pal

Python Developer

About Me

  • Adept Python Developer and Data Engineer with a proven track record at SBS Global and Marlabs Innovation pvt. ltd, I excel in automating and transforming data processes using Python, AWS, and ETL.
  • My expertise in data analysis and collaborative change management has significantly enhanced operational efficiency and data-driven decision making.

Work Experience

Python Developer
- SBS Global
  • Developed Python scripts to automate data processing tasks.
  • Designed and developed RESTful APIs with Flask.
  • Played a key role in bug fixing for existing bots, ensuring smooth operation and efficiency.
  • Actively participated in the transitioning and change management team, ensuring seamless transition of bots to the support team and complete automation of prebuilt bots.
  • Created multiple ETL scripts to extract data from different SAP instances and transform them using pandas, and generated reports in an Excel file.
12/2023 - 11/2024
Bangalore, India
Associate Software Engineer
- Marlabs Innovation pvt. ltd
  • The project's high-level scope was to process the data on a daily basis in a cloud environment using AWS services like S3, Glue, Lambda, and Athena.
  • Receiving the data on a daily basis in the S3 bucket and processing it on the go.
  • I build the Glue crawler to crawl over the raw bucket and create Glue tables whenever we receive the data, creating the Glue ETL to transform the data and store it back to the transformed Glue tables.
  • I worked for about 1.10 years on the Tracfone project, where I was responsible for creating glue crawlers and writing ETL.
  • Part of the Team where we designed Data Migration Utility, which is an ETL Tool, to migrate data from different databases and store it in a raw S3 bucket.
  • Created a Glue crawler to crawl over the raw S3 bucket and create Glue tables.
  • Built Glue ETL pipelines to process the data by removing null values, renaming columns, and deriving new columns from the raw data.
  • Stored the transformed data in the Glue catalogue tables.
  • Then, created another Glue crawler to crawl over the transformed tables and store the transformed data in the cleansed S3 bucket.
  • Used Athena to run ad hoc query over the transformed Glue Tables.
12/2021 - 10/2023
Bangalore, India

Education

Bachelor of Technology: Electronics and Communication Engineering
01/2019 -
Technocrats Institute of Technology And Science