Summary
Overview
Work History
Education
Skills
Summary
Timeline
Generic
Sweta Rajput

Sweta Rajput

Test Engineer
Bengaluru,Karnataka

Summary

The main objective is towards satisfaction, both for myself and the company, I strive to work towards the high standards of loyalty and dedication which has been consistent throughout, thereby making work a pleasure and work towards the growth of organization.

Overview

4
4
years of professional experience
3
3
Languages

Work History

Test Engineer

Infogain India Private Limited
3 2023 - Current
  • Worked on ONS Finance and Rebates projects from EDL2Cloud Migration for HP Client
  • Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied and target tables
  • Coordinating with developers and business team to resolve the Defect found while testing
  • Creating and Analyzing the Manual test cases, Automation test scripts and make sure it's implemented properly
  • Analyzing failed scripts and fixing the same
  • Proficient in Gathering Data, Test Cases, Execution, Bug Tracking, and Reporting Systems
  • Worked in ETL/ Data warehouse Testing by validating Data using SQL queries and Power BI report testing
  • Preparing test data, executing test scenarios and analyzing results
  • Created and Executed SQL queries against the database to verify the backend data
  • Coordinated with Developers and Business Team daily to execute test cases as per requirement
  • Involved in the development of ETL-related functionality and understanding the ETL workflows
  • Part of daily standup meetings and involved in Test planning and retrospectives
  • Validation of data transformations and perform end-to-end data validation for ETL
  • I worked on bug or defect tracking using Jira and also managed the progress of project in Jira
  • Write SQL scripts to verify data from different Source systems to Target
  • Worked on Azure Databricks Cluster, Notebooks
  • Created ETL test scenarios and test cases and plans to execute them
  • Validated the data from Hive tables using Putty.

Test Engineer

Snipe Tech Pvt Ltd
02.2020 - 03.2023
  • Created ETL test scripts based on technical specifications/Data design documents and Source to Target mappings (STTM)
  • Create and execute database queries to test the underlying data changes accurately whenever required
  • Use customer data and feeds to perform root cause analysis and accurately reported the results
  • Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
  • Experience in all types of Test Documentation: Test Scenarios, Test Cases etc
  • Defect Management to ensure Quality Assurance and to test all the business requirements
  • For tracking the Defects, have used JIRA
  • Performed Black Box, Integration, and Regression Testing
  • And also investigated and reported bugs to the developers
  • Validation of data transformations and perform End-to-End data validation for ETL
  • Developed SQL queries and similar artifacts to validate the completeness, integrity and accuracy of data in the ETL process testing cycle
  • Tested Fact and Dimension tables with Star and Snowflake Schema by using Primary & Foreign keys.

Education

M.Tech - Electronics

B.L.D.E.A's P.G.Halakatti College of Engineering
Bijapur, India
04.2001 -

B.E - Electronics & Communication Engineering

SECAB Institute of Engineering & Technology
Bijapur, India
04.2001 -

Skills

Azure Data Bricks

SQL Server

Putty

DBeaver

Hive

Informatica

Oracle 10g

JIRA

Test Rail

Toad

Qbot

Power BI Basics

Python Basics

UNIX Basics

Snowflake Basics

Summary

  • 4+ years of experience at Infogain India Private Limited for Client HP and Snipe Tech Pvt Ltd, Bengaluru as a Test Engineer.
  • Got recognized by the organization and received appreciation and spot awards.
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes. ● Data analysis and created SQL queries for testing Fact and Dimensional tables.
  • Worked on data completeness, data transformation and data quality of various data feeds coming from the source to Data Bricks and SQL server.
  • Collaborate in defect triage/scrum call on the bug/issue tracking using Jira to effectively manage work, also resolve issues and conflict, providing transparency of the work and project status.
  • Built SQL queries for testing the transformed data using Azure Databricks and Azure SQL Database and Oracle data using Toad.
  • Validated source data which are loaded in Hive tables.
  • Flexible, eager to adapt to new environments, ability to meet tight deadlines and work under pressure, Ability to analyze the root cause of an issue found during the ETL process.

Timeline

Test Engineer

Snipe Tech Pvt Ltd
02.2020 - 03.2023

M.Tech - Electronics

B.L.D.E.A's P.G.Halakatti College of Engineering
04.2001 -

B.E - Electronics & Communication Engineering

SECAB Institute of Engineering & Technology
04.2001 -

Test Engineer

Infogain India Private Limited
3 2023 - Current

Similar Profiles

CREATE PROFILE
Sweta RajputTest Engineer