BHAGYODAY GHARADE
DATA ENGINEER
Pune
Summary
Results-driven Data Engineer with over 4 years of specialized experience in developing robust ETL pipelines that enhance data processing efficiency and enable insightful analytics. Expertise in designing and implementing scalable solutions utilizing AWS services, including S3, Glue, EMR, Redshift, Athena, RDS, EC2, Lambda, SQS, and SNS. Proficient in SQL, Python, and Spark for effective data manipulation and analysis, with a strong background in leveraging Snowflake and Redshift for cloud data warehousing solutions. Skilled in orchestrating ETL workflows using Airflow to ensure seamless data integration and delivery.
Overview
5
5
years of professional experience
Work History
Senior Associate
Synechron
10.2024 - 08.2025
- - Designed and managed end-to-end data pipelines using AWS Glue, EMR, and Redshift, S3 to handle large-scale data ingestion and transformation.
- - Implemented Airflow DAGs for orchestrating complex ETL workflows and ensuring high availability.
- - Automated deployment processes with Jenkins and managed configuration using YAML files.
- - Developed scalable ETL processes to integrate data from multiple sources into Redshift, optimizing performance and cost.
- - Enhanced monitoring using CloudWatch and fine-tuned query performance for analytics workloads.
- Medibank is one of Australia’s largest private health insurers, offering health coverage and related services to millions of customers nationwide. It provides a wide range of health insurance products, preventive health programs, and digital health solutions. Medibank also manages health services for government contracts and supports innovative care initiatives to improve community health outcomes.
- Client – Medibank
Senior Software Engineer
STARLITE INFOTECH LIMITED
12.2020 - 09.2024
- Collected business requirements and analyzed source data to identify historical sales data and market trends.
- Extensively worked on data obtained from various sources like structured (e.g., Relational Database), semi-structured (JSON, XML), and unstructured (e.g., Text data)
- Implemented ETL pipeline to ingest the data from various data sources, transform data using Glue, and load transformed data into client-specific Snowflake tables.
- Extensively used various Glue components like Data catalog and Crawlers along with Cloud Watch logs to monitor the running job.
- Experience in utilizing Glue connections to enable seamless data integration and transformation processes in AWS cloud environments.
- Loaded data from S3 into Snowflake tables, ensuring efficient data management and analytics capabilities.
- Loaded data from S3 into Redshift tables, ensuring efficient data management and analytics capabilities using copy command.
- Holt Renfrew's e-commerce platform offers a curated selection of luxury fashion, beauty, and lifestyle products from renowned designer brands. Shoppers can explore an extensive range of high-end clothing, accessories, cosmetics, and home goods with the convenience of online shopping.
- Enhanced software functionality by identifying and resolving complex technical issues.
- Developed scalable applications using agile methodologies for timely project delivery.
- Client - Holt Renfrew
- Client - Enbridge
- Client - Metro Inc
Education
Bachelor’s of Engineering -
Dr. D Y Patil’s Ramrao Adik Institute of Technology
Skills
- Relational database expertise: MySQL and Oracle
- Programming Language/Scripting : Python, SQL, PySpark
- Versioning Tool : Github
- Ticketing Tool : Jira
Orchestration Tool: Airflow
AWS Services : EMR, Glue, Redshift, S3, Athena, EC2, Lambda, RDS, SNS, SQS, CloudWatch, IAM, CloudTrail
Data Warehouse : Snowflake, Redshift
Timeline
Senior Associate
Synechron
10.2024 - 08.2025
Senior Software Engineer
STARLITE INFOTECH LIMITED
12.2020 - 09.2024
Bachelor’s of Engineering -
Dr. D Y Patil’s Ramrao Adik Institute of Technology