Vaishnavi Korlepara
Snowflake Data Engineer / ETL Developer with approximately 5 years of experience in data integration, ETL development, SQL and production support. Experienced with Snowflake, SSIS, SQL Server, and IBM DataStage; skilled in data transformations, incremental loads, job monitoring, incident management, and ServiceNow Change Requests. Hands-on with source-to-target validation, root cause analysis, and SQL reporting.
Work History
Associate Software Engineer
5 Years 2 Months- Worked with Snowflake Streams, Tasks, stages, file formats, and incremental data processing workflows.
- Developed and optimized Snowflake data pipelines and SQL transformations for structured and semi-structured data.
- Provided Snowflake and SSIS production support by monitoring scheduled ETL jobs, investigating batch failures, validating loads, and coordinating job recovery.
- Participated in ServiceNow Change Requests (CRs), supporting impact analysis, ETL change testing, deployment coordination, and post-deployment validation.
- Created and tracked ServiceNow incidents, assessed business impact and priority, investigated production issues, and supported resolution against SLA requirements.
- Worked on IBM DataStage jobs involving Transformer, Join, Lookup, and Sort stages, source-to-target mappings, and data cleansing.
- Performed source-to-target reconciliation, analyzed missing and duplicate records, optimized SQL transformations, and addressed ad-hoc business data requests.
Education
Bachelor of Technology - COMPUTER SCIENCE AND ENGINEERING
BIEAP - Andhra Pradesh Board of Intermediate Education
Skills
Certification
Java and SQL Fundamentals (Udemy)
Projects
Boyd Gaming: 11/2021 - 12/2024
Data integration and cloud analytics support for a US gaming and hospitality organization.
Roles and Responsibilities:
- Designed Snowflake pipelines for structured and semi-structured data from Microsoft SQL Server and AWS S3.
- Used Snowflake Streams, Tasks, and Time Travel for change tracking, scheduling, and recovery support.
- Created stages, file formats, and external tables; used COPY INTO for S3 data ingestion.
- Optimized SQL queries and warehouse performance for reporting workloads.
- Supported Snowflake and SSIS production workflows, investigating job failures and data discrepancies and tracking incidents through ServiceNow.
- Worked with stakeholders on data models, access controls, ad-hoc queries, and data quality.
Control-M: 06/2024 - 11/2024
Control-M jobs were developed and managed using BMC Software to automate scheduling. Workflows were created to process data, and job execution was ensured to meet the needs of the business.
Apache NiFi: 08/2021 - 11/2021
Supported data movement from SQL databases to Snowflake using Apache NiFi.
Monsoon: 11/2024 - 01/2026
Retail data processing and transformation using Talend, including validation and cleansing of CSV, Excel, and XML sources.
Roles and Responsibilities :
- Developed and maintained Talend ETL jobs; handled missing values, invalid tags, and inconsistent formats.
- Scheduled and monitored ETL workflows using Talend Management Console.
- Validated business outputs and supported ETL performance improvements.
IBM DataStage: 04/2026 - Present
- Worked on IBM DataStage manufacturing part master ETL jobs to integrate material and part attributes from multiple source datasets.
- Reviewed Transformer, Join, Lookup, and Sort stage configurations, join keys, mapping specifications, and source-to-target transformation rules.
- Investigated DataStage job errors, missing records, and source-to-target mismatches; supported data validation and ETL issue resolution.