Prashant Chaudhary

Highly skilled and detail-oriented ETL & Data Warehouse Tester with 3 years of experience in validating data integrity, performing end-to-end testing of ETL processes, and ensuring accuracy across complex data pipelines. Proficient in testing data extraction, transformation, and loading processes, as well as verifying data consistency between source systems and data warehouses. Expertise in writing SQL queries, performing data reconciliation, and collaborating with cross-functional teams to resolve defects and optimize data workflows.

Experienced Senior Test Engineer with a strong background in ETL testing and performance optimization. Demonstrated success in validating data migrations and collaborating with data engineers to enhance data quality and pipeline efficiency.

• Manual , Automation & API, ITCM, 2020
• Microsoft Certified: Azure Fundamentals(AZ-900)

Reporting Platform (DWH/ETL)

• Create test plans , test cases ,HLD for entire project .
• Developed and executed test cases and test scripts to verify data integrity, accuracy, and consistency across multiple data environments.
• Validated transformations and business rules applied to ensure accurate data processing during ETL workflows.
• Conducted data comparison and reconciliation between source and target databases using SQL queries and data profiling tools..
• Ensured the completeness and accuracy of data by performing null checks, duplicate checks, and verifying data type mismatches.
• Tested the ETL mappings from Source to Target.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Extensively used SQL Queries to verify and validate the Database Updates
• Worked as DWH Tester and ensure accuracy of Data flow , Data comparison , Duplicate ETL Logs, as well as API Responses
• Conducted end-to-end ETL testing to validate data extraction, transformation, and loading processes from various data sources to target systems.
• Defect Analyzing and Reporting in QC
• Engaged in UAT (User Acceptance Testing) to confirm the validity of ETL processes with business stakeholders.

Rule Engine integration with Microsoft Business Centra(DWH/ETL)

• Create Test Plan & Test Cases for the Projects
• Developed and executed test cases and test scripts to verify data integrity, accuracy, and consistency across multiple data environments.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Tested transformation functions and record formats for various input data files.
• Tested the ETL mappings from Source to Target.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Worked on multiple ETL tools and platforms, such as Informatica, for data integration and validation.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted end-to-end ETL testing to validate data extraction, transformation, and loading processes from various data sources to target systems.
• Defect Analyzing and Reporting in QC.
• Engaged in UAT (User Acceptance Testing) to confirm the validity of ETL processes with business stakeholders.

Athlete Mobile Application(Manual)

• Create Test Plan, Test cases and execute all the test cases
• Work as Manual and API Tester on the project with the help of Postman.
• Automated test case with Python.
• Created test cases using Selenium and Python for UI and data validation, enhancing defect detection by 40%.
• Built a cross-browser test suite using Selenium Grid and Python, ensuring compatibility across Chrome, Firefox, and Edge.

Learning Training System(DWH/ETL/Manual)

• Create Test Plan, Test cases and execute all the test cases.
• Work as Automation and API Tester on the project with the help of Postman & Selenium
• Created test cases using Selenium and Python for UI and data validation, enhancing defect detection by 40%.
• Built a cross-browser test suite using Selenium Grid and Python, ensuring compatibility across Chrome, Firefox, and Edge