Arun Kumar Kapuluru
Hyderabad
Summary
Results-driven ETL Test Analyst with extensive experience at Infosys Limited, specializing in SQL and ETL testing. Proven track record in developing comprehensive test plans and executing complex data validations. Adept at collaborating with cross-functional teams, ensuring software quality, and effectively communicating findings. Strong analytical skills complemented by a commitment to excellence.
Overview
7
7
years of professional experience
Work History
ETL Test Analyst
Infosys Limited
Hyderabad
08.2024 - Current
- Leading the QA Team for Various workstream across the Allianz network.
- Requirments gathering and desiging test strategy documents.
- Creating Test cases ,Test plan and Test set and uploading them into Jira.
- Analyzing the mapping documents for various events for the data migration.
- Executing the test cases in Jira.
- Collaborated with developers and product owners to stay current on product features and intended functionality.
ETL Test Analyst
TATA CONSULTANCY SERVICES
10.2021 - 07.2024
- Creating Test plan, Test set, and Test cases and uploading them into Jira.
- Data conditioning on various Banking models as per the requirement documents.
- Giving KT sessions to the new joiners and to the team members.
- Able to selenium automation scripts inorder to run Multiple test cases at once.
- Analyzing the data flow in all the layers and understanding the mapping logic based upon the Scenarios.
- Test case Execution.
- A total of 8 banking models has been validated from data conditioning stage to CRR Engine tables.
- Collaborating with all the team members in the team lead absence and making sure execution goes smoothly with out any issues.
ETL Test Analyst
Cognizant
Chennai
07.2020 - 09.2021
- Requirements gathering and designing test plan documents.
- Creating test design, test cases uploading in rally.
- Participating in test design discussion with peers and counterparts.
- Able to raise a defect to client in Jira as defect tracking management.
- Able to run the reports using the Cognos application.
- A total of 15 reports have been validated, and complex queries have been queried in Snowflake to generate correct data in the report.
- Analyzing the data flow in all layer and raising the defects in rally and jira with respective teams.
- Collaborated with developers and product owners to stay current on product features and intended functionality.
- Documented test results and communicated findings to stakeholders effectively.
- Developed comprehensive test plans to ensure software quality and functionality.
ETL Tester
04.2020 - 06.2020
- Designing and gathering the requirement for Test plan documents.
- Validating the data in QA Environment for all migrated tables and raising a defects in rally testing management tool.
- Application release support and validation.
- Designing and uploading the test cases in rally.
- Creating a QA sign-off document on release basis.
- A total of 25+ countries related tables has been validated and migrated from Netezza to Oracle data base.
- Got appreciation from the client for my support during production.
ETL Tester
06.2019 - 04.2020
- Designing and gathering the requirement for Test plan documents.
- Validating the data in QA Environment for all migrated tables and raising a defects in rally testing management tool.
- Application release support and validation.
- Designing and uploading the test cases in rally.
- Creating a QA sign-off document on release basis.
- Able to Attend scrum calls and onsite calls independently with out any team support.
- A total of 500+ tables have been validated and migrated to oracle exadata as a solo player.
- Got appreciation as Bright beginner from insurance domain for the early project since handled the whole project as single member.
ETL Tester
02.2019 - 05.2019
- Designing and gathering the requirement for Test plan documents.
- Validating the data in QA Environment for all migrated tables and raising a defects in rally testing management tool.
- Application release support and validation.
- Designing and uploading the test cases in rally.
- Creating a QA sign-off document on release basis.
Education
BE - Electronics and Communication
RMK Engineering College
Chennai01.2018
Intermediate -
Viswasai Junior College
Nellore01.2014
SSC -
VBR EM High School
Nellore01.2012
Skills
- SQL
- ETL Testing
- Cognos report testing(BI Report testing)
- Database Testing
- Data warehouse concepts
- Informatica
- Agile methodologies
- Python Automation
Disclaimer
I do Hereby declare that the Particulars of information and facts stated herein above are true correct and complete to best of my knowledge.
Timeline
ETL Test Analyst
Infosys Limited
08.2024 - Current
ETL Test Analyst
TATA CONSULTANCY SERVICES
10.2021 - 07.2024
ETL Test Analyst
Cognizant
07.2020 - 09.2021
ETL Tester
04.2020 - 06.2020
ETL Tester
06.2019 - 04.2020
ETL Tester
02.2019 - 05.2019
BE - Electronics and Communication
RMK Engineering College
Intermediate -
Viswasai Junior College
SSC -
VBR EM High School