QA Engineer - Manual & ETL Testing
Resume:
**************@*****.***
Ahmedabad
Skills
Manual Testing, ETL Testing,
SQL, Database Testing,
Informatica, Oracle, MySQL,
Azure Data Factory (ADF), Azure
Data Lake, Snowflake, JIRA Bug
Tracking Tool, SDLC, STLC, Agile
Methodology, Test Case
Creation & Execution,
Functional Testing, Regression
Testing, Smoke Testing, Sanity
Testing, Data Validation,
Source-to-Target Validation,
Data Completeness, Data
Accuracy, Data Mapping
Validation, Defect Tracking,
Defect Retesting, Test
Execution, End-to-End Data
Validation
Willing to learn new skills and
technologies as per project
requirements.
Data Warehousing
Education
06/2012
Bachelor of Engineering:
I.T
Christian College of Engineering
& Technology
Neha Bharti
Professional Summary
QA Engineer with 5 years of experience in Manual and ETL Testing, skilled in functional testing, test case design, SQL-based data validation, and defect management. Experienced with Oracle, MySQL, Informatica, and JIRA, with strong knowledge of source-to-target validation, data completeness, accuracy, and consistency. Have working knowledge and hands-on exposure to Azure Data Factory, Azure Data Lake, and Snowflake for cloud-based data validation. Adept at applying testing best practices to deliver high-quality results and support successful project outcomes. Seeking a challenging role to leverage my testing skills and contribute to organizational success.
Experience
Ziff Davis - Quality Analysts 03/2021 - 02/2026
Personal Information
Gender: Female
Nationality: Indian
Marital Status: Married
Projects:
Quality Analyst – Ziff Davis (ETL + Cloud Testing) (January 2024 – February 2026), Project Title: – Retail Sales & Customer Analytics – Cloud Data Warehouse, Domain: Retail, Duration: January 2024 – February 2026, Technologies: AWS S3, AWS Glue, Snowflake, Informatica PowerCenter, Oracle, SQL, Toad, Jira, Excel, Project Description, The project involved building a cloud-based Retail Data Warehouse to analyze sales, customer and product data. Data was received from multiple sources such as Oracle databases, CSV/flat files and AWS S3. The data was processed through ETL pipelines and loaded into Snowflake for reporting and analytics. The project involved ETL and Cloud Testing to validate data movement, transformation, loading and data accuracy across cloud and database layers., Roles & Responsibilities, Analyzed BRD, TSD and Functional Specification documents to understand business requirements., Prepared test scenarios, test cases and test data for ETL and cloud data validation., Performed ETL testing to validate data extraction, transformation and loading., Validated source-to-target data mapping and transformation rules., Executed and monitored ETL workflows and validated successful data loading., Performed AWS S3 testing by validating source file availability, file name, file format, file count and file contents., Validated whether files were successfully received in the S3 bucket before ETL processing., Verified data movement from S3 to the ETL process and from ETL to Snowflake., Performed Snowflake testing by validating tables, schemas, record counts and transformed data using SQL., Executed SQL queries to validate Fact and Dimension tables in Snowflake., Performed source-to-target data validation for completeness, accuracy and data integrity., Validated record counts, NULL values, duplicate records, data types and mandatory fields., Validated incremental and historical data loads., Performed data reconciliation between source files, source databases and Snowflake., Performed positive, negative and regression testing for ETL pipelines., Logged, tracked and retested defects using Jira., Worked closely with developers and data engineers for defect analysis and resolution., Used Excel for test data preparation, data comparison and validation results., Prepared and shared daily testing status reports.
Quality Analyst (Manual Testing+ETL Testing) – Ziff Davis (December 2021 – December 2023), Project Title – United Natural Foods, Inc. (UNFI), Domain: Retail, Duration: December 2021 – December 2023, Technologies: Informatica PowerCenter, Oracle, Toad, SQL, Jira, HP ALM (Quality Center), Excel, Project Description, UNFI is a retail-domain project focused on developing a Sales Data Warehouse to analyze sales and profit data on a monthly and yearly basis. Data was integrated from multiple sources such as OLTP databases and flat files using Informatica PowerCenter and loaded into Fact and Dimension tables for reporting and analysis. The project involved both ETL Testing and Manual/Functional Testing to ensure data accuracy and application quality., Roles & Responsibilities, Analyzed BRD, TSD and Functional Specification documents to understand business and technical requirements., Prepared test scenarios, test cases and test data based on requirements., Executed test cases and verified actual results against expected results., Performed functional/manual testing based on business requirements., Performed ETL testing using Informatica PowerCenter., Executed Informatica workflows and validated successful data loading into target tables., Performed Source-to- Target (S2T) mapping validation., Validated transformation rules and business logic applied during the ETL process., Used SQL queries in Oracle/Toad to validate Fact and Dimension tables., Performed source-to-target data validation for data accuracy and completeness., Validated record counts, NULL values, duplicate records, data types and mandatory fields., Performed positive, negative and regression testing., Prepared and maintained test data using Excel., Logged, tracked and retested defects using Jira and HP ALM (Quality Center)., Worked closely with developers for defect analysis and resolution., Prepared and shared daily testing status reports., Participated in defect discussions and provided testing updates to the team.
Quality Analyst (Manual Testing) - Ziff Davis (March 2021 – Nov 2021), Project Title : Z-Shop – E-commerce Web Portal, Technologies: Jira,Excel,Chrome DevTools,Postman, Domain: E-commerce, Duration: March 2021- Nov 2021, Description:, "Z-Shop" is an e-commerce web application designed to enable users to browse, search, and purchase a variety of products online. The application included features like user registration/login, product search & filter, cart management, order placement, payment integration, and order tracking. The QA team was responsible for ensuring a smooth, bug-free user experience and validating all functional flows., Role & Responsibility, Analysed business requirements and created detailed test scenarios and test cases for functional and UI testing., Performed manual testing of modules like user registration, login, product search, cart, and checkout., Conducted cross-browser and responsive testing across different devices and browsers., Logged and tracked bugs using JIRA, coordinated with developers for resolution, and re-tested fixes., Validated payment gateway integration and ensured end-to-end data consistency after order placement., Participated in daily standups and requirement walkthroughs with the QA and development team., Prepared and shared daily/weekly test execution reports and defect status summaries with stakeholders., Contributed to User Acceptance Testing (UAT) support and post- deployment validation.
Disclaimer
I hereby declare that the above written particulars are true to the best of my knowledge and belief. Neha Bharti
Personal Detail
. Husband Name: Navjot Singh Rajput
Contact this candidate