Raju Pydipally23

Senior ETL Tester and Cloud QA Engineer with 4.5+ years of experience in ETL testing, data warehouse (DWH) testing, cloud migration testing, and data quality engineering at Capgemini. Hands-on expertise in AWS (Amazon S3, Amazon Athena, Amazon RDS, AWS DataSync, AWS Glue) and Azure (Azure Databricks, Azure Data Factory, Azure Data Lake Storage, Blob Storage). Proficient in Informatica PowerCenter, Talend, QBOT automation, SQL, Python, and Linux.

Experienced in Guidewire ClaimCenter testing, SCD Type 1 / Type 2 / Type 3 validation, source-to-target data validation, test case design, defect management, and root cause analysis (RCA). Strong background in SIT, UAT, regression testing, smoke testing, sanity testing, and Agile / Waterfall SDLC methodologies.

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

(2021-12 - 2026-05)

Project 1: Genworth Financial — Contact Centre Modernization - Capgemini Technology Services India Pvt. Ltd. - Hyderabad, Telangana

(2021-12 - 2026-05)

Client: Genworth Financial Inc. (Insurance), USA. Tools / Technologies: AWS DataSync, Amazon S3, Amazon Athena, Azure Data Factory (ADF), MS SQL Server, Informatica PowerCenter, QBOT. Databases: SQL Server, PostgreSQL, Athena, Amazon Redshift. OS: Windows, Unix

• Designed, wrote, and executed 500+ QA testing test cases for ETL pipeline validation, data migration QA testing, and cloud data validation.
• Validated 594 Amazon Athena tables and 17 Amazon RDS tables with 100% data accuracy, achieving zero data loss during AWS cloud migration.
• Developed QBOT automated source-to-target comparison scripts, reducing data validation time by 70% compared to manual SQL testing.
• Executed System Integration Testing (SIT); performed data validation using SQL queries and V-Lookup; tracked and closed defects in HP TestRail within SLA.
• Validated SCD Type 1, SCD Type 2, and SCD Type 3 transformations; verified data completeness, null checks, and referential integrity across all pipeline stages.
• Coordinated with developers, business analysts, data engineers, and cloud architects to resolve data quality issues and sign off on deliverables.
• Demonstrated strong attention to detail, analytical thinking, and problem-solving abilities in identifying data discrepancies, root causes, and defect patterns across complex ETL pipelines.
• Demonstrated strong communication, critical thinking, and collaboration skills by presenting QA testing reports, test summary metrics, and defect analysis to project stakeholders and senior management.

Project 2: Hewlett Packard — P360 EDL to Cloud Migration - Capgemini Technology Services India Pvt. Ltd. - Hyderabad, Telangana

(2021-12 - 2026-05)

Client: HP Inc. (HPI), USA. Tools / Technologies: QBOT, Azure Databricks, Azure Data Factory (ADF), Talend Open Studio, Informatica PowerCenter. Databases: MS SQL Server, Databricks (Hive to FDL). OS: Windows, Linux

• Analysed Business Requirement Documents (BRDs) and wrote 300+ QA testing test cases for end-to-end ETL pipeline and data warehouse validation.
• Validated row counts, data completeness, and transformation logic for all source feeds using QBOT in ITG and parallel-production environments.
• Reduced manual testing effort by 95% by automating repetitive data validation tasks using QBOT scripts.
• Resolved 100+ critical defects; prepared Test Strategy, Test Approach, and Requirements Traceability Matrix (RTM) documents.
• Delivered data quality insights and test summary reports to business stakeholders, driving improvements in overall data integrity.

Project 3: USAA — Data Migration to Guidewire ClaimCenter - Capgemini Technology Services India Pvt. Ltd. - Hyderabad, Telangana

(2021-12 - 2026-05)

Client: USAA (Insurance), USA. Tools / Technologies: Guidewire ClaimCenter, Oracle DB, Squirrel SQL, JIRA, Informatica PowerCenter. Databases: DB2, Oracle. OS: Windows

• Validated end-to-end data migration from IBM DB2 to Oracle with 100% accuracy using SQL scripts and data mapping specification documents.
• Executed Guidewire ClaimCenter UI and functional validation to verify migrated claims, policies, contacts, and related entities.
• Performed Root Cause Analysis (RCA) on failed test cases; raised and resolved 100+ defects in JIRA; maintained defect lifecycle and status reports.
• Supported production load verification, post-migration sanity testing, and hypercare activities.
• Conducted Knowledge Transfer (KT) sessions for new team members; collaborated with UAT team for sign-off and go-live readiness.

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

Bachelor of Science - Mathematics, Physics, Computers - New Science Degree College, Kakatiya University

Board of Intermediate - Class XII - Wisdom Junior College