Summary
Overview
Work History
Education
Skills
Certification
Publications
Other Experiences
Timeline
Generic

Shambhavi Kaushik

Summary

  • Detail-oriented ETL Developer with a strong track record of designing, developing, and optimizing ETL processes.
  • Proficient in leveraging various ETL tools and technologies to streamline data workflows, ensuring data accuracy and consistency.
  • Adept at working with diverse data sources, performing complex data transformations, and implementing data warehousing solutions.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Software Engineer

Optum
Noida
09.2024 - Current
  • Enhanced ETL performance through advanced tuning techniques, such as pushdown optimization, parallel job design, and efficient memory management, resulting in up to a 60% reduction in job runtime.
  • Integrated ETL workflows with cloud-based platforms like Azure Data Factory to support scalable data storage and modern data architecture needs.
  • Led multiple ETL development projects, overseeing the entire lifecycle from requirements gathering to deployment, resulting in enhanced data integration capabilities.
  • Collaborated with data architects and business analysts to translate complex requirements into robust, scalable ETL solutions, tailored to healthcare analytics.
  • Piloted the adoption of parameterized job frameworks and reusable components to standardize ETL development and improve maintainability across the codebase.
  • Conducted impact analysis and regression testing for production changes, ensuring minimal disruption, and high data reliability.
  • Mentored junior developers on best practices in data modeling, transformation logic, and performance debugging.

Associate Software Engineer

Optum
Noida
07.2022 - 08.2024
  • Developed ETL solutions using DataStage, SSIS, and Informatica ETL tools to efficiently extract, transform, and load data from various sources into target systems.
  • Played a crucial role in the development team that achieved 99.9% accuracy in data migrations.
  • Collaborated with cross-functional teams to design and implement data integration solutions tailored to business requirements.
  • Oversaw the development and implementation of four high-complexity data migration projects within a 12-month period.
  • Implemented a new BI toolset, improving report generation speed by 50% and enhancing decision-making processes.
  • Authored and published multiple knowledge-based articles aimed at improving problem-solving capabilities, and fostering knowledge sharing within the team.

Education

B.tech - ECE

KIET Group of Institutions
Ghaziabad
06-2022

Skills

  • ETL tools: IBM DataStage Microsoft SSIS Informatica PowerCenter Azure Data Factory
  • DWH Tools: Snowflake Azure Synapse Analytics Google BigQuery
  • Database: MS SQL MySQL Oracle
  • BI tools: MS Power BI Tableau
  • Scheduling Tools: IBM Tivoli
    Workload Scheduler
  • Big Data Analytics Tools: Apache Hadoop Apache Spark Apache Kafka Apache Hive Apache HBase Azure Databricks
  • Cloud: MS Azure
  • Programming: Python Data
    Structures & Algorithms Object
    Oriented Programming

Certification

Azure Data Engineer Associate, Microsoft, 2024

Azure Data Fundamentals, Microsoft, 2023

Publications

  • Portable Air Conditioning, ICCE, 2020
  • Smart Car Parking Systems for Smart Cities, ICCE, 2020

Other Experiences

Marketing Intern, 10/2020 - 12/2020
Inventrom (Bolt IoT) - Remote

  • Assisted in developing and executing marketing strategies to increase brand visibility and engagement by 20%.

Timeline

Software Engineer

Optum
09.2024 - Current

Associate Software Engineer

Optum
07.2022 - 08.2024

B.tech - ECE

KIET Group of Institutions

Similar Profiles

CREATE PROFILE
Shambhavi Kaushik