Summary
Overview
Work History
Education
Skills
Tool Proficiency:
Certification
Affiliations
Accomplishments
Languages
Timeline
Generic
KARTHIKEYAN RAJA

KARTHIKEYAN RAJA

Chennai

Summary

  • 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
  • Application Tester Certification - Accenture certified
  • AWS Fundamentals Certification - Cognizant certified
  • Tosca AS1 & AS2 Certified - Accenture certified
  • Certified "Emergency Rescuer" by Usha Fire Safety (India)

Affiliations

  • Actively involved in sports on daily basis - Badminton & Cricket
  • Played for District Basket Ball team during 2009 - Under14 category

Accomplishments

  • Received Silver award during FY2023 at Bank of america for delivering a critical project by myself
  • Received Emerging Employee award during FY2016 at Accenture for performing well as a fresher

Languages

Tamil
First Language
English
Proficient (C2)
C2

Timeline

QA Specialist II A -

Bank of America
08.2022 - Current

QA Professional -

Fiserv
02.2020 - 07.2022

Associate ETL Tester -

Cognizant
01.2019 - 01.2020

ETL Test Analyst -

Accenture
05.2015 - 12.2018

Bachelor of Computer Applications (BCA) - Computer Applications

Vel Tech University

Master of Computer Applications (MCA) - Computer Applications

SRM University
KARTHIKEYAN RAJA