Navyatha Marapureddy
Dallas,USA
Summary
ETL and Big Data Testing professional with 7+ years of experience validating complex data pipelines and ensuring data accuracy and integrity across large-scale systems. Skilled in SQL, data warehousing, Big Data technologies including Hadoop, HDFS etc. Experienced in creating comprehensive test plans, developing high-quality test artifacts, and working in Agile environments. Expertise in defect and test management tools like Jira and HP Quality Center, with a proven ability to optimize testing processes and deliver reliable solutions. Familiar with Python for basic data validation and automation.
Overview
8
8
years of professional experience
Work History
Test Engineer - ETL Testing
Molina Health care (Infinite Computer Solutions)
Plano, USA
11.2022 - 05.2024
- Company Overview: Molina Healthcare contracts with state governments and serves as a health plan, providing a wide range of quality health care services to families and individuals who qualify for government-sponsored programs, including Medicaid and the State Children's Health Insurance Program (SCHIP).
- Performed functional, ETL testing, system integration, UAT, and regression testing.
- Wrote extensive SQL queries for back-end testing, checked the data flow from the front end to the back end, and used SQL queries to extract the data from the database.
- Validated data processing workflows using Hadoop and Hive to ensure accurate handling and analysis of large datasets.
- Tested HiveQL queries to verify correct data extraction, transformation, and reporting from Hadoop, ensuring data integrity and correctness in reporting outputs.
- Designed, scheduled, and executed test plans within the timeframe.
- Detected defects and participated in triage meetings to communicate and prioritize defects.
- Understanding business requirements documents and the technical specification.
- Developed test plans and test cases based on functional specifications and design documents.
- Executed test cases based on the requirements, and performed interface testing, user acceptance testing (UAT).
- Documented the test results, and reported the status of assigned test tasks and issues to the project QA lead.
- Reported software defects in JIRA, and interacted with the developers to resolve technical issues.
- Attending grooming, planning, and daily standup meetings.
Test Engineer - ETL Testing
All State (Infosys)
Mysore, India
02.2019 - 02.2022
- Company Overview: Recognized for diverse offerings, Allstate serves individual and business insurance needs with auto, home, life, and business products.
- Executed ETL testing activities for Ab Initio-based data integration processes.
- Conducted an in-depth analysis of Ab Initio graphs to identify potential issues.
- Complete responsibility for Test Plan creation, Test Case creation, and Test execution.
- Conducted thorough tests encompassing file-to-table, file-to-file, and table-to-table scenarios.
- Regularly communicated with onsite leadership on scrum updates, challenges, and blockers.
Test Engineer - ETL Testing
Apple (Cognizant)
Bangalore, India
04.2017 - 02.2019
- Company Overview: CORE QA is a data migration project where we are migrating the data from the Oracle environment to the Big Data Hive and Teradata environment.
- Performed data migration from Teradata to Big Data (BD1 and HRX). Specialized in ETL testing on data warehousing applications using Hadoop and Hive.
- Extensively used Platinum tool for test suite creation and for validation for ETL validations.
- Adept at writing SQL queries to ensure thorough validation of the test requirements.
- Demonstrated effective leadership in handling defect triage meetings.
- Involvement in functional, regression, end-to-end, and UAT testing.
- CORE QA is a data migration project where we are migrating the data from the Oracle environment to the Big Data Hive and Teradata environment.
Program Analyst - ETL Testing
Loblaw (Cognizant)
Bangalore, India
09.2016 - 04.2017
- Company Overview: Loblaw Companies Limited, Canada’s largest food distributor, launched the Brooklyn Project to consolidate backend systems for its loyalty programs: PC Plus™ and Shoppers Optimum®. The project involves implementing a new loyalty application, Eagle Eye Air (EE), and a Hadoop data hub for operations and reporting. The data hub serves as the central repository for ETL processes, ensuring accurate data integration and reporting for the loyalty programs.
- Developed extensive test cases for ETL testing.
- Testing of the ETL system developed using Informatica.
- Execution of workflows using UNIX, and validating the data as per transformation logic.
- Involved in writing the SQL queries, as per the test requirements document, for ETL testing.
- Responsible for sharing the test evidence and defects report with on-site.
- Involved in reporting defects and attending defect review meetings.
- Creating and sending daily status reports and weekly status reports.
- Participating in daily status calls.
- Involved in end-to-end and SIT testing.
Education
Bachelor of Engineering - Computer Science Engineering
JNTU
India01.2015
Skills
- ETL Testing
- Functional Testing
- Hadoop
- Hive
- HDFS
- Big Data
- SQL
- TeraData
- MySQL
- Oracle
- Informatica (910 & 1011)
- Python
- Jira
- Unix
- Agile
- Waterfall model
Timeline
Test Engineer - ETL Testing
Molina Health care (Infinite Computer Solutions)
11.2022 - 05.2024
Test Engineer - ETL Testing
All State (Infosys)
02.2019 - 02.2022
Test Engineer - ETL Testing
Apple (Cognizant)
04.2017 - 02.2019
Program Analyst - ETL Testing
Loblaw (Cognizant)
09.2016 - 04.2017
Bachelor of Engineering - Computer Science Engineering
JNTU
Similar Profiles
Taylor BonyadiTaylor Bonyadi
Quality Assurance Analyst at Digital and Omni-Channel | Infinite Computer Solutions, Molina Healthcare IncQuality Assurance Analyst at Digital and Omni-Channel | Infinite Computer Solutions, Molina Healthcare Inc
Amanda LopezAmanda Lopez
Call Center Customer Service Representative at Infinite Computer Solutions - Subcontracted through Molina HealthcareCall Center Customer Service Representative at Infinite Computer Solutions - Subcontracted through Molina Healthcare
Prerana KarkiPrerana Karki
IT System Analyst at Infinite Computer SolutionsIT System Analyst at Infinite Computer Solutions