Available to hire
I am a results-driven data testing professional with 14 years of experience in ETL Testing, Report/BI Testing, Functional Testing, and test lead activities. I have led testing efforts across full project lifecycles, from requirement analysis and test planning to execution, defect analysis, and UAT coordination.
My technical toolkit spans ETL tools (Informatica PowerCenter, Informatica Cloud IICS, DataStage), data stores (Oracle, SQL Server, Teradata, Redshift, Hive), BI reporting (OBIEE, SAP BO, SSRS), and cloud/AWS components. I excel at team leadership, effort estimation, stakeholder communication, and delivering quality solutions on time.
Skills
See more
Language
English
Fluent
Work Experience
Technical Test Lead at LA Care
December 1, 2022 - August 1, 2025Leading a team of 12 members including offshore and onsite as test lead including work distribution and effort estimation. Developed and validated SQL scripts for ETL/DataMart testing; tested BI reports using OBIEE and SSRS; responsible for creating/reviewing the test case, test scripts using ETL Data mappings and building complex SQL queries using Oracle DB/ SQL Server to validate them. Tested API integration with database and connectivity to generate real-time reporting. Responsible for tracking stories / defects in JIRA and maintain them through testing lifecycle. Coordinated UAT efforts between Business and Development teams for efficient defect tracking and closure. Offshore management, resourcing, and effort estimation.
Test Lead at Medibank
September 1, 2018 - June 1, 2022Developed and validated SQL scripts for both ETL and DataMart Testing. Conducted peer review with the offshore testing team to finalize the test case, test scripts for ETL and cube validation. Responsible for creating projects in Quality Centre / ALM and maintaining project folders. Responsible for tracking defects in HP ALM. Worked with SMEs of various source systems to understand the project requirements. Analyzed S3 components and ensured data availability in the system. Compared data in REDSHIFT/HIVE to validate the user requirements. Created / Reviewing Test cases, test execution and log defects. UAT coordination, hosting defect triage, proving status reports to business. Offshore management, resourcing, and effort estimation.
Test Lead / ETL Tester at TATA STEEL Europe
June 1, 2014 - July 1, 2017Creating / Reviewing Test cases, test execution and log defects for ETL and report testing. Requirement gathering, coordination with different teams, proving status report to business, preparing test data to enable testing. Work distribution among team and effort estimation. Prepare testing strategies, test plans, and test cases. Design test cases based on business rules and data mapping documents. Create Test Scripts using complex SQL scripting using PL/SQL Developer. Execute the required ETL Cubes and Reports validations using SAP BOCube. Cube Testing – Browse the Cube using SQL Server and compare the output against the Mart using SQL Query. Perform aggregate and comparative data analysis to ensure data flows and integrations are valid. Log defects for failed test cases using HP ALM. Work directly with project managers, SMEs, developers, to work towards successful project completion. Experience in onshore/offshore team model.
Software Tester at Citibank, NA
August 1, 2012 - May 1, 2014Working as a Team member in UAT Team. Test case preparation, execution, and defect tracking and providing day end status. Perform Functional & regression testing for all payment types like ACH, Wire and Creation of test designs, test processes, test cases and test data. Carry out testing as per the defined procedures. Participate in walkthroughs of testing procedures. Prepare all reports related to software testing carried out. Ensure that all tested related work is carried out as per the defined standards and procedures.
Functional Tester at MetLife Insurance, USA
April 1, 2011 - May 1, 2012Team member in UAT. Test case preparation, execution, and defect tracking and providing day end status. Involved at the end of the development process. Making sure all errors are found and that the software works properly. Focused on the overall product quality. Verify if the software meets the defined quality standards or customer requirements. Highlighting challenges to manager. Perform Functional & regression testing.
Program Analyst Trainee at Cognizant ILP
December 1, 2010 - March 1, 2011Introduction to Manual and automation Testing. Learning about: Preparation of test Scenarios, test conditions and test cases. Exposure to Quality Centre 10.0. Presentation Skills, Email etiquette.
Education
Bachelor of Technology (B-Tech) at Biju Patnaik University of Technology, Odisha, India
January 11, 2030 - January 1, 2010Qualifications
ISTQB
January 11, 2030 - December 2, 2025OCA (Oracle database)
January 11, 2030 - December 2, 2025Life Insurance Proficiency Certification
January 11, 2030 - December 2, 2025Test Automation Basics
January 11, 2030 - December 2, 2025Agile Testing
January 11, 2030 - December 2, 2025Big data and Hadoop
January 11, 2030 - December 2, 2025Industry Experience
Healthcare, Financial Services, Manufacturing, Energy & Utilities
Skills
See more
Hire a QA Engineer
We have the best qa engineer experts on Twine. Hire a qa engineer in Fremont today.