Venkadeshwari P

ETL Tester with 5+ years of experience in ETL Testing, Data Warehouse Testing, SQL Validation, and Data Reconciliation. Strong expertise in Oracle SQL, UNIX, ETL Testing, and Python Automation. Experienced in Banking and Investment Banking domains with strong analytical and problem-solving skills.

Proficient in Source-to-Target Validation, Data Completeness, Data Accuracy, SIT, and Regression Testing. Hands-on experience with Snowflake, Redshift, PostgreSQL, BigQuery, and AWS environments. Skilled in Agile Scrum methodology, defect tracking using JIRA, and test case preparation/execution.

Experienced in developing Python automation scripts for ETL validation, reconciliation, and report generation.

Senior Associate – ETL Tester - PHLB Services Private Limited - Chennai

(2022-09)

Worked on a Banking Data Processing and Reporting project focused on validating large-scale banking transaction data, customer account data, and reporting systems across ETL and Data Warehouse environments.

• Performed ETL Testing and Database Testing for banking applications and reporting systems.
• Validated ETL workflows involving extraction, transformation, and loading of banking data.
• Executed complex SQL queries for Source-to-Target Validation and transformation logic verification.
• Performed data quality checks including record count validation, reconciliation testing, null validation, and referential integrity checks.
• Used SQL joins, analytical, aggregate functions, and subqueries for backend data validation.
• Utilized UNIX commands such as grep, awk, sed, find, and shell scripting for batch monitoring and log analysis.
• Created and executed test cases based on business requirements and mapping documents.
• Logged and tracked defects using JIRA and coordinated with development teams for issue resolution.
• Developed Python automation scripts for ETL data comparison, file validation, and automated report generation.
• Automated ETL validation activities using Python libraries such as pandas and openpyxl.
• Performed Regression Testing and Production Validation activities.
• Participated actively in Agile Scrum ceremonies including sprint planning, stand-ups, and retrospective meetings.

Junior Executive – ETL Tester - Quess Corp Limited - Chennai

(2021-01 - 2022-08)

Worked on Investment Banking Data Warehouse project involving validation of customer, transaction, and financial reporting data migrated from multiple source systems into target warehouse environments.

• Performed end-to-end ETL Testing for source, staging, and target systems. Validated Source-to-Target mappings and transformation rules based on business requirements.
• Developed and executed complex SQL queries using joins, subqueries, analytical functions, and group functions for backend data validation.
• Performed data reconciliation, duplicate validation, null checks, and record count validation.
• Conducted Functional Testing, SIT, and Regression Testing during Agile sprint cycles.
• Used UNIX commands such as grep, awk, sed, find, tail and cat for file validation and batch monitoring. Monitored ETL batch jobs and validated execution results in UNIX environments.
• Used JIRA for defect tracking, test case management, and reporting activities.
• Developed Python automation scripts for source and target data comparison and automated reconciliation reporting.
• Participated in Agile Scrum meetings and provided daily testing status updates.

Master of Engineering - M.E. - S. Veerasamy Chettiar College of Engineering and Technology (2015)

Bachelor of Engineering - B.E. - S. Veerasamy Chettiar College of Engineering and Technology (2013)