Software Test Engineer
Location : Pune, India
Experience : 3.2 Year
Rate: $12 / Hourly
Availability : Immediate
Work From : Offsite
Category : Information Technology & Services
Software Test Engineer
Career Objective:
To build a career with a leading organization where I can make most of my knowledge, skills and abilities and wherein I have the opportunities for learning and career advancements.
Professional Summary:
❑ Having 3.0 years of experience in the field of IT as ETL/DWH and Manual Testing.
❑ Good knowledge on Data Warehousing concepts.
❑ Hands on experience in writing SQL Queries.
❑ Experience on JIRA Test management tool.
❑ Having the good knowledge of Functional Testing.
❑ Good Knowledge on Microsoft database.
❑ Experience on Agile methodologies.
❑ Extensively used Workflow manager, Workflow monitor in SSIS ETL Tool.
❑ Extensive experience in reviewing Business Requirement Documents in the part of preparation of Test Scenarios, Test cases and execution
❑ Experience on Oracle server database.
❑ Worked on SCD1 AND SCD2.
❑ Experience in writing SQL queries to validate source and target tables.
❑ Very good experience in various types of ETL transformation
❑ Strong Knowledge on OLTP and OLAP.
❑ Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
❑ Written Test Cases for ETL to compare Source and Target database systems
❑ An exceptional performer with the ability to work in teams as well as excellent communication, analytical, relationship management and problem-
solving skills.
Education Details:
❑ B.E from Pune University, Pune2015 with aggregate of 62%.
Professional Experience:
❑ Working as Software Test Engineer for ItekWhizdom Consultancy services Pvt Limited from July-2019 to 5th Aug
Technical Experience:
Skills
Software Testing ETL\DWH Testing, Manual Testing
Programming Languages SQL
ETL Tools SSIS
Database Oracle, SQL Server
Test Management &
other Tools JIRA, Power BI
Project Details:
Project #1:
Project name Internal – Project Environment Sql Server, SSIS, JIRA. Role in the project ETL TESTER
Description:
This project that provides Life Insurance. The main aim of the project is to find Various
Premiums, Claim paid to the Policyholder, Commission paid to the Agents and Premium received from the Policyholder. We can track the premium by channels, Marketing type and Location. The database design is based on Data warehousing concepts in order to support the development of the Business Intelligence reports
Responsibilities:
❑ ETL testing, validating data from source and destination.
❑ Writing SQL queries, Data validation testing.
❑ Participation in Reject analysis with Developers team.
❑ Testing the mappings which are based on SCD-1 and SCD-2.
❑ Executing testing activities and working within deadlines.
❑ Analyze User stories.
❑ Prepare and Execution of Test cases from Use case to meet Business Logic
❑ Reporting and Closure of Defects submitted in Defect Tracking tool
❑ Interaction with Onshore team in defect fixing process
❑ Review of SRS, and User Interface Specifications documents
❑ Prepare and Execution of Test cases from Use case to meet Business Logic
❑ Done the review and send review comments to others.
❑ Reporting and Closure of Defects submitted in Defect Tracking tool
❑ Interaction with development team in defect fixing process.
Project#2:-
Project Name Internal – Project
Environment Testing
Role Manual Testing and Power BI Tester
Responsibilities:
❑ Manual testing, validating data from mapping document to GUI.
❑ Participation in Reject analysis with Developers team.
❑ Doing the functional and nonfunctional testing.
❑ Doing the negative testing for various scenarios
❑ Executing testing activities and working within deadlines.
❑ Analyze User stories.
❑ Prepare and Execution of Test cases from Use case to meet Business Logic
❑ Reporting and Closure of Defects submitted in Defect Tracking tool
❑ Interaction with Onshore team in defect fixing process
❑ Review of SRS, and User Interface Specifications documents
❑ Prepare and Execution of Test cases from Use case to meet Business Logic
❑ Done the review and send review comments to others.
❑ Reporting and Closure of Defects submitted in Defect Tracking tool
❑ Interaction with development team in defect fixing process.
❑ Checking Power BI report with respect to Major fields KPI, Visual, Filters , Table Data.
❑ Validating the Power BI reports with respect to SQL Server.
❑ Create Power BI Test cases and Test summary reports.
❑ Check the connection model for Power BI.
Declaration: I hereby declare that the above information is true to the best of my knowledge in concern, and I shall be very grateful in serving your esteem organization to the best of my ability if ever I have given a chance.
Date:
Place: Shraddha Golhar
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
