Haroon Dar

Spearheaded ETL testing for GPS Data Platform, ensuring data integrity across Raw, Staging, Fact, and Dimensional layers using SQL on Oracle, PostgreSQL, and Snowflake (AWS). Designed and executed 500+ test cases derived from BRD/DMD for SIT and UAT, attaining a 98% pass rate. Developed stored procedures for automated JSON entity validation within Snowflake pipelines to streamline complex data verification. Proactively monitored ETL jobs through Control-M, addressed production issues promptly, and managed defect tracking via JIRA. Tested AWS cloud pipelines (S3, SQS, Snowflake, DynamoDB), effectively reducing data discrepancies by 40%.

Performed ETL testing for LIMS modules, focusing on data migration and backend validation using SQL. Designed comprehensive test scenarios, traceability matrices, and automated regression scripts utilizing WebDriverIO. Managed the complete defect lifecycle within Azure DevOps, reducing resolution time by 30%. Executed source-to-target data reconciliations to guarantee 100% data integrity throughout migration processes, ensuring reliable and accurate system performance.

Performed validation of Informatica ETL workflows, batch processes, and DB2 tables to support legacy system decommissioning and modern migration initiatives. Developed comprehensive test cases derived from Business Requirement Documents, mapping sheets, and data models covering clients, accounts, holdings, and transactions. Collaborated closely with Business Analysts and Data Engineers during Agile sprints, utilizing QuerySurge, JIRA, and ALM for effective defect tracking and resolution. Executed integrated testing for platforms including Fenergo (AML), Broadridge, IBM DB2, and Pega, ensuring system reliability and minimizing operational downtime.