Create test plans which ensures that ETL logic, the required data transformations and data load is as specified in the requirement documentation Creation of data records which tests the boundary conditions of the logic defined Creation of SQL scripts using multiple tables joins, unions, data filtering conditions based on technical mapping or design documents. Creation PL/SQL procedures to batch schedule series of DML, DDL SQL scripts. Test scheduled and integrated jobs, do data comparisons and have experience in doing E2E testing across different applications. Write data sanity tests like Count check, Reconcile records with the source data, duplicate check, etc.
Create or Schedule database jobs to run at specified times, logging audits of job run in audit tables, to be referred while defect triage Provide test status and raise issues and potential risks to Test Lead Effectively document defects using automated defect tracking software. Prepare metrics to provide test status and effectively communicate issues and potential risks to project schedule to the test lead. Ability to execute functional testing along with an ability to identify opportunities for automation and create scripts to automate at ETL as well functional automation using Selenium in Java.
Keyskills: Quality Assurance Database testing DML E2E testing DDL SQL scripts ETL Testing