Raju Paidipally

Senior ETL Tester & Cloud QA Engineer with 4.5+ years at Capgemini validating enterprise data pipelines across AWS and Azure. Reduced manual testing effort by 95–98%, validated 600+ tables with zero data loss, and achieved ~95% regression coverage via Playwright/Python frameworks.

Senior Consultant — Senior ETL Tester / Cloud QA Engineer / Guidewire Tester - Capgemini Technology Services India Pvt Ltd.

• Hyderabad

(2021-12 - 2026-05)

• Architected QBOT-driven SQL automation scripts cutting manual ETL testing effort by 95–98% across 600+ tables with zero data loss
• Built Playwright/Python/pytest Page Object Model framework delivering ~95% regression coverage for enterprise data platforms
• Resolved 100+ production-critical defects across Insurance and IT domains using JIRA and HP TestRail in Agile/Scrum sprints

Senior ETL Tester / Cloud QA Engineer - HP Inc.

• USA

Project 1: HP Inc. — FIRE Tool Migration (Playwright + Pytest Automation). Architected an end-to-end Playwright + Python + Pytest automation framework using Page Object Model that became the core regression suite for the FIRE Tool migration platform. Automated login/OTP authentication, run-button workflows, and file-processing scenarios across 5 business parameter combinations (Allocation, Completeness Test, Raw Order, Standalone, Multi Element).

Verified status transitions and file generation across Inbound, Archive, Reject, and Outbound ADLS folders, plus ZIP download integrity and Fact/Dimension table validation in SQL Server and Spark SQL. Cut manual testing effort by 85% and improved release validation cycle time by 70%.

• Delivered end-to-end Cloud QA validation of Azure Data Factory pipelines including SCD Type 1/2/3 and Fact/Dimension testing
• Executed Source-to-Target validation, null/duplicate checks, and data completeness tests against ADLS Gen2 and Amazon Redshift
• Led SIT, Regression, Smoke, and Sanity testing cycles, maintaining defect traceability across Azure Databricks data warehouse layers

Senior ETL Tester - Hewlett Packard - USA

Project 2: Hewlett Packard — P360 EDL to Cloud Migration. Directed ETL testing and data validation for a large-scale migration of pipelines from legacy Hive (EDL) to Azure Databricks (FDL). Engineered QBOT automation scripts to validate 5 enterprise source feeds (E2open, BMC Helix, Gypsy, FCM, GCW) across ITG and parallel-production environments, cutting manual testing effort by 95%.

Devised and executed an end-to-end test strategy spanning 300+ test cases across ingestion, transformation, and load phases, earning full business sign-off. Reconciled row counts, data completeness, null checks, and transformation logic using advanced SQL and Python scripts across all source feeds. Resolved 100+ critical ETL defects in HP TestRail and authored RCA reports that eliminated recurring data-discrepancy patterns; the templates were adopted for future migration workstreams.

• Validated complex ETL workflows on Hewlett Packard data platforms, ensuring data integrity across MS SQL Server and IBM DB2
• Drove Functional and Regression test execution using Informatica PowerCenter and Talend Open Studio pipelines
• Automated SQL-based validation scripts reducing regression cycle time and improving pipeline reliability across DWH layers

Senior ETL Tester / Cloud QA Engineer - Genworth Financial Inc.

• USA

Project 3: Genworth Financial — AWS Cloud Migration & Contact Centre Modernization. Delivered ETL/QA for an on-premises NAS-to-AWS migration, converting 294 source files from 5 systems (CLOAS, CALYPSO, PEGA, PPLUS, Amazon Connect) into S3 bucket and query Athena tables and loading 17 EDH-T tables into Amazon RDS. Designed 200+ ETL test cases spanning migration, cloud validation, SIT and regression, achieving 100% data accuracy with zero data loss across 594 Athena and 17 RDS tables.

Automated QBOT source-to-target comparison scripts in Python and SQL, cutting the data validation cycle time by 98%. Audited referential integrity, null/duplicate checks, and data-type conformance across AWS Athena, Amazon RDS, and Amazon Redshift using complex SQL/PostgreSQL queries. Executed SCD Type 1, 2, and 3 validations, preserving historical accuracy and change-tracking behaviour across all dimension tables.

• Led Cloud QA and ETL validation for Genworth Financial, covering AWS S3, AWS Glue, and Amazon Athena data pipeline testing

Senior ETL Tester - USAA - USA

Project 4: USAA — Data Migration to Guidewire Claim Centre. Directed end-to-end ETL testing for a claims-platform migration from IBM DB2 to Oracle integrated with Guidewire Claim Centre, achieving 100% source-to-target accuracy across all migrated entities.

Tested Guidewire Claim

Centre UI and functionality to verify migrated claims data, policy records, and entity relationships post-migration. Investigated root causes on 100+ failed test cases and closed all defects in JIRA within SLA, maintaining full defect-lifecycle reporting for project leadership. Led production load verification, sanity testing, and hyper-care support, ensuring platform stability and data integrity at go live.

• Executed ETL and DWH testing for USAA, validating data pipelines and ensuring compliance with source-to-target mapping requirements

Master of Computer Applications - Computer Applications - Lal Bahadur College, Kakatiya University

B.Sc. - Mathematics, Physics, Computers - New Science Degree College, Kakatiya University

Board of Intermediate - Class XII - Wisdom Junior College