Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Soundaryan Sivakumar

Kelambakkam,TN

Summary

Profile Summary

  • Having around 4 years of experience as ETL/Database tester.
  • Developed test cases and planned to complete testing in QA environment.
  • Analyse requirements and provided work effort estimates.
  • Identified and implemented corrective measures based on gathered metrics.
  • Familiarity with data and functional related validations for the investment banking and retail banking application.
  • Involved application UI validations, functional validation and Data related validations.
  • Experienced creation of regression test cases and involved integration testing to find the dependency related bugs.
  • Experience in UNIX commands and SQL Joins, Group functions, Analytical functions and Sub queries.
  • Worked in the UNIX commands like grep, sed, awk and find etc. to process the files in the UNIX environment.
  • Experience in focusing on agile methodologies.

Overview

4
4
years of professional experience

Work History

ETL Tester(Consultant)

Intellect Design Arena
10.2023 - 12.2023
  • Have performed CDC insert, update and delete to do SCD-2 validations, which will ensure data integrity.
  • Identify defects in testing environment and raised defect in JIRA with proper evidence to communicate to developer.
  • Have created test cases, test scripts and test plan to validate data in each sprint.
  • New change request in business requirements and enhancement have been collected from business team and sprint has been planned accordingly.
  • Peer- peer validation of test scripts, test scenarios before deploying in SIT environment has been done.

Database Tester

Indix Info Systems
11.2021 - 10.2023
  • Gather and analyse the business requirements of new change request and enhancement from client.
  • Defects identified in testing environment are communicated to the developers.
  • Analysing the output results and prepared the test summary report (TSR) while closing the testing process.
  • Have involved creation of mock data by using of the DML commands INSERT, UPDATE and DELETE, whenever the test data is needed to validate the flow of data.
  • Escalation of the issues wherever faced to the appropriate authorities to bring it up to their notice and getting immediate resolutions.
  • Have involved demonstration of the completed points to the scrum master and product owner in the Sprint review meeting.
  • Have involved testing of reports which are created by the application to validate the entire flow of data which are created in the transaction screen against the report.

ETL Tester

Indix Info Systems
10.2019 - 11.2021
  • Involved preparation of test script development in ORACLE and SQL SERVER databases using the SQL query techniques like joins, Subquery, aggregate and analytical functions to validate various transformation logics.
  • Involved Validation of flat files by using of the UNIX commands to check the filename, patterns and permission for the source files.
  • Created Bug reports in the excel and reported the bugs in the JIRA application to communicate about the bug to development team and for the proper tracking of the bug till the closure.
  • As agile team member, involved attending of agile calls and updated the current status of the working JIRA tickets in the scrum call.
  • Created test summary reports (TSR) to find the test coverage in the time of test closure.
  • Involved peer-peer validation of the test cases, test scenarios and test scripts before executing them in the SIT environment.
  • Involved Smoke testing to validate the application build for the initial, Regression for the impact of the build for the existing functionalities.
  • Communicated to the business team to get clear about the requirement gaps and understand the functionality wherever the clarifications was required.

Education

Bachelor of Engineering - Mechatronics Engineering

RVS Technical Campus Coimbatore
Coimbatore, TN
2019

Skills

  • Database : Oracle, SQL Server, Snowflake, AWS S3, Red Shift
  • Language : SQL, Unix
  • ETL Tools : Informatica, SSIS
  • Defect Management : JIRA
  • Operating Systems : Windows family, Unix, Linux
  • Other Tools : SQL Developer, SSMS, PUTTY
  • BI Tools : Power BI
  • Version Control : GIT
  • Scripting Language : PLSQL, Python (Basics)
  • BI Tools : Power BI
  • Version Control : GIT
  • Scripting Language : PLSQL, Python (Basics)

Languages

English
Advanced
C1
Hindi
Upper Intermediate
B2
Malayalam
Intermediate
B1
French
Elementary
A2
Tamil
Bilingual or Proficient (C2)

Timeline

ETL Tester(Consultant)

Intellect Design Arena
10.2023 - 12.2023

Database Tester

Indix Info Systems
11.2021 - 10.2023

ETL Tester

Indix Info Systems
10.2019 - 11.2021

Bachelor of Engineering - Mechatronics Engineering

RVS Technical Campus Coimbatore

Similar Profiles

CREATE PROFILE
Soundaryan Sivakumar