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
MADHAVI CHENGATUMADHAVI CHENGATU
Business Analyst at Carelon Global Solutions: Summitworks Technologies and UST GLOBALBusiness Analyst at Carelon Global Solutions: Summitworks Technologies and UST GLOBAL
Sulvin VargheseSulvin Varghese
Software Engineer at UST GlobalSoftware Engineer at UST Global
Kilton RoyKilton Roy
PMO Specialist at UST GlobalPMO Specialist at UST Global