Mayuri Joshi

About Mayuri Joshi

4 years of experience in Informatica ETL Testing. Work closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects & enhancements. Designed, created and tested reports to meet business requirements. Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse. Developed SQL scripts for verification of data at extraction phase to ensure transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules Worked on basic graph creation and data verification using AB Initio. Assisted in implementation of test plans from a technical perspective. Provided input for development of test plans (progressive test plan and regression test plan) Created ETL test cases, executed SQL queries in DBeaver and validated data. Executed regression and functionality tests. Involved in designing and preparing test scenarios, Test Plans, Test Cases and Test Data. Worked with IT Development team to ensure feasibility of design and clarify user requirements. Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle. Performed Data Analysis and developed Data Mapping documents for ETL Projects. Developed Test Cases and SQL Queries to perform various Validations. Ability to analyze root cause of a problem and demonstrate good sense when handing the problem over to development. 1.10 years of experience in Unix Shell Scripting and SQL. Data integration from various modules and then use collective data for business analysis using Unix commands and PL/SQL script. 1.2 years of experience in Autosys Operations Support. To handle the Autosys job failure tickets and resolve them in minimal timeframe to meet SLA. To handle the Autosys job scheduling requests received by clients and to Understand customer\'s need and provide acceptable solutions by bringing contextual nuances in deliverables

Experience

1. Quality Assurance Test Engineer

   Wipro

   Jul 2019 — Present · Pune, IN

   3.2 years of experience in Informatica ETL Testing.\\\\nWorked on creating test cases, test data and executing the code with end to end testing.\\\\nDone several root causes analysis for production defects caused in testing environment and resolved it.\\\\nCreated regression test cases and functional test cases.\\\\nPerformed regression testing, functional testing, integration testing based on the required test cases.\\\\nTo ensure appropriate test execution, test case documentation.\\\\nUnderstanding the business requirement and creating test cases accordingly.\\\\nWorked on DVO Tool Automation tool to ensure appropriate ETL testing.\\\\nManaging the team and understanding the requirement provided by the users.\\\\nWorked on performing tuning and troubleshooting issues as and when required.\\\\nDeveloped automation scripts, SQL views, Join views as per the business requirement in DVO tool.\\\\nDeveloped different tests according to testing requirement using DVO automation tool.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n

Education

• MES' PILLAI HOC COLLEGE OF EDUCATION AND RESEARCH

  Mumbai University, Computer Science

  2012 — 2015