SUMIT KUMAR NAYAK
Bangalore
Summary
Detail-oriented Software QA Engineer with 3+ years of experience in Manual, API, Mobile, Database and ETL Testing across Health and Logistics domains. Experienced in requirement analysis, test case design, execution, and defect tracking in Agile environments. Strong expertise in end-to-end ETL testing, including source-to-target validation, data reconciliation, and business rule testing. Hands-on experience validating fact and dimension tables, SCD Type 1 & Type 2, and ETL transformations. Proficient in SQL for complex joins, aggregations, and data comparisons. Solid understanding of OLTP vs OLAP systems, Star and Snowflake schemas, and data mart validation. Skilled in data quality checks, batch processing, incremental/full loads, and job failure analysis.
Overview
3
3
years of professional experience
Work History
Manual QA Engineer
Test Yantra Software Solutions Pvt. Ltd
12.2025 - Current
- Presently working as a Manual QA Engineer in Test Yantra Software Solutions Pvt. Ltd, Bangalore (DEC 2025 – Present).
Manual QA Engineer
Jeta software solution pvt Ltd
09.2022 - 11.2025
- Previously worked for 3 years in Jeta software solution pvt Ltd, Hyderabad (Sept 2022-Nov 2025) as a designation of Manual QA Engineer.
- Worked under Agile methodology, attending daily standups and sprint reviews.
- Designed and executed test cases, test plans, and test data for functional validation.
- Proficient in using Microsoft Excel for providing detailed QA status reports & graphs.
- Proficient in creating bar graphs, pie charts and also pivot tables for QA reporting.
- Conducted Smoke, Regression and System testing for new and existing features.
- Performed ETL Testing to Extract data ,transformation & loading to data warehouse.
- Conduct record validation & data consistency between source & Target ETL system.
- Tested SCD Type 1 and Type 2 to validate accurate handling of current and historical data
- Logged and tracked defects using JIRA, assigning appropriate severity and priority.
- Conducted API Testing using Postman with request chaining and status code.
- Experience in Android apps through ADB commands, Charles Proxy.
Education
Bachelor of Technology (B.Tech) -
Hooghly Engineering & Technology College
Skills
Manual Testing: Jira, Zephyr, Excel
API Testing: Postman
Database: SQL
Mobile Testing: Android studio & Charles proxy
Test Management: Test Cases, Test Plans, Test Scenarios
ETL Testing: Extraction, Transformation and Loading to perform business operation as per business requirement
Timeline
Manual QA Engineer
Test Yantra Software Solutions Pvt. Ltd
12.2025 - Current
Manual QA Engineer
Jeta software solution pvt Ltd
09.2022 - 11.2025
Bachelor of Technology (B.Tech) -
Hooghly Engineering & Technology College
Disclaimer
SUMIT KUMAR NAYAK PLACE: BANGALORE DATE: 2026-01-13