Kavya H Email & Phone Number

• Having 1 Year 7 month's of experience in Software Testing. • Good knowledge on Data warehouse concepts like Star schema, Snowflake schema, fact table, dimension table etc.• Having experience on ETL/DWH Testing.• Good knowledge in Slowly Changing Dimensions (SCD).• Experience on Oracle database.• Hands on experience in writing advance SQL Queries.• Hands on experience on validating the Transformations.• Hand on experience on Quality Center. • Extensively used Workflow manager and Workflow monitor in Informatica ETL.• Experience and knowledge in the Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).• An exceptional performer with the ability to work in teams as well as excellent communication, analytical, relationship management and problem-solving skills.

• Etl Test Engineer

  Creativehashes Technology Pvt. Ltd.

  Sep 2020 - Present - Bengaluru, Karnataka, India

  • Involved in functional study of the application.• Running the Jobs/Workflow for ETL process.• Prepared and ran SQL queries to verify Dimensional tables.• Verifying the data in target database after ETL process.• Performed column data mapping between source & target database.• Prepared test data for testing.• Verifying the data, which is loaded into target database.• Interactions with BA & Dev teams to resolve the issues.• Reporting daily testing status report.• Developed, Reviewed & Executed Test Scripts and Designed test data.• Identified Test Scripts for Regression testing.• Defect Analyzing and Reporting in QC.