SUSHMITA BODANAPU

Data Engineer

Morrisville, North Carolina, United States6 yrs 10 mos experience

Highly Stable

Key Highlights

Over 7 years of experience in data engineering.
Expert in building end-to-end data pipelines.
Proficient in multiple cloud environments including Azure and AWS.

Stackforce AI infers this person is a Data Engineer with expertise in cloud-based data solutions and analytics.

Contact

sushmitabodanapu@gmail.com LinkedIn

Skills

Core Skills

Data EngineeringCloud Computing

Other Skills

ADFADLSAWSAWS CloudFormationAWS GlueAWS LambdaAccess ControlAgile MethodologiesAirflowAmazon AthenaAmazon AuroraAmazon CloudWatchAmazon EC2Amazon Elastic MapReduce (EMR)Amazon Kinesis

About

Over 7+ years of progressive IT experience in architecting, developing, and optimizing data solutions across multiple cloud environments (Azure, AWS, and Databricks). Expertise in building end-to-end data pipelines, transforming raw data into actionable insights, and driving data-driven decisions

Experience

6 yrs 10 mos

Total Experience

3 yrs 5 mos

Average Tenure

Current Experience

Mirion

Data Engineer

Feb 2025 – Present · 1 yr 4 mos · United States · Remote

Developed ETL workflows in Azure Data Factory (ADF) to integrate data from SQL Server, SAP, CRM, and REST APIs into Azure Synapse Analytics and Azure SQL Data Warehouse.
Built real-time ingestion pipelines with Databricks, optimizing Delta Lake with partitioning, lifecycle management, and Parquet formats to reduce costs and improve query performance.
Managed Azure Blob Storage and ADLS designing scalable ingestion pipelines for raw data collection.
Implemented Unity Catalog for centralized metadata, access control, and auditing.Enhanced data quality with Delta Live Tables (DLT) for automatic validation, lineage tracking, and auditing.
Designed optimized data models and migrated legacy warehouses to Azure Synapse Analytics.
Improved performance in Synapse Analytics with indexing, partitioning, and materialized views.
Used Kusto Query Language (KQL) in Azure Monitor & Log Analytics for real-time log analysis.
Automated data quality checks in ADF to ensure accurate business reporting.
Implemented CI/CD pipelines using Azure DevOps to automate ADF, Databricks, and Synapse SQL resource deployments.
Architected ETL pipelines using AWS Glue, Glue Crawlers, Redshift, S3, and Lambda, automating data ingestion, transformation, and loading.Developed AWS Glue Spark Jobs with PySpark and EMR, reducing processing time by 30% for faster analytics.
Utilized AWS Glue Crawlers to automate schema discovery and cataloging, improving data governance.Designed Amazon MSK (Kafka) clusters for real-time data streaming from PostgreSQL to S3 for scalable data lake storage.
Orchestrated pipelines using Apache Airflow (MWAA), integrating with AWS Glue, Lambda, Redshift, S3, and SNS for automated workflows.Integrated Lambda with EventBridge for real-time data transformation, reducing latency and improving analytics.
Used Amazon RDS Aurora and DynamoDB for transactional and NoSQL storage. Implemented automated data validation in AWS Glue ETL jobs with Python/PySpark for error handling.

Azure Data FactorySQL ServerSAPCRMREST APIsAzure Synapse Analytics+23

Tata consultancy services

Data Engineer

Dec 2021 – May 2024 · 2 yrs 5 mos

AWS: S3, Glue, Lambda, Redshift, Athena, EMR, Kinesis, Step Functions, CloudWatch
Azure: ADF, Synapse, Databricks, Event Hubs, Logic Apps, Azure Monitor
Databases & Warehouses: Snowflake, Redshift, Synapse, PostgreSQL, DynamoDB, CosmosDB
ETL Frameworks: Apache Spark, PySpark, Airflow, Kafka, Delta Lake
Programming: Python, SQL, Scala, Shell Scripting
IaC & DevOps: Terraform, CloudFormation, GitHub Actions, Azure DevOps, CI/CD

AWSS3GlueLambdaRedshiftAthena+30