Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vijaya Lakshmi

Bengaluru

Summary

Accomplished Data Engineer with expertise in Snowflake and PL/SQL, working at Carelon Global Solutions. Successfully designed automated ETL pipelines and optimized data processes, enhancing performance and data integrity. Proficient in AWS tools and data quality management, demonstrating strong analytical skills and a commitment to delivering high-quality solutions in healthcare and insurance domains.

Overview

6
6
years of professional experience

Work History

Data Engineer – Snowflake & PL/SQL Developer

Carelon Global Solutions India
Bengaluru
01.2023 - Current
  • Designed and implemented end-to-end data pipelines using Snowpipe, COPY/PUT commands, and both Internal and External Stages to ingest provider data from AWS S3 into Snowflake.
  • Utilized Streams & Tasks for real-time anomaly detection and change data capture (CDC), with automated workflows feeding into the DART system for updating the SPS database.
  • Leveraged Time Travel and Zero-Copy Cloning to enable data versioning, rollback, audit recovery, and efficient environment duplication for QA/testing without additional storage costs.
  • Optimized query performance and storage efficiency through Snowflake’s Micro-Partitioning, clustering strategies, and metadata pruning on large datasets.
  • Created advanced stored procedures, UDFs, and parameterized SQL scripts to automate DQ checks, anomaly aging, and resolution workflows.
  • Automated ETL pipelines using AWS Glue, Lambda, and EMR for scheduled transformations, with additional scripting support via SnowSQL, Python scripts.

PLSQL Developer

Carelon Global Solutions India
Bengaluru
01.2021 - 01.2023
  • Developed complex PL/SQL procedures, functions, packages, and triggers to support data migration, transformation, and consolidation of provider data across multiple regional systems.
  • Designed and optimized SQL queries and stored procedures for large-scale batch processing, ensuring data quality and consistency during migration to the centralized SPS platform.
  • Participated in data profiling and validation to identify anomalies, duplicates, and mismatches in legacy systems, contributing to accurate and clean data movement.
  • Collaborated closely with data architects and business analysts to understand data mapping logic and translate business rules into efficient PL/SQL logic.
  • Assisted in building migration scripts and utilities to automate the ETL process and monitor performance during high-volume loads.
  • Conducted unit testing and peer code reviews to ensure optimal performance, adherence to standards, and minimal defects in production.
  • Used exception handling, cursors, and bulk processing techniques to enhance performance and reliability in data migration routines.
  • Maintained proper documentation of all PL/SQL code and participated in SIT/UAT support, resolving migration-related issues in coordination with QA and business teams.

PLSQL Developer

Patra India Pvt. Ltd.
Bengaluru
01.2020 - 01.2021
  • Developed and maintained PL/SQL procedures and functions to manage policy creation, renewals, and claims for automobile insurance based on vehicle type and business rules.
  • Collaborated with business users to understand daily policy term updates and translated requirements into effective database logic.
  • Wrote and optimized SQL queries for data validation, extraction, and updating of policy and customer records.
  • Implemented data integrity checks and security rules to ensure accurate and confidential handling of insurance information.
  • Supported testing and issue resolution during user acceptance and production rollout phases.

Education

Bachelor of Arts - Sociology

Bangalore University, Bangalore
Bangalore India

Skills

  • Databases & SQL: Snowflake, Oracle PL/SQL, SQL
  • Data Integration: Snowpipe, Streams & Tasks, COPY/PUT, Internal & External Stages
  • Snowflake Features: Time Travel, Zero-Copy Cloning, Micro-Partitioning, Data Unloading
  • Cloud Tools: AWS S3, Glue, Lambda, EMR
  • Scripting & Tools: SnowSQL, Python (basic), SQL Developer, Git
  • Data Quality: Data Profiling, DQ Dashboards
  • Domain: Healthcare (SPS, Elixir-P), Insurance (CIAS – Policy, Claims, Renewals)

Timeline

Data Engineer – Snowflake & PL/SQL Developer

Carelon Global Solutions India
01.2023 - Current

PLSQL Developer

Carelon Global Solutions India
01.2021 - 01.2023

PLSQL Developer

Patra India Pvt. Ltd.
01.2020 - 01.2021

Bachelor of Arts - Sociology

Bangalore University, Bangalore

Similar Profiles

CREATE PROFILE
Vijaya Lakshmi