Etl Tester Qa Analyst
Resume:
Smita Singh
Senior QA/ETL Tester
PROFESSIONAL SUMMARY:
Over 11+ years of experience in software testing process which Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix, and Test Metrics.
Strong SQL-Writing experience and well-versed with the SQL Syntaxes and constructs in relevance with SQL-server, DB2.
Lead Team to make sure all resources are working efficiently.
Module lead for quit a long time to make sure QA is being done properly & integrated properly.
Involved in Testing various ETL processes by writing various SQL Query to ensure data accuracy
Over 4 years of experience as a Business Analyst, in Business Analysis, System Analysis, Development, Business Re-engineering, Requirement Gathering/Analysis, internal control reviews, and financial statements and implementation
Experience with Data Testing and Validations, writing complex SQL Simulating the Business rules and transformational logic.
Extensive experience of working with Front end testing, testing WB-API using Postman, SOAP UI, Mongo DB No-sql booster.
Good experience with dataware house to understand data & extract.
Has extensive domain knowledge in diversified fields of Banking, Health Insurance, Auto Insurance and Technology
Experience in testing on Enterprise-wide applications with multiple databases like ORACLE, SQL server.
Extensive experience on testing web services (SOAP, REST) using SOAP UI and Postman.
Extensive experience in Front end as well as backend Testing.
Strong skills in Database Testing and thorough knowledge SQL.
Involved in creation and implementation of Test Procedures, Test Plans and Test Scripts. Experience in writing Test Plans, defining Test Cases, developing and maintaining test scripts, analyzing the results of scripts, interaction with team members in fixing the errors.
Used Jira to report on daily tasks, updated user story with QA test reports and provided reviews.
Experience in using defect tracking / project management tools like Jira/ X-ray, Version One
Performed Functional Testing, System Testing, Regression Testing, Migration Testing, User Acceptance Testing and Production Support
Extensively used Quality Center to write test cases and execute test scripts
Testing techniques: white box, black box, exception, boundary conditions
Used Agile methodology for implementation of projects
Experience in testing web-based applications.
Experienced in defects tracking and bug reporting
Strong experience in working with business users for User Acceptance Testing (UAT) and acting as liaison between the business and project teams, generating and communicating status report for various stake holders.
Ability to collaborate with testers, developers, project managers and other team members in testing complex projects
Experience with guiding and coordinating QA efforts with offshore resources.
Ability to work methodically in a fast-paced, deadline driven environments.
A quick learner, excellent team member and mentor with exceptional communication and interpersonal skills.
SKILL SET SUMMARY:
Testing & defect tracking Tools:
Rally, HP Quality Center, HP ALM, JIRA, Quality Manager, Requisite PRO, Rational Rose Quest (for Test-cases, Postman, API Testing, Mongo DB, DB2
Testing Methodologies:
SDLC, Agile, Waterfall, System Testing, Stress Testing, Load Testing, Reliability Testing, Feature Testing, Acceptance Testing, Functionality Testing, Regression Testing, Agile Testing, Kanban Testing, Validation, SQA Testing & Methodologies, Functional Requirements Scripting & Documentation
Web Scripting Tools:
Postman, SOAP UI, PHP, HTML, JavaScript, CSS, XML, Oracle, PLSQL
Systems:
Windows
Databases
MySQL, Oracle, SSMS, DB2, Mongo DB, Snowflake, Dataware house
PROFESSIONAL EXPERIENCE
Client: Lithia Motors
Role: Lead Quality Analyst (ETL Informatica) Duration à January 2022 to September 2022
Responsibilities: -
Working as Quality Analyst, focusing on delivering quality product.
Leading the various module testing
Extensive involvement in various API Validations
Involved in Testing various ETL processes by writing various SQL Query to ensure data accuracy
Writing various data validations and Test-cases by Writing complex sql constructs such as group, joins and merging multiple tables to simulate the business logic.
Create, Update and maintain Test Cases for different builds and releases using X-Ray plugin in Jira
Validating end to end flow, covering backend services, data flow from raw files to SSMS to Snowflake.
Well versed with the various SQL-Client tools such as Toad Data Studio, SQL-Developer etc.
Deeply involved with data testing, as well as Data structures validations as part of Backend testing, such as Tables / VIEWS / Indexes etc.
Analysis and understand the requirements specifications.
Experience in writing clear, concise, comprehensive and well-structured test plans.
Managed software defect information interacted with Business users to fix severity and priority of issues.
Attended Daily Scrum Meeting sand participated in weekly project status meeting and updated the testing Progress.
Attend the bug triage meeting every day in scrum call.
Exclusively worked with ETL team to analyze the source and Target Database systems
Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
Tested Test Cases for Deployment Verification, ETL Data Validation, and application testing.
Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to
verify/validate my test cases.
Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of
the flow and the logic for the Data warehouse project.
Writing Test cases for the new functionalities added in the product.
Reporting Bugs and doing regression testing.
Experience in Performance and Security Testing
Worked on data preparation / writing test scripts and test cases into ADO.
Worked on executing the test scripts / documenting defects and communicating to respective developers as well as report in daily standup calls.
Worked on requirement gathering for various enhancement and reporting changes or UI.
Creating and monitoring defects/bugs in Jira/X-ray
Configure test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
Performed Functional, Navigation, Regression and Smoke tests on the new enhancements in different environments like UAT, Stress and finally in Production.
Development of SQL-queries/procedures for database and backend testing.
Closely went through and worked on all the stages of SDLC for this project and designed and
executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser
Compatibility, Backend (Database) Testing.
Extensive involvement with writing SQL/Mongo DB queries and performing the various data validations.
Use ADO for repository, reporting and tracking bugs, and providing updates on resolved bugs.
Performing the Demonstrations to Business users for defects resolution and new changes for UAT.
Worked in Agile project cycle – attending daily standup meetings and scrum.
Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
Designed test plans and defined cases for functional, integration system, and user acceptance testing.
FBXML Validation, EAS validation.
Worked on ETL test case scenarios with business functionality and generated the reports
for business users.
Environment: SSMS, Snowflake, ETL(INFORMATICA), Datawarehouse, Azzure.
Tools: ALM, ADO
Client: Blue Cross and blue shield of Florida
Role: Sr ETL Quality Analyst(Module Lead) Duration à August 2018 to January 2022
Provider Connect Team
Responsibilities: -
Worked as QA Analyst for supporting Provider Connect application, which is migration from vendor managed system to Florida Blue inhouse solution for provider portal.
Validating the load process of ETL to make sure the target tables are populated according the data
mapping provided that satisfies the transformation rules.
Exclusively worked on True Comp ETL test case scenarios with business functionality
Leading the various module testing such as PCP, Task testing independently
Extensive involvement in the front-end testing of the application, validating the REST API using Postman as well as SOAP UI
Involved in Testing various ETL processes by writing various SQL Query tp ensure data accuracy
Used Jira for Agile tasks, status reporting, User Story discussion and provided estimates to stories.
Writing various data validations and Test-cases by Writing complex sql constructs such as group, joins and merging multiple tables to simulate the business logic.
Writing tests in JIRA using X-ray plugin
Validating end to end flow, covering backend services in mongo DB and DB2 databases to Front end application.
Well versed with the various SQL-Client tools such as Toad Data Studio, SQL-Developer etc.
Experience on working with multiple RDBMS, such as DB2, SQL-Server, as well as no-sql Mongo etc.
Deeply involved with data testing, as well as Data structures validations as part of Backend testing, such as Tables / Indexes etc.
Analysis and understand the requirements specifications.
Worked with Chrome extension Postman REST Client, an HTTP client for testing web services.
Experience in writing clear, concise, comprehensive and well-structured test plans.
Managed software defect information interacted with Business users to fix severity and priority of issues.
Attended Daily Scrum Meeting sand participated in weekly project status meeting and updated the testing Progress.
Attend the bug triage meeting every day in scrum call.
Writing Test cases for the new functionalities added in the product.
Reporting Bugs and doing regression testing.
Experience in Performance and Security Testing
Used Jira to report on QA track updates, Tasks delivered QA estimates for user story development.
Used Postman API to get convenient, visual display of query results.
Worked on data preparation / writing test scripts and test cases into Rally.
Worked on executing the test scripts / documenting defects and communicating to respective developers as well as report in daily standup calls.
Worked on requirement gathering for various enhancement and reporting changes or UI.
Configure test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
Performed Functional, Navigation, Regression and Smoke tests on the new enhancements added to the web application in different environments like UAT, Stress and finally in Production.
Development of SQL-queries/procedures for database and backend testing.
Extensive involvement with writing SQL/Mongo DB queries and performing the various data validations.
Worked with test management tools like JIRA, HP ALM
Use Rally for repository, reporting and tracking bugs, and providing updates on resolved bugs.
Performing the Demonstrations to Business users for defects resolution and new changes for UAT.
Worked on Client frontend UI testing (Callidus) and report bugs
Worked in Agile project cycle – attending daily standup meetings and scrum.
Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center
Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
Designed test plans and defined cases for functional, integration system, and user acceptance testing.
FBXML Validation, EAS validation.
Environment: SOAP, POSTMAN, Jira, Mongo DB, DB2, Agile, ETL(INFORMATICA), Datawarehouse.
Tools: ALM, Rally
Maternity Break (August 2017- August 2018)
Commissions Team (ETL Informatica) (July 2016- August 2017)
Responsibilities: -
Worked on analyzing and testing of application to manage the Agent commissions
Worked on testing of the ETL applications build with informatica data flows
Worked on data preparation / writing test scripts and test cases into Rally.
Worked on executing the test scripts / documenting defects and communicating to respective developers as well as report in daily standup calls.
Analyze business and system requirements, mange development of specifications to create and execute detailed test plans and verify bug fixes.
Worked on requirement gathering for various enhancement and reporting changes or UI.
Reporting defects in JIRA
Configure test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
Performed Functional, Navigation, Regression and Smoke tests on the new enhancements added to the web application in different environments like UAT, Stress and finally in Production.
Development of SQL-queries/procedures for database and backend testing.
Extensive involvement with writing SQL and performing the various data validations.
Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
Use Rally for repository, reporting and tracking bugs, and providing updates on resolved bugs.
Perform Demos to business team for defects resolution and new changes for UAT.
Working on JIRA for Defect Management and AGILE Stories management.
Worked on Client frontend UI testing (Callidus) and report bugs
Worked in Agile project cycle – attending daily standup meetings and scrum.
Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center
Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
Designed test plans and defined cases for functional, integration system, and user acceptance testing.
Compared SQL results with application results by writing SQL queries.
Environment: SOAP, POSTMAN, Mongo DB, DB2, Agile, ETL(INFORMATICA), datawarehouse.
Tools: Rally, SM7
Client: JPM Chase
Role: Quality Analyst Duration à July 2015 to April 2016
Responsibilities: -
Worked on analyzing and testing of Banking Applications / UI Testing.
Analyze business and system requirements, mange development of specifications to create and execute detailed test plans and verify bug fixes.
Configure test environment and create strategy for product development and certification.
Approve results documentation and tracking systems updates.
Supervise development of SQL-queries/procedures for database and backend testing.
Prepared and presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using Quality Center.
Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.
Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
Designed test plans and defined cases for functional, integration system, and user acceptance testing.
Environment: SOAP, POSTMAN, Mongo DB, DB2, Agile, Dataware house.
Tools: Rally, SM7
Client: All State insurance
Role: Quality Analyst Duration à August 2013 to June 2015
Responsibilities: -
Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
Extensively involved in writing and designing templates for the Test Plans and Test cases
Planned and documented Test cases for Functionality, Security, Performance, Database and Acceptance testing.
Used various queries to validate and populate data into a table.
Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports.
Identified the Test Cases and documented them in Quality Center.
Worked with the Developers and the Test Lead to verify the Test Cases.
Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through testing process.
Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for different modules in SAP
Conducted manual functionality and regression testing for each build and version.
Involved in creating the Traceability matrix based on Functional requirement in each module.
Creation of Test Data for Member data’s according to the scenarios.
Loaded the Test Data into the HPQC to prepare for the execution of Test Case
Employer: TCS
Client: PWC & Royal Skandia
Role: Quality Analyst Duration à Aug 2009 to April 2013
Responsibilities: -
Worked closely with users, business analysts and managers in the upper echelons of the organization and provide valuable feedback to make the product user friendly.
Involved in reviewing the test packages consisting of test plan, test suit, mitigation plan, requirement traceability matrix (RTM).
Conducted walkthroughs with the other team members to make sure they are up to industry QA standards.
Actively involved in extensive testing and monitoring jobs.
Lead and guided team for developing and documenting test cases and helped to oversee functional, regression, system integration and user acceptance test.
Reported defects along with the logs and necessary documents in HP ALM.
Reported status, milestones, and project plan tracking to project management and project owners daily.
Worked as module Coordinator involved in sending daily status reporting to client, assigning daily task.
Actively involved in preparing and executing Performed GUI Tests, Regression tests, Sanity tests, Functionality testing, Integration Testing and Adhoc Testing.
Contact this candidate