Priyanka Goel
Bangalore,Karnataka
Summary
Highly experienced ETL Testing and BI Report Test Specialist with over 10+ years of expertise in data analysis, quality assurance, and business intelligence solutions. Adept at leading testing strategies for large-scale ETL processes, verifying data integrity, and ensuring high-quality reports for business stakeholders. Additionally, skilled as a Scrum Master with a proven track record of leading agile teams, facilitating scrum ceremonies, and driving continuous improvement in development processes.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Test Lead
UST Global
07.2016 - Current
- Lead ETL testing efforts for large-scale data integration projects involving data extraction, transformation, and loading (ETL) into data warehouses
- Design, create, and execute test cases for data integrity, validation, and reporting using SQL and manual test scripts
- Oversee and ensure the quality of BI reports generated from data platforms such as Power BI, Tableau
- Review requirements and technical documentation to ensure alignment with business needs and data specifications
- Perform end-to-end testing on data pipelines, including source-to-target data validation, transformation logic verification, and data quality checks
- Monitor data quality metrics and develop corrective action plans for data discrepancies or missing data issues
- Act as Scrum Master for agile teams, leading sprint planning, daily stand-ups, retrospectives, and sprint reviews
- Collaborate with cross-functional teams, including developers, analysts, and business stakeholders, to ensure testing and reporting meet business requirements
- Deliver regular status updates and testing reports to leadership and ensure alignment with overall project timelines and goals
- Identify bottlenecks and implement solutions for process improvement in both testing and development teams
- Project Description: AA Programme QFM (Aladdin Accounting Programme Quartal Fee Management)
- Aladdin Accounting (AA) programme is to implement a new accounting system
- As a result of this there is a need to migrate / realign all systems that currently take ABoR data from Dimension / PACE so that they use IBoR data where appropriate or the ABoR data being calculated / generated from AA, resulting in the ability to decommission both Dimension and PACE systems (and others)
- Worked as offshore test lead and owned the ownership of module testing (RFC722, QFM and FRL)
- Reviewing the ETL test scenarios/test cases as per the specs provided for each stream
- Involved in reviewing ETL SQL test scripts to check and validate modules as QFM, FRL and RFC722
- Involved in validating initial and incremental load using SQL Script from source to target flow
- Worked on all types of joins (inner, outer, self, cartesian), Indexes, cursors, Analytical functions (Rank, Dense Rank), Aggregate functions
- Involved in SIT validation and UAT to process the extracts and identifying the issues logs
- Involved in SIT validation and Regression validation of middleware jobs testing using different servers (DMZ, DFS etc)
- Working in the agile sprints using Azure Dev Ops
- Involved in the transition calls and creating the issue logs to discuss the specs requirements
- Facilitated daily stand-ups, sprint planning, sprint reviews, and retrospectives for cross-functional teams to ensure alignment and continuous improvement
- Supported product owners in backlog refinement, ensuring stories are well-defined and ready for development
- Experienced with Azure DevOps, JIRA, Confluence, and other project management tools to track sprint progress and enhance team communication
- Strong understanding of burndown charts, velocity tracking, and other Agile metrics for performance analysis
Senior Consultant
Capgemini India Pvt Ltd
05.2015 - 07.2016
- NextGen Revenue is to provide a single integrated EBA solution for recognized revenue and reducing the data footprint in case of Bookings, Billings, Backlogs and Shipments by having Integrated target systems
- Involved in writing SQL test scripts to check and validate ETL and OBIEE, Tableau Reports
- Created test cases/test scenarios for ETL validation and Tableau Report validation
- Involved in Creating Requirement Mapping Matrix and tracking them against every release
- Involved in validating initial and incremental load from source to target flow
- Daily updating Status of the project to Client and other respective teams and subordinates
- Involved in validating different project requirements and handling tickets for Sales and Finance and for completion of each requirement ticket creating Test Strategy
- Created framework for automated web scripts
- Worked on selenium tool for automating web applications
- Used java scripting for regression testing
- Worked on all types of joins (inner, outer, self, cartesian) and executed in a project
- Worked on Indexes, cursors, Analytical functions (Rank, Dense Rank) and Aggregate functions
- Worked on advanced sql queries and procedures also
IT Analyst
TATA Consultancy Services
05.2011 - 04.2015
- The goal of this project is to implement the centralization of data from HNB's key financial systems
- The focus will be to provide a centralized repository (EDW) for future reporting and to provide data for monthly and quarterly schedules that are part of the capital planning process
- In scope systems (currently 43 Source Application systems) identified across the following types: Customer, Originations, Servicing, Transaction, Collections, Risk, and Finance
- Source to Stg1: Testing of Source File to EDWSTG1 table
- (Straight Load/transformations)
- Stg1 To Stg2: Testing of actual transformation Logics from EDWSTG1 To EDMSTG2 table and here we checked Load like: Initial/Delta Load
- Stg2 to EDM: Testing of EDMSTG2 table To EDM table and here also we checked Load like: Initial/Delta Load
- Schedules: Testing of schedules for reporting purpose (Cognos and SAS)
- Analysing transformation logics for writing test scripts
- Writing test scenarios/test cases in Quality Centre as per the requirement of transformation logics in Data Stage
- Design test cases and scenarios according to Type1/Type2 column structure of table in data stage and for Initial Load/Delta Load
- Execution of all test cases and maintaining defects tracker in QC
- Involved in creating traceability matrix as per the testing business scenarios
- Understanding of Architectural/Functional flow of the complete system
- Involved in Arranging and Organizing Daily status calls with Dev team to help in quick resolution of all the defects
- Involved in sending daily status reports and managing the team
Education
Master of Computer Application -
Meerut Institute of Engineering And Technology
Meerut01.2007
Bachelor of Computer Application -
C.C.S. University
Meerut01.2004
Skills
- ETL Testing and Database Testing
- Azure Data Factory Testing
- BI Report Testing
- Middleware Jobs Testing
- Selenium
- Scrum Master
- Agile Project Management
- Agile Methodologies
- Quality Centre
- ALM 120
- QTP
- Jira
Certification
- Certified Scrum Master
- ISTQB Certified
- Certificate in Software Testing Skills
- Foundation Certificate in Banking and Retail
Professional Courses
- Training in Advanced Selenium Automated Testing Tool
- Training in Azure Data Factory
- Training in Quality Centre
- Training in Test Data Management (IBM Optim)
Timeline
Test Lead
UST Global
07.2016 - Current
Senior Consultant
Capgemini India Pvt Ltd
05.2015 - 07.2016
IT Analyst
TATA Consultancy Services
05.2011 - 04.2015
Master of Computer Application -
Meerut Institute of Engineering And Technology
Bachelor of Computer Application -
C.C.S. University
Similar Profiles
VIVEKA MANDALAVIVEKA MANDALA
SI Digital Transform Intern at UST GlobalSI Digital Transform Intern at UST Global
Amy FordAmy Ford
Business Analyst at UST GlobalBusiness Analyst at UST Global
Kilton RoyKilton Roy
Scrum Master| PMO Specialist at UST GlobalScrum Master| PMO Specialist at UST Global