Sweetha Viswanathan

Have around 4 years of experience in ETL testing, Database testing, Manual testing with Oracle SQL, UNIX/LINUX and Data Warehouse concepts like Star and Snowflake Schema. Have written Test Cases for various scenarios. Worked in ETL tool like SSIS.

We have used Oracle SQL and UNIX to validate various data environments. In my Project I have created Test scenario document and test case document and also, I have validated ETL mapping document and I have created Test case actions based on that. Have hands on in SQL Query Writing, and able to build SQL Queries using of Subqueries, Joins, analytical functions and group functions. I have knowledge in UNIX commands like grep, Sed, find, awk to validate source as files. I have worked into various ETL schema architecture like Fact table, dimension tables and Star schema and snowflake schemas. I have performed data quality validations which includes Row count checks, Sample data validations and entire data validations. I have used SQL Query techniques to validate the various database environments. Have worked with SSIS team for migration and used SQL Developer to connect the databases. We are using JIRA as ticketing tool and we are following AGILE SCRUM methodology. Based on the RSD document we will prepare the test case document. By using of the mapping document we will create test scenario document. For Each scenario we will create the test cases - Here for one scenario we have to create multiple test cases. Here we will check the data structure validation and column name data type and data length validations. And we will understand the business rule and we will apply the business rule in the source SQL and we will do the minus operation. For each test case I will create test scripts, it contains the complete technical coding like SQL and UNIX scripts. Then I will execute the test scripts in the source and target environment, I will fill our test results. By using of the traceability matrix document, I will ensure all the requirements are coming under the validation or not. If everything is going fine then I will work for the test closure reports and sign off activities. 

Bsc Information technology and management - 2019

Lady doak college