Dedicated and skilled ETL tester with 8.6 yrs of experience in ensuring the accuracy, integrity, and reliability of data ETL processes. Holds a strong understanding of data marts and data warehouse concepts. Proficient in SQL with the ability to create source-to-target mapping comparison test cases in SQL
Designing and executing comprehensive test plans, identifying data quality issues, and collaborating with cross-functional teams to resolve issues and optimize ETL workflows. Adept at using ETL testing tools and SQL to validate data transformations and loading processes.
Overview
9
9
years of professional experience
1
1
Certification
Work History
QA Specialist II A -
Bank of America
Chennai
08.2022 - Current
Working as an independent contributor for the Bank's crucial internal application that deals with customer's credit and risk management
Conduct end-to-end testing of ETL processes to ensure data integrity and accuracy.
Develop and execute test plans, test cases, and test scripts for ETL processes.
Verify the completeness, correctness, and consistency of data after extraction and transformation.
Perform data reconciliation between source / target systems & Identify and troubleshoot data quality issues.
Validate data transformations and mappings according to business requirements.
Execute regression tests to ensure that ETL processes continue to function correctly after changes or updates. Develop and maintain regression test suites for ETL applications.
QA Professional -
Fiserv
Chennai
02.2020 - 07.2022
Lead an 3 member team and worked on conversion of 'SAP Callidus' to 'Informatica' ETL which has saved 6.5M USD (licensing cost)
Conduct end-to-end testing of ETL processes to ensure data integrity and accuracy. Perform integration testing to validate data flow across multiple systems.
Execute regression tests to validate the impact of changes on existing ETL processes. Collaborate with data analysts, developers, and business stakeholders to understand ETL requirements.
Work closely with the development team to resolve defects and ensure a smooth ETL process.
Associate ETL Tester -
Cognizant
Chennai
01.2019 - 01.2020
Worked as an Associate - ETL tester and delivered an Emission forecasting application for the client 'PACCAR'
Conduct end-to-end testing of ETL processes to ensure data integrity and accuracy. Perform integration testing to validate data flow across multiple systems.
ETL Test Analyst -
Accenture
Chennai
05.2015 - 12.2018
Contributed as an ETL - Test analyst for delivering an ICM application that calculates employee incentives
Conduct end-to-end testing of ETL processes to ensure data integrity and accuracy.
Education
Bachelor of Computer Applications (BCA) - Computer Applications
Vel Tech University
Chennai
03-2014
Master of Computer Applications (MCA) - Computer Applications
SRM University
Chennai
Skills
ETL/ DATABASE TESTING
SQL
Data Analysis
COGNOS REPORT TESTING
FUNCTIONAL/INTERGRATION TESTING
MS Excel / Word
AGILE
JIRA, KANBAN, ALM, QTEST - TEST MANAGEMENT
Tool Proficiency:
Database: DB2, Oracle, Netezza & SQLServer
Reporting Tools: Power BI, Cognos, Callidus reports
Test Management Tools: RQM, JIRA, Qtest & ALM
Methodology: Waterfall & Agile
Certification
ETL Testing and Data Quality Management Certification - Udemy certified