Perform Functional, SIT, and E2E testing of UI front-end applications, including regression suite design and execution.
Conduct ETL testing using tools like iCEDQ, covering:
ETL transformation validation
Source data and business rule validation
Referential integrity and data reconciliation
BI report validation and UAT vs QA comparisons
Execute API testing using RestAssured, SOAPUI, and similar tools.
Develop and run custom SQL scripts for RDBMS (MS SQL, Sybase) testing:
Debug stored procedures
Validate complex business logic using advanced SQL
(Optional) Test ETL pipelines in Informatica, including transformation logic and data quality checks.
(Optional) Validate Power BI reports against source queries and BRD documents, including GUI and security checks.
Mandatory Required Experience:
Testing the UI front end, identify key test cases and scenarios for regression suite - Functional, SIT, E2E.
Testing through record & play references - Functional, SIT, E2E.
API Testing using RestAssured, SOAPUI and similar tools.
Custom Script development and testing - RDBMS ( MS SQL,Sybase)
Need to have the below concepts-
It is essential to understand the logic within stored procedures and possess the ability to debug them effectively to identify the root cause of issues
Should have a strong grasp of advanced SQL concepts and be capable of writing customizable scripts to validate complex business logic effectively.
