Rachana K

ETL, Database and manual testing professional with over 3.5 years of experience, including more than 3 years in ETL/Database testing. Skilled in SQL, test case design, and data validation across SQL Server and Oracle. Familiar with Informatica PowerCenter, STLC/SDLC, and data warehousing concepts, such as star schema, fact, and dimension tables.

• Rising Star Award: Recognized as the best fresher on the team for exceptional performance
• Client appreciation: Received recognition from clients for ensuring data accuracy and improving test processes

Roles and responsibilities

1. End-to-End Testing: 

• Performed complete testing from the database to the UI, ensuring the data flow and transformations were accurate across systems

2. ETL Testing:

• Validated extract, transform, and load processes to ensure data from source systems, like DaVita, is correctly moved and transformed into the target systems
• Checked for data consistency, completeness, and integrity

3. Database Testing: 

• Wrote and executed complex SQL queries to validate data at various stages
• Compared source and target data for accuracy after transformation.

4. Defect Tracking and Reporting:

• Logged defects in JIRA (or a relevant tool), worked closely with developers to get them resolved, and verified the fixes

5.   Test Case Design and Execution: 

• Created, reviewed, and maintained test scenarios, test cases, and test data
• Executed test cases manually and tracked results.