RITESH KUMAR (Technology Analyst)
Chandigarh
Summary
Dedicated ETL Tester with 4 years of experience in data quality assurance and ETL testing. Successfully managed the testing of numerous data integration projects, ensuring data accuracy and consistency. Adept at utilizing SQL and various testing tools to validate data transformations and ensure seamless data flow
Overview
4
4
years of professional experience
1
1
Certification
Work History
Quality Analyst
Infosys Ltd.
03.2024 - Current
- Involved in writing Test Scenarios, Test Cases and Identify the test case priorities.
- Well versed with Handling exceptions and defect reporting.
- Developed Test Scripts/Automate and execute Test cases.
- Involved in Data migration testing through Mainframe to Aws.
- Effective co-ordination and communication with the whole team.
- Involved in whole System Testing of the flow of Debt Manager Application.
Etl Tester
Infosys Ltd.
01.2022 - 12.2023
- Design the test cases according to customer requirement specification and review it and then execute the scenario in AWS Athena.
- Understand the data to be used for reporting, Review the Data Model, Design Documents, Source to Target mapping.
- Data checks on source data, packages and schema validation, data verification in the target system.
- Remove duplicate data, Check all the keys are in place, data threshold validation check.
- Record count check, before and after the transformation logic applied.
- Ensure the key field data is not missing or null.
- Sample data comparison between the source and target system, Data Integrity and quality checks in the target system.
Education
B.Tech - Computer science and engineering
Amity University
Noida06-2021
Skills
Technologies: Database, C,Python, SDLC, Datawarehousing
Tools: Jira, Jupyter, Excel/CV tools, Zephyr, Mainframe, AWS S3 Bucket, MySQL, Visual Studio
Methodologies: Agile & Waterfall
Testing Expertise: ETL Testing, Functional Testing, Regression Testing, Defect Reporting and Tracking , Test Planning, Sql Test Case Creation and STLC
Certification
- Infosys Global Agile Developer Certification
- Infosys Certified AWS Cloud Data Associate
- Infosys Certified MySQL Associate
- Infosys Certified Python Associate
Timeline
Quality Analyst
Infosys Ltd.
03.2024 - Current
Etl Tester
Infosys Ltd.
01.2022 - 12.2023
B.Tech - Computer science and engineering
Amity University