Swathi B is a Sr ETL Automation Testing Engineer at Nationwide.
Nationwide
View- Website:
- nationwide.com
- Employees:
- 29230
-
Sr Etl Automation Testing EngineerNationwide Jun 2019 - Present• Prepare Functional positive and negative Test Scenarios/Test Cases based on Functional Specs and Design specs that were provided by business analysts and developers.• Understanding the Business requirements and developed, Executed the automation scripts, and analyzed the result using Tosca.• Developed Data Driven Tests using TOSCA and automated functional Action modes like Verify, Constraint, WaitON, and Buffer in Tosca.• Tested on various Objects Identification in Tosca and Created the scripts in Tosca using Libraries, Synchronization, Recovery Scenarios, Cleanup Scenarios and Test Configuration Parameter.• Executed the scripts in TOSCA-Scratch Book and TOSCA-Execution lists and validated the execution reports in Tosca.• Automating the new modules in TOSCA and including them into Regression pack.• Performed Adhoc Testing on Main Functionalities and helped the New Team members to get familiar with Tosca as well as Application.• Performed Database testing using Putty/Oracle SQL Developer Editors.• Oracle to Hadoop Migration Project – Test Planning & Strategy, test script preparation, test execution & documentation to include: Bigdata Testing, ETL testing, Functional and Regression testing, UAT testing/co-ordination with market representatives, Environment and data management, System Integration, Retesting.• Constructed validation SQL in Google SQL in BigQuery environment each data validation report as required.• Created JSON functions to compare the data files that exist in file server and evaluated the data differences and worked with JSON Arrays, JSON Operators by creating JSON functions/procedures.• Deployed the QA code to Git and as part of CI/CD and branched out the code to QA and tested them. -
Sr Etl Automation TesterThe Ohio State University Wexner Medical Center Feb 2017 - May 2019• Analyzed the Stories to understand the Test Requirements in each Acceptance Criteria.• Designed Test Cases and Test Scenarios, conducted functional, ad-hoc and exploratory testing for the variety of applications with expanded test coverage.• Understanding the use stories and designing functional and integration Test Scenario’s and automate all functional & Regression Test cases using TOSCA.• Executed Functional & Regression Test cases using TOSCA Executor and reporting defects in ALM and created Modules using TOSCA Wizard, Test Cases and Requirements in TOSCA.• Synchronization of modules using TOSCA Wizard if any changes in application and writing TQLs (Tosca Query Language) for different tasks• Execute Test cases and record associated results in TOSCA and verify the content in PDF using TOSCA PDF engine.• Involved in Scrum meetings, Daily Status meetings and sending the daily/weekly report of the status to TL.• Wrote automation scripts using various checkpoints like standard, image, page, text, and database Checkpoints in UFT.• Tested count of 47 Power-BI, weekly/Monthly and Quarterly reports in AWS cloud ETL environment.• Developed automated Test Scripts to perform Functional Testing, Integration Testing, System Testing and Regression testing of the application using UFT.• Deployed the QA code to Git and as part of CI/CD and worked with Dev team for branching the code.• Work closely with Development team to test software and develop business/functional processes to ensure they satisfy the functional requirements and meet the design/specification.• Develop QA Test Strategy and Test Plan Documents.• Worked in Offshore and Onsite Model with 2+ Offshore resources. • Prepares Daily status reports and weekly/monthly metrics and reports to client.• Worked on migration testing and migration happened from Salesforce, Siebel CRM systems to ICM. -
North America Medtech GroupAutomation Qa Analyst Oct 2015 - Feb 2017• Work with Application team to connect and bring automation test cases within the continuous integration process.• Creation of Test Data needed for testing.• Automate all functional & Regression Test cases using TOSCA and Executed Functional & Regression Test cases using TOSCA Executor and reporting defects in ALM and created Modules using TOSCA Wizard, Test Cases and Requirements in TOSCA.• Synchronization of modules using TOSCA Wizard if any changes in application and writing TQLs (Tosca Query Language) for different tasks.• Execute Test cases and record associated results in TOSCA and involved in Scrum meetings, Daily Status meetings.• Sending the daily/weekly report of the status to TL. • Develop and execute application software testing such as functional, integration, and regression testing to ensure the quality of the features.• Create test plans, test cases, test scripts to support specific software testing objectives, and assist team in creation, review, and finalization of agile stories and story acceptance criteria.• Reviews and gives value added input on the Product Requirement Documents created by project Manager.• Performed multi browser testing to check application can work on IE, Firefox, and Chrome browsers. • As part of GCP migration used BigQuery DW environment and constructed PL/SQL data validation sqls for validating the migration data.• Responsible for installing, integrating, prototyping, and demonstrating the tools to various project teams.• Involved in consolidating and managing the various ISDC software licenses into a single source.• Outlined the license management and technical support process for different tools managed and owned by ISDC.
Swathi B Education Details
-
Master Of Business Administration - Mba -
Computer Science
Frequently Asked Questions about Swathi B
What company does Swathi B work for?
Swathi B works for Nationwide
What is Swathi B's role at the current company?
Swathi B's current role is Sr ETL Automation Testing Engineer.
What schools did Swathi B attend?
Swathi B attended Kakatiya Institute Of Technology & Science, Yerragattu Hillocks, Bheemaram, Hasanparthy, Warangal, Jntuh College Of Engineering Hyderabad.
Who are Swathi B's colleagues?
Swathi B's colleagues are Kimberly Wells, Michelle Tegge, Adelina Sadiku, Caleb F., Frank Ruiz, Madison Levey, Dajuan And Detriche Dawson.
Not the Swathi B you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial