Test analyst candidate in Nashik, Maharashtra, India

Summary

I have 2.3 years of experience in ETL testing, BI testing, database testing, api testing, functional testing ,regression testing, tableau, ssis, sql. Testing professional having 1.9+ years of hands-on experience in Software Testing in Telecom and healthcare domain.
Familiar with all phases of well-versed with SDLC, STLC, Testing Concepts, worked under agile methodologies & participated in scrum meeting to discuss test operation activities with Scrum Master.
Used defect management tool such as ALM 12, JIRA
Strong experience in analyzing requirements (SRS & Mapping document) and identifying Test Scenarios, Writing Test cases, Test case execution, Defect Logging and Defect analysis.
Prepared Traceability Matrix to map use case and test case to ensure test case meets the customer requirements
Work with leadership team to analyze current SDLC process and recommend process improvements.
Expertise in Functional testing, API Testing, ETL Testing ,BI Testing, Database Testing
Expertise in performing different kinds of testing like Sanity, Smoke, Black Box, GUI, Functional and Non-functional Testing, Integration Testing, Regression Testing and Exploratory Testing of web and client/server applications.
Used JIRA for storing, maintaining test repository, bug tracking and reporting.
Proficient of SQL queries and execute SQL queries to compare the data in database with GUI and web services.
Performed Database Testing Using SQL Queries and used Database utility tool as SQL Developer. During Database Testing Involved in Table structure Validation and Data Manipulation.
Reviewed mappings and test cases before delivering to Client.
Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
Technical expertise ETL testing using SSIS for more than 1.9+ years worked on SCD1amd SCD2, written Test Cases for ETL to compare Source and Target database systems
Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading, worked on SCD1, SCD2 mappings & Dimensional Data Modeling, Fact and Dimensional Tables, Slowly Changing Dimensions, ETL transformation in ETL Testing.
Executed Queries in Azure Databricks, Azure synapse and compare with Dashboard.
Have good knowledge of Data Warehousing, OLTP and OLAP
Have knowledge on Microsoft Azure, storage accounts.
Have used Azure Databricks for querying database.
Experience with working on Databricks, ADF, SSIS and Oracle.
Test the database schema with help of data architects using ERWIN.
Generate the report from COGNOS report tool and compare with EDW database.
Worked on Qlik Data reporting for comparing data from Qlik to Azure databases
Involved in API Testing by using various methods Such as GET, POST, PUT, DELETE and Used Postman tool.
Experience in validation of report testing
BI Testing experience using Tableau & COGNOS.
A results-driven, customer-focused, articulate and analytical Software test Engineer who can think out of the box and Quality oriented mind set-up: Test-To-Break attitude.
Strong knowledge on Automating Web Application Testing using Python, Selenium WebDriver, POM, Jenkins Integration with Hybrid framework.

Expectations

Testing professional having 1.9+ years of hands-on experience in Software Testing in Telecom and healthcare domain.
Familiar with all phases of well-versed with SDLC, STLC, Testing Concepts, worked under agile methodologies & participated in scrum meeting to discuss test operation activities with Scrum Master.
Used defect management tool such as ALM 12, JIRA
Strong experience in analyzing requirements (SRS & Mapping document) and identifying Test Scenarios, Writing Test cases, Test case execution, Defect Logging and Defect analysis.
Prepared Traceability Matrix to map use case and test case to ensure test case meets the customer requirements
Work with leadership team to analyze current SDLC process and recommend process improvements.
Expertise in Functional testing, API Testing, ETL Testing ,BI Testing, Database Testing
Expertise in performing different kinds of testing like Sanity, Smoke, Black Box, GUI, Functional and Non-functional Testing, Integration Testing, Regression Testing and Exploratory Testing of web and client/server applications.
Used JIRA for storing, maintaining test repository, bug tracking and reporting.
Proficient of SQL queries and execute SQL queries to compare the data in database with GUI and web services.
Performed Database Testing Using SQL Queries and used Database utility tool as SQL Developer. During Database Testing Involved in Table structure Validation and Data Manipulation.
Reviewed mappings and test cases before delivering to Client.
Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
Technical expertise ETL testing using SSIS for more than 1.9+ years worked on SCD1amd SCD2, written Test Cases for ETL to compare Source and Target database systems
Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading, worked on SCD1, SCD2 mappings & Dimensional Data Modeling, Fact and Dimensional Tables, Slowly Changing Dimensions, ETL transformation in ETL Testing.
Executed Queries in Azure Databricks, Azure synapse and compare with Dashboard.
Have good knowledge of Data Warehousing, OLTP and OLAP
Have knowledge on Microsoft Azure, storage accounts.
Have used Azure Databricks for querying database.
Experience with working on Databricks, ADF, SSIS and Oracle.
Test the database schema with help of data architects using ERWIN.
Generate the report from COGNOS report tool and compare with EDW database.
Worked on Qlik Data reporting for comparing data from Qlik to Azure databases
Involved in API Testing by using various methods Such as GET, POST, PUT, DELETE and Used Postman tool.
Experience in validation of report testing
BI Testing experience using Tableau & COGNOS.
A results-driven, customer-focused, articulate and analytical Software test Engineer who can think out of the box and Quality oriented mind set-up: Test-To-Break attitude.
Strong knowledge on Automating Web Application Testing using Python, Selenium WebDriver, POM, Jenkins Integration with Hybrid framework.