KEERTHIPATI JAYAPRAKASH
Bengaluru
Summary
Dynamic ETL Tester with over 4 years of comprehensive experience in software testing, specializing in ETL/DWH testing and manual testing across Manufacturing, Banking, Finance, and Retail domains. Adept in SQL, data validation, and quality assurance processes.
Overview
4
4
years of professional experience
Work History
Software Engineer
Wipro Ltd.
06.2022 - 01.2026
- Involved in running ETL jobs to ensure smooth ETL processes.
- Design, review, and execute comprehensive test cases.
- Prepare SQL queries for robust data validation and verification.
- Collaborate effectively with BA and development teams to resolve issues and ensure timely project delivery.
- Report daily testing status and manage regression testing.
- Conduct end-to-end QA processes, including requirement analysis and defect reporting.
- Generate QA reports and document test results, providing sign-off for releases.
- Validated Power BI reports and dashboards by comparing visualized data against ETL target tables and source systems, ensuring data accuracy, completeness, and consistency after ETL processing.
- Performed end-to-end testing of Power BI dashboards by verifying data transformations, report filters, KPIs, drill-down functionality, and scheduled data refreshes to ensure accurate business reporting.
Associate Software Engineer
Wissen Infotech Pvt Ltd.
12.2021 - 06.2022
- Conducted performance tuning for Oracle SQL to enhance query efficiency.
- Engaged in business meetings to gather and clarify requirements.
- Designed, reviewed, and executed test cases to ensure quality deliverables.
- Prepared SQL queries for thorough data validation, count validations, and DDL checks.
- Executed scheduled tests efficiently while managing defect analysis and management.
- Performed source-to-target data validation by comparing source system data with target database tables to ensure ETL mapping accuracy and data integrity.
- Validated ETL workflows, transformations, and loading processes by executing SQL queries, identifying data discrepancies, logging defects, and working closely with developers to resolve issues.
Education
Bachelor of Commerce (B.Com) - Commerce
Sri Venkateswara University
Tirupati01-2017
Skills
MYSQL
Hadoop
Hdfs
Hive
Shell Scripting
Sqoop
GCP Bigquery
Linux
Azure
Python
ETL Testing
Data Testing
Languages
- English
- Telugu
- Tamil
Timeline
Software Engineer
Wipro Ltd.
06.2022 - 01.2026
Associate Software Engineer
Wissen Infotech Pvt Ltd.
12.2021 - 06.2022
Bachelor of Commerce (B.Com) - Commerce
Sri Venkateswara University