Senior QA & Data Quality Analyst

Vinay Karanoore

Senior QA Tester & Data Quality Analyst

Bengaluru, Karnataka, India

Email: *******************@*****.*** Phone: +91-990******* LinkedIn: https://www.linkedin.com/in/vinay-karanoore-24785439a Professional Summary

Senior QA Tester & Data Quality Analyst with 5.6 years of experience in ETL/DWH validation, data pipeline testing, and automation for banking and retail domains. Proven expertise in source-to-target reconciliation, data integrity checks, and end-to-end testing across AWS and Snowflake environments. Skilled in SQL reconciliation, defect management, and Agile delivery, ensuring accurate, reliable, and business-ready data.

Core Skills

• Delivered 100% reconciliation accuracy across large-scale financial datasets.

• Automated SQL checks reducing manual effort by 30% and cycle time by 2 days.

• Improved defect closure rates by 20% and reduced post-migration defects by 15%.

• Achieved 95% defect closure within SLA using JIRA/Zephyr.

• Validated 17,000+ customer cases ensuring FCA remediation compliance. Tools & Platforms

• Informatica PowerCenter – automated ETL workflows, reduced mapping errors by 25%.

• Snowflake – optimized SQL queries, improved reporting speed by 40%.

• StreamSets – configured error handling, reducing pipeline failures by 20%.

• JIRA & Zephyr Squad – tracked 300+ defects, improved sprint predictability by 15%.

• DataGrip – reconciled schemas, reduced query execution time by 30%.

• Oracle & Teradata – validated ETL jobs, migrated datasets with zero data loss.

• AWS Athena & S3 – provisioned test data, queried large datasets securely. Professional Experience

Senior Software Tester / Testing Analyst

Tata Consultancy Services (TCS), Bengaluru

Client: Royal Bank of Scotland (NatWest Group)

Project: Amethyst Phase 3 – FCA S166 Remediation Program May 2022 – Dec 12, 2025

• Validated 200+ ETL pipelines across AWS S3/Athena and Snowflake, achieving 100% reconciliation accuracy.

• Automated SQL/Python reconciliation scripts, reducing manual effort by 30% and accelerating defect detection.

• Authored and executed 300+ SQL test cases, uncovering 25+ critical defects and improving release quality by 20%.

• Led SIT and migration cycles across 5 releases, reducing post-migration defects by 20%. 1

• Partnered with business analysts to validate 17,000+ customer cases, ensuring FCA remediation com- pliance.

Software Test Engineer

Walgreen Retailer – Data Analysis Project

May 2020 – May 2022

• Designed ETL workflows and validated sales data warehouse, improving reporting accuracy by 15%.

• Automated SQL regression validations, cutting cycle time from 5 days to 3.

• Created 200+ test scenarios/test cases, uncovering 30+ defects and improving reporting reliability.

• Streamlined SQL-based validation scripts, reducing defect detection turnaround by 25%. Education

Bachelor of Engineering (B.E.), Mechanical Engineering Visvesvaraya Technological University (VTU), Belagavi, Karnataka, India First Class, University Seat No: 2KD11ME057

Graduated: May 05, 2016

2

Contact this candidate