Pancham Kumar
ETL Tester
Noida,UP
Summary
A results-driven ETL and Data Warehouse Testing professional with over 4.11 years of total experience, including 3.9 years of strong expertise in ETL testing and additional experience in functional, API, and database testing. Skilled in validating end-to-end ETL processes involving data extraction, transformation, and loading using Informatica Power Center and SQL Server. Proficient in performing source-to-target mapping, data reconciliation, and data validation across various stages of the data warehouse, such as staging, ODS, and data mart. Demonstrates strong SQL proficiency to ensure data integrity and accuracy across multiple systems. Experienced in using Postman for API validation and JIRA for defect management, with a focus on delivering high-quality, reliable, and consistent results throughout the testing lifecycle.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
Work History
Quality Analyst
Crazibrain Solutions Pvt Ltd
Noida
03.2023 - Current
- Performed end-to-end ETL Testing to validate data extraction, transformation, and loading (ETL) processes between source and target systems.
- Verified source-to-target mapping and conducted data reconciliation to ensure data accuracy and completeness.
- Executed full load and incremental load testing to validate ETL workflows and performance.
- Designed and executed SQL queries to perform complex data validation and ensure data integrity across multiple layers.
- Tested and validated data in Staging, ODS, and Data Mart layers within the data warehouse environment.
- Worked extensively with Informatica Power Center and SQL Server for data validation and workflow analysis.
- Analyzed ETL logs and identified transformation or mapping issues during data load.
- Documented test cases, data validation results, and defect reports using Excel and JIRA.
- Collaborated with developers and business analysts to resolve data-related defects and ensure end-to-end data quality.
Quality Analyst
Just Dial Limited
01.2019 - 03.2021
- Performed Functional Testing, API Testing (Postman), and Database Testing of web-based applications to ensure functionality and data accuracy.
- Validated API responses, request payloads, and status codes while performing backend data verification through SQL queries.
- Conducted various testing types including Regression, Smoke, and Sanity Testing to ensure product quality after each release.
- Involved in end-to-end ETL Testing, validating data extraction, transformation, and loading (ETL) processes between source and target systems.
- Executed source-to-target mapping, data reconciliation, and data validation using SQL Server and Informatica.
- Tested data layers such as Staging, ODS, and Data Mart to ensure data consistency and integrity.
- Prepared and maintained test cases, test results, and defect logs using JIRA and Excel.
Education
Bachelor of Technology - Electronic Engineering
08.2013 - 08.2017
Skills
- ETL & Data Warehouse Tools:
- Informatica Power Center
- Databases & Query Languages:
- SQL Server
- Strong in writing SQL queries involving Joins, sub-queries, Views, Stored Procedures, and Data Validation
- ETL Testing Skills:
- Source-to-Target Mapping and Data Reconciliation
- Data Extraction, Transformation, and Loading (ETL) Validation
- Full Load and Incremental Load Testing
- Data Warehouse Testing (Staging, ODS, Data Mart)
- Data Quality and Integrity Verification
- Workflow Validation and Log Analysis
- Software Testing Skills (Secondary):
- Functional Testing
- API Testing (Postman)
- Database Testing
- Regression, Smoke, and Sanity Testing
- Defect Reporting and Tracking using JIRA
- Tools & Utilities:
- Informatica Power Center
- SQL Server Management Studio (SSMS)
- Postman
- JIRA
- MS Excel
- Operating Systems:
- Windows
Additional Information
- Award Winner for the project ZooZ on Support in June 2024. Got Team Spot Award for ZooZ-Wise& Medlab Testing on OCT-2025.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Quality Analyst - Crazibrain Solutions Pvt Ltd
03.2023 - Current
Quality Analyst - Just Dial Limited
01.2019 - 03.2021
Rajasthan Technical University - Bachelor of Technology, Electronic Engineering
08.2013 - 08.2017