In my current role, I conduct end-to-end testing of ETL processes to ensure data accuracy and integrity from source systems to target databases. I develop and execute detailed test plans and scripts, utilizing SQL queries and tools like DB2 and SSMS for data validation. I also test ETL mappings for seamless data integration and adherence to business rules. Additionally, I perform BI tool validation using Cognos and PowerBI to verify data accuracy and report generation.I collaborate with developers, business analysts, and project managers to review requirements, resolve issues, and align on testing objectives. I manage defects using Azure DevOps, ensuring timely resolution and thorough documentation. My responsibilities include preparing comprehensive QA documentation and conducting regression testing to validate fixes and enhancements. I actively participate in agile ceremonies to support project timelines and deliverables.

I was involved in various Data Governance tasks, including the creation and modification of data rules, investigating rule failures, and validating rules using IBM InfoSphere Analyzer and IALITE. I contributed to building a business glossary by adding and validating terms in the IBM InfoSphere Information Governance Catalog. Additionally, I gathered requirements from clients and data stewards and built visuals and dashboards using Tableau and Excel for data governance purposes. I was responsible for publishing dashboards and data sources on the Tableau server, maintaining and refreshing data for the dashboards periodically, and monitoring the progress of all team activities on a day-to-day basis. I also facilitated team collaboration to achieve the client's data quality goals.

In this role, I focused on data analytical testing for Business Intelligence (BI) systems. My responsibilities included validating data transformations and performing comprehensive End-to-End data validation for ETL (Extract, Transform, Load) and BI systems. I specialized in data validation and had extensive experience in validating BI reports created in COGNOS, PowerBI, and TM1. Additionally, I worked with databases such as Oracle and DB2. A key part of my job was to develop and design ETL test cases and scenarios to ensure the delivery of high-quality data.