Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Disclaimer
Timeline
Generic

Richa Verma

New Delhi

Summary

Detail-focused ETL Tester known for high productivity and efficient task completion. Possess specialized skills in data validation, SQL scripting, and test case design that contribute to thorough quality assessments and insights. Excel in problem-solving, critical thinking, and effective communication, enabling successful collaboration with cross-functional teams to achieve project goals.

Overview

11
11
years of professional experience

Work History

Staff Engineer

Nagarro India Pvt. Ltd.
Gurgaon
12.2021 - Current
  • Analyzed requirements documents to determine testing activities scope.
  • Developed detailed test cases by considering both functional and non-functional requirements.
  • Conducted data analysis and validation to ensure precise transformation rules implemented in ETL procedures of source and target datasets.
  • Analyzed data and validated adhoc reports and dashboards using Oracle Analytics.
  • Prepared detailed reports showcasing results of ETL and BI application testing.
  • Worked collaboratively with developers to address any issues identified in project testing phase
  • Facilitated walkthrough and furnished technical assistance for users throughout the UAT stage of project development.
  • Participated in meetings with stakeholders to discuss project progress, timeline updates and risks associated with the project.
  • Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
  • Collaborated with Automation team on developing regression tests utilizing Javascript language.

Associate Level 2

Publicis Sapient
Gurgaon
06.2018 - 12.2021
  • Understanding the business requirements.
  • Interacted with the Business to gain comprehensive understanding of mapping specification scope.
  • Design and execution of the high-level scenarios and test cases for ETL.
  • Data validation of the source, staging, and the target tables.
  • Worked on Informatica – Source Analyzer, Mapping Designer, and Transformation Developer.
  • Web Services Testing between the applications using POSTMAN and SOAP UI.
  • Validated front-end application data with database entries for accuracy.
  • Executing and debugging the SQL queries to validate the data in tables and on UI.
  • Proficient in SQL for performing Data Base testing.
  • Go through the logs in CloudWatch and Sentry for any issues.
  • Involved in compatibility testing on different browsers.
  • Coordinating with business analysts, developers, and testers for complex projects.
  • Published daily status report with all relevant and expected information.
  • Gained experience with multiple defect tracking platforms such as Jira.

Sr. Test Analyst

Espire Infolabs
Gurgaon
10.2017 - 05.2018
  • Validated data migration from ODS in SQL to DWH in SQL.
  • Developed Test Cases for ETL Data Validation, Cube Testing, and Report Testing.
  • Verified functionality of Stored Procedures and Views in SQL Server 2017.
  • Gained experience in working with Informatica tools including Source Analyzer, Mapping Designer, and Transformation Developer.
  • Validated report data by checking for proper file format, adequate encryption and complete transmission. Ensured precise selection criteria and accurate effective dates of data. Maintained detailed customer records
  • Successfully performed SQL query execution and debugging to ensure accuracy of generated reports.
  • Proficient in understanding the Bug Life Cycle along with the Software Development Life Cycle and Software Testing Life Cycle.
  • Published daily status report with comprehensive and anticipated details.
  • Generated test data and prepared weekly status reports.
  • Experience with defect management tools: Jira and Mantis.

QA Engineer

Compunnel Technologies Pvt Ltd
Noida
08.2015 - 09.2017
  • Tested GUI Application manually while considering its functional requirements.
  • Validated data in Front End GUI Application with database entries.
  • Maintained the consistency of improving quality assurance by monitoring, evaluating and modifying procedures regularly.
  • Validated reports for file format, encryption, transmission, data selection and effective date while maintaining detailed student records.
  • Executed SQL queries to validate the integrity of data in generated reports.
  • Designed end-to-end test scenarios, cases, and executed them proficiently.
  • Involved in designing and documenting formal Test Plans.
  • Generated test data and prepared weekly status reports.
  • Gained experience with multiple defect management tools, such as Atlasnext.
  • Proficient in different testing types including Regression, Compatibility, Security, Smoke, Functional, GUI and System Testing as well as Integration and Report Testing.

Test Engineer

NIIT Ltd.
Gurgaon
11.2013 - 08.2015
  • Performed data validation in front-end applications and matched it with database entries.
  • Validated Mapping Logic between front end application and Data Base Fields.
  • Validated data migration from ODS (Oracle DB) to DWH (Teradata).
  • Executed and debugged SQL queries to validate report data
  • Utilized comprehensive understanding of Bug Life Cycle, Software Development Life Cycle (SDLC), and Software Testing Life Cycle (STLC).
  • Developed high-level test scenarios and cases for effective design and execution.
  • Performed SQL-based testing for Data Bases.
  • Collaborated with business analysts, developers, and testers on intricate projects.
  • Managed defect monitoring with HP Quality Centre, identifying, analyzing, and reporting product defects.
  • Published daily status report with comprehensive and anticipated details.
  • Generated test data and prepared weekly status reports.
  • Gained experience with Jira and Mantis as defect management tools.

Education

B.Tech in CSE -

Apeejay College of Engineering
Gurgaon
08-2012

Intermediate (10+2) -

S.M Arya Public School
New Delhi
03-2008

High School (10) -

S.M Arya Public School
New Delhi
03-2006

Skills

  • SQL, Core Java, Basics of Python
  • Data Warehousing
  • ETL Testing
  • Control-M
  • Business Intelligence Testing
  • Oracle Analytics
  • Power BI
  • Agile Methodologies
  • Cloud Data Warehouse: Snowflake
  • Amazon Web Services
  • Postman, SOAP UI
  • User Acceptance Testing
  • Software Development Tools: JIRA, Confluence

Accomplishments

  • Recognized as OTM Fresh Face at Sapient
  • Recognized in CheerBoard at Nagarro
  • Recognized for outstanding performance and awarded the "The Brightest Mind" at Nagarro

Languages

  • English
  • Hindi

Disclaimer

I hereby affirm that the information furnished above is true to the best of my knowledge and belief. I shall be willing to furnish additional information if required.

Timeline

Staff Engineer

Nagarro India Pvt. Ltd.
12.2021 - Current

Associate Level 2

Publicis Sapient
06.2018 - 12.2021

Sr. Test Analyst

Espire Infolabs
10.2017 - 05.2018

QA Engineer

Compunnel Technologies Pvt Ltd
08.2015 - 09.2017

Test Engineer

NIIT Ltd.
11.2013 - 08.2015

B.Tech in CSE -

Apeejay College of Engineering

Intermediate (10+2) -

S.M Arya Public School

High School (10) -

S.M Arya Public School
Richa Verma