Rohit Panchal

I am a Software Testing Engineer with around 4.8 years of experience in the IT industry, focused on ETL Testing, Data Warehouse Testing, Manual Testing, and Functional Testing. I bring strong knowledge of Data Warehouse concepts like Star Schema, Snowflake Schema, Fact Tables, and Dimension Tables.

I perform end-to-end ETL/DWH validation, including source-to-target validation, data completeness, transformation testing, and data quality validation. I have hands-on experience with Informatica PowerCenter and SSIS, and I use Informatica Data Validation Option (DVO) for source-to-target reconciliation.

I also test and validate analytics and reporting by ensuring backend accuracy for BI reports and dashboards against databases. With strong SQL expertise, I write optimized and complex SQL queries to support data validation, transformation verification, and defect analysis.

I work across the full Software Testing Life Cycle (STLC) and Defect Life Cycle, using tools like Jira and Micro Focus Quality Center (HP ALM). In Agile-Scrum environments, I prepare testing artifacts (Test Strategy, Test Plan, Test Cases, and Test Summary Reports) and collaborate with development teams to troubleshoot and improve ETL workflows.