TELU SRI HARSHA
ETL TESTER
Summary
Overall, 4+ years of experience as an IT professional Software Testing (AWS/ETL/ Informatica / Database/ Data warehouse /Manual). Proficient in ETL Testing and Database Testing. Experience in AWS Athena , Microsoft Sql Server ,Oracle SQL developer Good knowledge in respective transformations like Source Qualifier, Filter, Router, Expression, Joiner, Rank, Lookup, Update strategy, SCD Type1, 2 and 3. Exposure to Data Warehouse Projects, Mapping Sheet and query for execution of Test Cases. Understanding of Data Warehouse concepts like Start Schema, Snow Flake Schema, Dimensions and Fact Tables. Good knowledge of ETL Processes, ETL Testing, Data-Mart . Well acquainted with SDLC, STLC and Test Methodologies and Agile Methodologies. Having good understanding of DDL, DML, TCL commands and sound knowledge in writing SQL queries. Have extensively used HP ALM and JIRA for Test Management and raising Defect. Have performed end to end testing which involves Functional testing, System Testing, Integration Testing, Regression Testing, UAT. Have experience in preparing Test Plans, Test Scenarios, Test cases, Test Data, Test Summary Reports and Estimations. Strong knowledge of Defect Life cycle.
Overview
4
4
years of professional experience
Work History
Sr. Consultant QA
Virtusa
07.2021 - Current
Education
B. Tech -
VIT University
Skills
- Operating systems: Windows 7, 10, LINUX
- Testing methodologies: Database, ETL, API testing
- Database technologies: Oracle SQL, Microsoft SQL Server, TOAD, Oracle SQL Developer
- Programming languages: Python
- Cloud services: AWS Athena ,S3 bucket
- Project management tools: Jira, Zephyr
- Data visualization: Tableau
- Automation tools: Selenium framework, Playwright ,Autosys, TeamCity
Projects
STRIDE
Responsibilities:
- Understanding the client requirements
- Involved in retrospective meetings and Scrum meetings for daily updates
- Writing the test cases based on the design document, which was prepared by the business analyst
- Writing the required SQL to verify the test cases during the test execution
- Validating the data as per the logic given, and comparing the data with the business files
- After test execution, preparing the Test Evidence document
- Doing the sanity testing, system testing, regression testing
- Executing the test cases and raising the defects in Jira
- Involved in automation activities
- Participated in defect triage calls, retrospective call
Timeline
Sr. Consultant QA
Virtusa
07.2021 - Current
B. Tech -
VIT University