Aparna Tatavarthi
ETL Tester
Hornell,NY
Summary
As an ETL Tester, with 3.5 years of proven expertise in designing, developing, and maintaining robust Automation Frameworks for diverse products. I excel in ETL testing, automation of ETL processes on Azure and test data generation. Demonstrated expertise in all aspects of database management, including testing, implementation, migration, configuration, optimization, and maintenance. Adept at ensuring the seamless integration of testing processes within Agile and DevOps environments.
Work History
ETL Tester
UNITED HEALTH GROUP
New York
08.2022 - 04.2023
- Designed, created, maintained, and recorded automation scripts in Python and SQL for ETL and data validation procedures in Azure environments.
- Automated in-sprint testing frameworks were created and implemented using Azure Data Factory (ADF),Azure Databricks , and Azure Data Lake (ADLS) to facilitate data integration and ETL operations.
- Methodologies for automated testing have been continuously evaluated, and optimized to ensure consistency with Azure best practices and changing data pipeline procedures.
- Used GitHub for collaborative issue tracking and version control while managing, and documenting defects across several data sources.
- Worked together with developers, test engineers, and QA analysts to do root cause analysis and guarantee data integrity in PostgreSQL and Azure SQL databases.
- Managed the Agile POD team’s quality assurance efforts, concentrating on testing automation in Azure data engineering environments.
- Implemented data quality procedures and coding standards to ensure that testing in Azure DevOps CI/CD pipelines is highly consistent.
Test Specialist
IBM INDIA PRIVATE LIMITED
07.2021 - 03.2022
- Collaborated on the design and development of software applications, emphasizing ETL-related data engineering activities.
- Actively participated in code reviews and collaborated effectively with cross-functional teams.
- Utilized Azure Cloud services (Azure Storage, Azure Data bricks, Azure Data Factory) for ETL processes, emphasizing data ingestion, validation, and loading.
- Executed SQL queries for data accuracy, completeness, and transformations during the ETL process.
- Architected scalable and maintainable ETL test automation frameworks, emphasizing reusability, modularity, and extensibility.
- Worked collaboratively with Test Script Development and Test Data Management teams, focusing on data privacy, diversity, and synchronization requirements.
- Conducted monitoring and maintenance activities for ETL test environments, proactively addressing issues related to hardware, software, network, and data to ensure uninterrupted ETL process execution.
- Supported development and testing teams with a strong emphasis on high-quality ETL deliverables to meet defined quality SLAs.
Database Developer
MAGNUS TEK SOLUTIONS LLP
Hyderabad
07.2017 - 08.2019
- Engaged in the entire Software Development Life Cycle (SDLC), analyzing business requirements and understanding functional workflows from source to destination systems.
- Developed complex SQL queries to extract, transform, and load data from various sources(Flat files, MS Excel, MS Access, and DB2 )into the database, enabling efficient data retrieval for reporting and analysis.
- Integrated SQL queries into ETL tasks, troubleshooting and resolving database related issues to maintain seamless functionality, assisted in migration projects,
successfully migrating legacy data to new database platform. - Created and managed schema objects including tables, views, indexes, procedures, and triggers, ensuring Referential Integrity, and developed a data dictionary along with advanced queries, views, indices, and functions.
- Managed indexes, statistics, and optimized query performance using execution plans to enhance database efficiency.
- Additionally, involved in user and role management, database security, permissions, job management, and error log monitoring.
SQL Developer Intern
JNTUK
- Collaborated with a bike rental shop owner to extract and analyze business data.
- Developed SQL queries to answer key business questions, such as the total number of bikes owned by category. Monthly rental revenue breakdown.
- Optimized query performance and ensured data accuracy for business decision-making.
- Provided actionable insights to support business growth
and inventory management.
POSTGRADUATE RESEARCH
JNTUK
08.2020 - 09.2021
- Developing a medication takes about 10 years and 2.6 billion dollars due to the vast chemical space.
- Computational drug design using deep learning and RNNs trained on SMILES strings accelerates this process.
- Two models were created: one with a deep generative LSTM and another with latent space to improve data representation.
- A custom function adjusts the softmax activation temperature to optimize molecule generation.
Full Stack Developer Intern
Techurate Systems Private Limited
11.2019 - 10.2020
- The project "2ru-Info-app" focuses on digitizing analog data to lay the foundation for a paperless future.
- As a Database Developer, the user contributed to building a strong and scalable data pipeline for handling large-scale data processing, optimizing storage solutions, and ensuring seamless transmission. They focused on maintaining and optimizing the largest database system to support the application's end-to-end details of individuals, ensuring data integrity and performance at scale.
- The goal was to create a comprehensive application that
provides end-to-end details of individuals, backed by the largest database system.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
Education
Masters - Data Science
Sep 2021
Bachelors - Chemical Engineering
08.2013 - 05.2017
Skills
- Databases: PostgreSQL, MSSQL Server, Oracle
- Programming Languages: Python, Pyspark, SQL, Spark-SQL
- Cloud Services: Microsoft Azure
- Services: Azure - ADLS Gen2,ADF, Azure SQL, Azure Data bricks, Logic Apps, Azure Functions, Key-Vault
- Orchestration Tools: ADF, AirFlow
- Methodologies: Agile, Scrum
- DevOps: GitHub
- Agile Tools: Azure DevOps
- Operating Systems: Windows, Linux
Timeline
ETL Tester - UNITED HEALTH GROUP
08.2022 - 04.2023
Test Specialist - IBM INDIA PRIVATE LIMITED
07.2021 - 03.2022
POSTGRADUATE RESEARCH - JNTUK
08.2020 - 09.2021
Full Stack Developer Intern - Techurate Systems Private Limited
11.2019 - 10.2020
Database Developer - MAGNUS TEK SOLUTIONS LLP
07.2017 - 08.2019
Rajiv Gandhi University of Knowledge Technologies India - Bachelors, Chemical Engineering
08.2013 - 05.2017
SQL Developer Intern - JNTUK
Jawaharlal Nehru Technological University - Masters, Data Science
Work Preference
Work Type
Full TimePart TimeContract WorkLocation Preference
On-SiteRemoteHybridImportant To Me
Career advancementWork-life balanceCompany CultureHealthcare benefits401k matchAdditional Information
I have designed and implemented automation frameworks in Azure environments with great success, drawing from my vast experience in database development and ETL testing. I have made use of technologies such as Azure Data Factory, Azure Data Lake, and Databricks to guarantee efficient data transformation and validation. I have greatly improved report production speeds and query efficiency by optimizing ETL pipelines and database performance using my SQL and Python skills. at order to preserve data accuracy and stability, I am also skilled at automating testing and migrating data between cloud platforms and CI/CD pipelines.
Languages
English
Bilingual or Proficient (C2)