Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Rushabh Rotale

Pune

Summary

I'm a highly motivated professional with 3 years of experience in ETL Testing, Python automation, and Manual Testing. I have specialized in testing various types of software, such as ETL processes, web applications, databases, and data warehouses. I have hands-on experience in both manual and automated testing using Python and Selenium, focusing on BI and performance testing. Additionally, I'm familiar with Azure technologies. I excel in understanding project requirements, creating effective test scenarios, and ensuring top-notch product quality. I'm now seeking a challenging position in a dynamic organization where I can apply my skills and contribute to quality assurance processes. I'm enthusiastic about taking on new challenges and working collaboratively in a team environment.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Software Test Analyst

Cognizant Technology
07.2022 - Current
  • Conducted ETL Mapping testing, extracting data from multiple sources into target tables using transformations
  • Authored ETL test scenarios, cases, and scripts, handling defects from identification to resolution
  • Checked resulting data to ensure correct data transformation as per requirements
  • Strong Knowledge of OLTP and OLAP, extensive experience in ETL process including data transformation, mapping, conversion, and loading
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, and identifying data mismatches
  • Experience in BI report testing using Business Objects and Power BI
  • Solid understanding of ETL tools such as SSIS, knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle, etc
  • Utilized Jira for defect tracking and maintained comprehensive test documentation
  • Experience in Agile development environments, familiarity with SQL for database testing, and data validation
  • Worked on Azure Databricks, comparing data from source to target, checking counts, duplicates, and data validations
  • Utilized Azure Databricks for data comparison between source and target
  • Conducted checks for counts, duplicates, and data validations
  • Utilized Azure Data Factory for checking pipeline runs and contributed to Data Analysis, Data Validation, Data Cleansing, and Data Verification
  • Conducted data analysis, validation, cleansing, and verification, identifying data mismatches
  • Created complex SQL scripts for test execution and contributed to test case writing, execution, bug tracking, and reporting Knowledge of Azure Data factory for checking pipeline runs
  • Created SQL scripts for test execution, executed queries in Azure Databricks, and Azure Synapse, comparing results with dashboards
  • Performed Database Testing at the application level, analyzing table structure and contributing to defect resolution
  • Analyzed user stories, use cases, and requirements for validity and feasibility within the SDLC framework
  • Executed test cases at various levels including UI, Functional, Non-Functional, Integration, and Regression under senior team members' guidance
  • Assisted in analyzing test results and creating documentation, reporting bugs and errors to development teams for resolution
  • Utilized tools such as Selenium and Postman for testing processes
  • Created detailed logs to document testing phases and defects, aiding in troubleshooting issues
  • Participated in post-release and post-implementation testing activities to ensure product quality and stability
  • Contributed to the creation of test plans, test cases, and test scripts based on project requirements
  • Conducted manual testing for web applications, ensuring comprehensive test coverage
  • Communicated effectively with team members and stakeholders, presenting status reports and findings.

Junior Test Engineer

Cognizant Technology
08.2021 - 06.2022
  • Proficient in automating web application testing using Selenium Webdriver with Pytest framework
  • Experienced in data-driven testing and cross-browser testing
  • Knowledgeable in implementing automation frameworks and setting up test environments
  • Actively involved in Agile testing methodology and collaborated with cross-functional teams
  • Worked with manual QA teams to set up test data and validate scripts
  • Debugged and maintained automation test scripts based on sprints
  • Closed issues and user stories through manual and automation verification
  • Developed test automation framework scripts using Python Selenium WebDriver
  • Conducted compatibility and regression testing across browsers
  • Created framework for recording, playback, and debugging test cases
  • Collaborated with security and performance teams to analyze issues
  • Maintained reports of automation issues and test results
  • Updated Test Automation suite regularly
  • Tested backend Database and retrieved data using SQL Queries
  • Identified and created issues and bugs in JIRA
  • Implemented Page Object Model framework with Python and Selenium
  • Set up Selenium GRID for running automation scripts on different browsers
  • Designed Role-based access Security Test scenarios
  • Analyzed project requirements, developed test scripts, and prepared reports
  • Integrated automation tools and conducted retesting
  • Evaluated results and analyzed data comprehensively
  • Proficient in Git, various frameworks, API features, and DevOps methodology.

Education

Bachelor's of Mechanical Engineering -

Sinhgad Institute of Technology And Science
Pune

Diploma in Mechanical Engineering -

IBSS Collage of Polytechnic
Amravati

Skills

  • ETL Testing
  • Data Warehouse Testing
  • SQL
  • BI Testing
  • Manual Testing
  • Python Programming
  • Automation
  • Selenium Framework
  • Azure Databricks
  • Azure Data factory
  • Agile/ Scrum Methodology
  • Unix
  • Tableau
  • SDLC & STLC Life Cycle

Certification

  • MYSQL CERTIFIED
  • AZZURE CERTIFIED

Timeline

Software Test Analyst

Cognizant Technology
07.2022 - Current

Junior Test Engineer

Cognizant Technology
08.2021 - 06.2022

Bachelor's of Mechanical Engineering -

Sinhgad Institute of Technology And Science

Diploma in Mechanical Engineering -

IBSS Collage of Polytechnic

Similar Profiles

CREATE PROFILE
Rushabh Rotale