Bhagyashree Salve

Bhagyashree Salve

Quality Analyst and ETL tester
Canada

About Me

9+ years of experience in ETL testing, design and engineering including a thorough understanding of System, Functional , Automation, ETL, SIT , UAT ,Regression testing methods started my career as data Engineer (SQL deve…

Experience

ETL tester

NLB services
Aug 2023 - Present · 2 years 10 months

Worked as a ETL tester for 6 month on Contract basis. Written Sql queries with the test cases based on the STM document and its KPI. Have experience working with big data, data mart, data warehouse, snowflake schema. Experienced with end to end source to target table testing.

Quality Analyst and ETL tester

NLB Staffing solution
Aug 2023 - Feb 2024 · 6 months

Wrote test scripts using Robot Framework (Selenium Library, WebDrivers) for UI automation.
Used Qtest for writing test cases, executing test cases, raising defects, and linking them with JIRA.
Performed CI/CD integration with Jenkins.
Reported bugs to stakeholders and the team.
Retested issues after fixes were completed.
Worked with on-premise and on-cloud environments.
Wrote SQL queries in SQL Developer to check data between on-premise and on-cloud systems.
Performed E2E testing on ETL along with MDM.
Performed regression testing, UAT testing, and API testing.

ETL Tester

VOIS (India)
Nov 2021 - Apr 2023 · 1 year 5 months

Performed data cleaning and data validation.
Understood data workflow from one system to another.
Created automated test cases with continuous improvements.
Performed end-to-end testing with MDM.
Developed test strategy, test plans, and test cases based on requirement and mapping documents.
Worked with data extracted from Oracle, flat files, and SQL Server.
Completed test documentation and wrote test cases.
Worked in SIT and UAT.
Used HP-ALM to track defects and generate defect summary reports.
Wrote complex SQL in BigQuery.
Analyzed test results and debugged observed issues.
Generated defect reports.
Verified fixed issues and updated pre-existing defect reports.
Created test reports.
Worked with DWH and SCD concepts.
Created and tested UNIX shell scripts as part of the ETL testing process.
Used Python and Python libraries (Numpy, Panda) for design, coding, debug operations, reporting, and data analysis.
Worked with AWS S3 and PySpark queries for big data.
Used Data Studio, Qlik Report, and Tableau.
Performed functional testing, regression testing, sanity testing, smoke testing, Robot Framework with Selenium, and data reconciliation testing.
Performed API automation testing with Postman.

Software Tester

PRISM HRC (India)
Mar 2021 - Oct 2021 · 7 months

Performed data cleaning and data validation.
Performed E2E testing with MDM.
Developed test strategy, test plans, and test cases based on requirement and mapping documents and their transformation logics.
Completed test documentation and wrote test cases.
Created automated test cases and sample data considering positive and negative cases.
Used Jira to track defects and generate defect summary reports.
Worked in a data lake and Hadoop environment (Spark).
Wrote HQL to test target data in Hive.
Used Data Studio, Qlik Report, and Tableau.
Performed functional testing, regression testing, sanity testing, smoke testing, and Robot Framework with Selenium.
Documented test procedures for developers and future testing.
Used Python (pandas) and PySpark.
Performed API automation testing.
Used SQL programming.
Worked with AWS S3 for big data.
Used Unix/Linux shell scripting, AbInitio tool, and Hadoop commands.

Software Engineer

Neosoft Technologies (India)
Nov 2019 - Mar 2021 · 1 year 4 months

Performed data cleaning and data validation.
Developed test strategy, test plans, and test cases based on requirements and mapping documents.
Completed test documentation and wrote test cases.
Worked with ETL workflow and exposure to fact, dimension table, and MDM.
Analyzed test results and debugged observed issues.
Generated defect reports.
Verified fixed issues and updated pre-existing defect reports.
Created test reports.
Worked with Hadoop system (Data Lake, PySpark), Pentaho tool, and AWS S3.
Performed functional testing, regression testing, sanity testing, smoke testing, and Robot Framework with Selenium.
Wrote Python program scripts for testing.
Used Oracle query tools to validate reports and troubleshoot data quality issues.

Data Engineer

EC Mobility Pvt. Ltd (India)
Apr 2017 - May 2019 · 2 years 1 month

Understood business requirements and created test cases.
Executed test cases using JIRA test management tool.
Performed web services testing using Insomnia and Postman.
Developed complex SQL queries and PL/SQL to validate data in source and target tables and in the data warehouse and MDM.
Analyzed test results and debugged observed issues.
Generated defect reports.
Verified fixed issues and updated pre-existing defect reports.
Created test reports.
Worked with PySpark and AWS S3 bucket.
Executed UNIX scripts to check data availability and for data reconciliation.
Used C and C++ OOPs concepts.
Performed functional testing, regression testing, sanity testing, smoke testing, and Robot Framework with Selenium.

Test planning ,writing Test case sand executing it using JIRA test management tool.

NIIT Technologies
Oct 2015 - Mar 2017 · 1 year 5 months

Performed database testing and functional testing.
Wrote SQL queries for data testing.
Reported bugs and retested issues.
Used basic Python scripting to deal with data.
Used C and C++ OOPs concepts.

Test planning ,writing Test case sand executing it using JIRA test management tool.

IT Digitize Station
Aug 2014 - Jul 2015 · 11 months

Performed database testing and functional testing.
Wrote SQL queries for data testing.
Reported bugs and retested issues.
Used basic Python scripting to deal with data.
Used C and C++ OOPs concepts.

Skills

Data Integration and ETL ETL Process Management ETL Testing Automation Testing System Testing Functional Testing SIT UAT Regression Testing Quality Assurance STLC SDLC Test Analysis Test Planning Test Strategy Requirement Traceability Test Environment Setup Test Case Design Defect Life Cycle Test Execution JIRA Xray HP-ALM Unix Shell Scripting Python Java Hadoop Hive AWS Spark Azure DevOps Docker Docker Compose REST API Postman Selenium WebDriver Robot Framework GitHub CI/CD Jenkins Data Warehousing Data Modeling Star Schema Snowflake Schema SCD AWS S3 Kinesis Athena SQL CTE HQL BigQuery
Report this Profile?