baghya vasanth

ETL Tester

Healthrecon Connect Pvt.Ltd

May 2024 - Dec 2024

ETL Tester

Cascade Revenue Management

Jul 2022 - May 2024

Conducted comprehensive analysis of the project and performed testing on source, staging, and target data. Developed SQL queries incorporating sub-queries, joins, grouping, and analytical functions to execute test cases effectively. Conducted validation of record counts across source and target environments. Prepared documentation including test reports, defect lists, and test results for thorough documentation. Utilized SQL to analyze application data, identifying ETL processes, and crafting SQL queries and stored procedures to ensure quality assurance and analysis. Created PLSQL stored procedure for running the regression test cases. Communicated identified defects in the testing environment to the Development Team. Established traceability relationships between requirements within the same module and across different modules. Participated in Scrum Meetings, providing regular updates on day-to-day activities and status.

ETL Tester

Secova Solutions

Jan 2020 - Jun 2022

Assist in creating test plans and strategies for ETL processes based on requirements and specifications. This involves understanding the data model, transformation rules, and business logic. Help in designing and developing test cases to validate the correctness, completeness, and quality of data transformations and loading processes. Perform data validation by comparing data between source systems, staging areas, and target databases to ensure data integrity and consistency. Participate in regression testing to ensure that changes or enhancements to ETL processes do not introduce new defects or impact existing functionalities. Stay updated with emerging technologies, tools, and best practices in ETL testing and data management to enhance your skills and contribute effectively to the team.

ETL Tester

Entrust Software & IT Services

Dec 2024 - Dec 2025

Performed testing on SQL queries to ensure data accuracy and assess database performance. Validated column mapping integrity between source and target environments. Performed incremental model testing to ensure accurate delta loads and prevent data duplication. Tested and validated fact and dimension tables, ensuring correct joins and aggregations. Ensured referential integrity between fact and dimension models using relationship tests. Implemented automated data quality testing using dbt, leveraging built-in tests (not_null, unique, relationships, accepted_values) to ensure data accuracy and integrity. Validate source-to-target data after ETL execution using MySQL queries. Perform row count checks between source, staging, and target tables. Verify data completeness, accuracy, and consistency. Validate aggregations, transformations, and calculations. Developed and executed complex Oracle SQL queries to validate data accuracy, completeness, and consistency. Performed data reconciliation and row count validation between source and target tables.