Archit Mathur Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

Pune, Maharashtra, India

Bengaluru Area, India

 Involved in understanding the Business requirements for Reports. Involved in daily scrum meetings , Defect Triage and participated in weekly calls Developed, Modified and Executed the test cases Involved in Review the test cases  Involved in TIBCO Spotfire Platform testing by creating Ad-Hoc reports Involved in Smoke, End-To-End, System, Regression, Ad-Hoc and Browser Compatibility Testing. Performed back-end testing on the Oracle database by writing SQL queries Interacted with Developers, Business Analysts and discussed technical problems Involved in Defect Tracking and Bug Reporting by using HP ALM/QC Involved in knowledge transfer on analytics areas to the other team members. Involved in Cross-Impact Sessions. Involved in preparing daily status reports and test execution reports. Experienced using database query tools for PL/SQL Developer, TOAD, and SQL Developer. Creating Information models and Information Links using Information Designer. Creating Visualizations using Bar charts, Pie charts, Scatter charts. Creating Visualizations using filtering schemes and Prompts Creating Visualizations using columns from external data Analysis & Discussion of New Data & ETL Requirements of a Product release. Understanding the Business Requirement and identifying the key scenarios for ETL Mappings.Design & Develop ETL Mappings, Workflows & Sessions based on ETL Requirements using Informatica 9.1. Created mappings using Transformations like Expression, Aggregator, Filter, Router, Joiner, Sequence Generator, Lookup and Update strategy in Informatica 9.1.Create & Execute Unit Test Plans based on System & Validation Requirements.Unit Testing of Mapping to ensure that data is loaded as per the ETL specification. Error Finding & Rectification in case a job gets failed.Enhancing & Modifying the Existing ETL Code & Scripts as per the user requirements.Documentation for all developed processes including Process Flow & Data Mapping.

 Requirement Analysis• To understand the business, functional and ETL requirements of the Project.• Suggesting Requirement changes if it’s ambiguous with System characteristics. Test Strategy & Planning• Understanding the flow of the Project and identifying the key ETL scenarios.• Designing positive and negative test cases based on the identified scenarios. Ensuring prerequisites before Test Execution• To get necessary server access/schema privilege. To ensure Environment is ready.• To send DMA doc to upstream application to provide data by ST start date. Test Case Execution• To test the functionality of ETL Logic using SQL, Unix and Shell script.• To run ETL Scripts provided by Developer and verify if it is working fine.• Triggering and monitoring DataStage jobs to load data.• Developing automated solutions to boost efficiency of ETL projects. Defect Logging & Tracking• Logging the defects identified during testing in Rational Clear Quest.• Participation in root cause analysis with the Dev/DBA to close the defect.

Bachelor Of Engineering (Be), Electrical And Electronics Engineering, 7.5

Education record