Pavankumar Urumundara

QA Engineer

Bengaluru, Karnataka, India3 yrs 9 mos experience
Most Likely To SwitchAI ML Practitioner

Key Highlights

  • Expert in validating complex ETL pipelines.
  • Strong SQL skills for data accuracy.
  • Proficient in defect lifecycle management tools.
Stackforce AI infers this person is a Senior QA Engineer specializing in ETL and Data Warehouse Testing within SaaS environments.

Contact

Skills

Core Skills

Etl TestingData Warehouse Testing

Other Skills

ADFADLSArtificial Intelligence (AI)Azure DatabricksDWH TestingData AnalysisData AnalyticsData VisualizationETLHP ALMInformatica ETL ToolJIRAMachine LearningMicrosoft AzureMicrosoft Power BI

About

I am a dedicated Senior QA Engineer with 4.2+ years of experience in ETL Testing, Data Warehouse Testing, and cloud data validation across large enterprise environments. My core expertise lies in validating complex data pipelines built on Snowflake, Azure Databricks, ADLS, ADF, SSMS, and SSIS. I specialize in designing effective Test Scenarios, Test Cases, SQL scripts, and ensuring data accuracy across landing, staging, curated, and reporting layers. I have worked on major projects like CTM (Corporate Travel Management) and Pret A Manger, where I performed end-to-end ETL validation, transformation rule verification, reconciliation, KPI checks, and load testing (Incremental, Full, and Historical). My responsibilities included creating SAD, SOPs, DSRs, mapping sheets, conducting RCA, and maintaining clear, audit-ready documentation. I consistently collaborate with developers, analysts, and business teams to clarify transformations, resolve defects, and ensure strong test coverage. With strong SQL skills—including joins, window functions, aggregations, and subqueries—I ensure accurate validation of fact tables, dimension tables, and mapping logic. I am proficient with JIRA, FreshService, HP ALM, Confluence, and SharePoint for defect lifecycle management and reporting. I also hold basic knowledge of Python, supporting automation-driven validation efforts. I bring a detail-oriented work style, strong ownership, and the ability to thrive in fast-paced environments. I focus on delivering high-quality, reliable data outcomes that support business analytics, decision-making, and operational excellence.

Experience

Wns

QA Engineer

Mar 2024Present · 2 yrs · Bengaluru, Karnataka, India · Remote

  • At WNS, I worked on the CTM (Corporate Travel Management) project, an enterprise-level Data Warehouse solution designed to centralize travel booking, expense, itinerary, and partner data from multiple global systems into a unified analytical platform. The objective of the project was to ensure high-quality, consistent, and trustworthy data for reporting, KPI dashboards, forecasting, and travel spend analysis. My role involved validating complex ETL pipelines across landing, staging, transformation, and reporting layers, ensuring data accuracy and transformation integrity across Incremental, Full, and Historical loads. This included evaluating business rules, reconciling source-to-target mappings, validating KPIs, and ensuring high data quality across multiple environments. The project played a critical role in delivering reliable insights and supporting decision-making for enterprise travel operations.
ETLData Warehouse TestingSQLSnowflakeAzure DatabricksADLS+4

Photon

2 roles

Senior QA Engineer

Oct 2023Jan 2024 · 3 mos · Bengaluru, Karnataka, India · Hybrid

  • 1.Experience in software testing,
  • 2.Having experience on ETL/DWH Testing.
  • 3.Good knowledge on Data warehouse concepts and to write SQL Queries as well as on HP ALM Test Management Tool and JIRA Tool.
  • 4.Good Knowledge on Defect Life Cycle.
  • 5.Experience on Snowflake database.
  • 6.Extensively used Workflow Manager, Workflow Monitor in informatica ETL Tool. Basic Knowledge on UNIX.
ETLDWH TestingSQLHP ALMJIRASnowflake+3

Senior Software Engineer

Apr 2022Oct 2023 · 1 yr 6 mos · Bengaluru, Karnataka, India · Hybrid

  • 1.Experience in software testing,
  • 2.Having experience on ETL/DWH Testing.
  • 3.Good knowledge on Data warehouse concepts and to write SQL Queries as well as on HP ALM Test Management Tool and JIRA Tool.
  • 4.Good Knowledge on Defect Life Cycle.
  • 5.Experience on Snowflake database.
  • 6.Extensively used Workflow Manager, Workflow Monitor in informatica ETL Tool. Basic Knowledge on UNIX.
ETLDWH TestingSQLHP ALMJIRASnowflake+3

Education

JNTU Anantapur

Bachelor of Technology - BTech — Engineering

Jun 2013Apr 2017

Stackforce found 100+ more professionals with Etl Testing & Data Warehouse Testing

Explore similar profiles based on matching skills and experience