Prajita Chakraborty - Associate Software Engineer I - Carelon Global Solutions

Summary

Results-driven ETL Developer with 3.5 years of experience in designing enterprise-scale data warehouses and cloud-based ETL solutions. Expertise in advanced SQL, Snowflake, and AWS batch processing. Focused on cloud migration, incremental data loading, and performance tuning to deliver scalable data solutions in high-volume environments.

Overview

2

years of professional experience

1

Certification

Work History

Associate Software Engineer I

Carelon Global Solutions

Bangalore

07.2024 - Current

Project : Payment Innovation Management System (PIMS)
The Project deals with calculation of Value Based Care Payment to providers based on the performance of
the provider, it also gives incentive payments based on Star ratings and other attributes.
Designed, developed, and maintained enterprise-scale ETL pipelines using Snowflake.
Built complex SQL transformations including CTEs, window functions, and optimized
queries.
Led migration of on-premises data warehouse to AWS + Snowflake cloud architecture.
Managed incremental data loads and large-volume structured datasets.
Performed production support, root cause analysis, and performance optimization.
Collaborated with business and technical teams to translate requirements into scalable
data solutions.
Developed an understanding of complex jobs and data flows in the projects to help with design approach of new requirements.
Proposed automation solutions end to end for getting pre vs post records of the datasets and run each orchestration modules by automatic scheduled based jobs and generating the report based on the variances which helps maximizing efficiency and productivity, addressing security and
performance concerns, and creating reusable code components.
Monitored and fine-tuned the performance of data pipelines and Snowflake queries.
10.Modelling, DDLs, Data Migration, Data Testing & Validation.
Hands on experience with query optimization, performance tuning.
Experience with Data Modelling, DDLs, Data Migration, Data Testing & Validation
Hands on experience with cloud migration projects (Teradata to Snowflake)
Monitoring and analyzing data loads

Education

Bachelor of Technology - CSE

Cambridge Institute of Technology

Bangalore, Karnataka

06-2022

Skills

ETL & Data Warehousing: Snowflake, Dimensional Modeling, Incremental Loads

Database & SQL: Advanced SQL, Query Optimization, Performance Tuning

AWS Services: S3 buckets, Glue, Lambda, Step Function

GIT, Bit Bucket, CI/CD,

Spark

Teradata

Accomplishments

Annual Award – Cloud Migration Excellence (2024) for successful migration of
enterprise data warehouse modules from On-Prem to AWS + Snowflake cloud
Annual Award – Automation Excellence (2024) for implementing automation solutions
resulting in operational efficiency and cost savings.
Annual Award – Performance Excellence (2024) for consistent delivery and measurable
performance improvement.