Jyotsna Ghoman
ETL / Database Tester
Pune
Summary
Result-oriented professional with 14+ years of ETL/BI/Pega/Functional Testing experience. Expertise in Investment banking domain, Import export & healthcare Domain. Expertise in software quality assurance, data centric testing, data transformation, data quality testing from source to target mapping within DW. Sound Knowledge in different modes of testing like database testing, functional testing, integration testing, sanity testing and regression testing. Experience in working with Software development team in resolving defects and presenting the Defect status reports. Expertise includes adeptly crafting complex SQL scripts for transformations, developing comprehensive test cases, and managing all phases of the test life cycle from requirements gathering to defect-tracking and reporting.
Overview
17
17
years of professional experience
Work History
ETL Test Co-ordinate
Billennium India Pvt. Ltd
- Current
Sr. Consultant
Wipro Technologies
04.2021 - 07.2024
- Analyzing the user story and participating in story estimates
- Test case writing, Test case reviews & execution, status reporting
- Driving daily scrum calls for the updates
- Defect logging/tracking till defect closure
- Involved in agile ceremony and assigning tasks to teammates
- Responsible for Database/ ETL testing
- Interacting with client for requirement change and daily work progress
- Mentoring team for process knowledge
- Prepared and shared status report to client and participated status meeting
- Performed ETL testing activities with Control M and Informatica
- Validation of data transformations and performing End-to-End data validation for ETL system
- Participating in agile ceremonies and sharing QA status reports to provide an Actionable Conclusion.
Consultant
Datamatics Global Services Limited
10.2019 - 05.2020
- Analyzing the user story and participating in story estimates
- Test case writing, Test case reviews & execution, status reporting
- Defect logging/tracking till defect closure
- Preparation of SQL scripts for data validation
- Involved in agile ceremony and assigning tasks to teammates
- Involved in functional, smoke testing, regression testing, sanity testing, adhoc testing and database testing
Test Lead
HCL Technologies
10.2016 - 10.2019
- Company Overview: Deutsche Bank is a German global banking and financial services company.
- Analyzing the user story and participating in story estimates
- Test case writing, Test case reviews & execution, status reporting
- Driving status call with the client
- Defect logging/tracking till defect closure
- Involved in agile ceremony and assigning tasks to teammates
- Responsible for functional, regression and system testing
- Worked on SQL queries (Database Testing)
- Interacting with client for requirement change and daily work progress
- Mentoring team for process knowledge and HCL internal certification
- Prepared and shared status report to client and participated status meeting
- Performed ETL testing activities with Control M and Informatica.
- Validation of data transformations and performing End-to-End data validation for ETL system.
- Deutsche Bank is a German global banking and financial services company.
Sr. Test Engineer
Wipro Technologies
08.2012 - 10.2016
- Analyzing the user story and participating in story estimates
- Test cases preparation as per the business requirement.
- Test data creation as per test scenarios.
- Test cases execution and defect logging/tracking in MTM.
- Involved in agile ceremony and assigning tasks to teams
- Responsible for functional, regression and system testing
- Worked on SQL queries based on business scenarios and ETL transformations (Database Testing)
- Involved in Test case planning, creation, review and execution in different releases and testing environments
- Interaction with client for requirement change and daily work progress
- Performed ETL testing activities with Control M and Informatica.
QA Analyst
Avsar Info Tech Pvt Ltd
06.2011 - 07.2012
- Test cases preparation as per the business requirement.
- Test data creation as per test scenarios.
- Test cases execution and defect logging/tracking.
- Co-coordinating with onsite team and attending project calls
- Responsible for functional and regression testing
- Worked on basic SQL queries
- Involved in requirement analysis and giving estimates
- Timely communication to customer on daily progress.
Software Engineer
Irene Power & Steel Co.
12.2009 - 06.2011
- Test cases preparation as per the business requirement.
- Test data creation as per test scenarios.
- Test cases execution and defect logging/tracking.
- Co-coordinating with onsite team and attending project calls.
Education
MCA - undefined
Pune University
B. Sc - Mathematics
Pune University
HSC - undefined
Maharashtra State Board
SSC - undefined
Maharashtra State Board
Skills
DATABASE
ETL TESTING
AWS
SQL
UNIX
SQL SERVER
Skill Summary
DATABASE, ETL TESTING, AWS, SQL, UNIX, SQL SERVER, ORACLE, ALM, MTM 10.0, INFORMATICA, JIRA
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Timeline
Sr. Consultant
Wipro Technologies
04.2021 - 07.2024
Consultant
Datamatics Global Services Limited
10.2019 - 05.2020
Test Lead
HCL Technologies
10.2016 - 10.2019
Sr. Test Engineer
Wipro Technologies
08.2012 - 10.2016
QA Analyst
Avsar Info Tech Pvt Ltd
06.2011 - 07.2012
Software Engineer
Irene Power & Steel Co.
12.2009 - 06.2011
SSC - undefined
Maharashtra State Board
HSC - undefined
Maharashtra State Board
B. Sc - Mathematics
Pune University
MCA - undefined
Pune University
ETL Test Co-ordinate
Billennium India Pvt. Ltd
- Current