AKSHAY KUMAR
Software Engineer
Chennai
Summary
Detail-oriented and results-driven Test Analyst with 3 years of experience specializing in data migration, ETL testing, and data validation across enterprise-scale projects. Proven ability to ensure data integrity and quality through thorough testing strategies and hands-on expertise in tools such as Informatica Cloud (IICS), SQL, and BigQuery. Skilled in interpreting complex data models, executing functional and regression tests, and identifying root causes of defects in fast-paced Agile environments. Adept at working both independently and collaboratively to meet project deadlines and deliver high-quality outputs. Seeking to contribute analytical expertise and testing proficiency to drive accuracy and reliability in data-driven solutions.
Overview
4
4
years of professional experience
2023
2023
years of post-secondary education
2
2
Languages
Work History
Associate
Cognizant
06.2024 - Current
- Actively involved as the sole ETL Test Analyst in a large-scale migration project from on-premises Oracle systems to Google BigQuery using Informatica Cloud Services (IICS).
- Collaborated with the Data Modeling team to understand migration structures and logic, enabling accurate and targeted test case design.
- Designed and executed over 100+ ETL job test cases in a single migration cycle, ensuring smooth data flow and minimal production issues.
- Built and maintained mappings, task mappings, and task flows within IICS to simulate and validate ETL logic across systems.
- Performed comprehensive data validation and analysis across staging, transformation, and target layers to ensure 100% data integrity during cloud migration.
- Tested and verified backend tables and views that directly supported Qlik-based reporting for key business metrics, forecasts, and estimations.
- Wrote complex SQL queries to test multi-level fact and dimension tables, ensuring accuracy in transformation logic and business rules.
- Managed and tracked defects using a Kanban board, contributing to efficient defect lifecycle handling and continuous improvement.
- Worked closely with the client-side Test Lead, participating in daily sync-ups, walkthroughs, and decision-making discussions to align testing strategy with business objectives.
- Delivered high-quality outputs consistently, contributing to on-time project milestones and enhanced data accuracy for end-user analytics.
Programmer Analyst
Cognizant
07.2023 - 06.2024
- Delivered ETL testing solutions across 16+ enterprise applications, managing diverse data sets critical to the operational efficiency of leading U.S. retailers such as Macy’s Inc. and Bloomingdale’s.
- Performed thorough data validation, transformation, and reconciliation testing to ensure data accuracy, consistency, and integrity across source and target systems.
- Executed comprehensive test cases and collaborated closely with developers to identify, troubleshoot, and resolve defects, ensuring minimal retest cycles.
- Conducted detailed root cause analysis of QA issues and implemented corrective actions that directly improved overall product quality.
- Investigated and resolved complex data issues involving Slowly Changing Dimensions (SCD) and derived/calculated fields within large datasets.
- Achieved a 95% defect-free release through rigorous QA and UAT phases, enhancing application reliability and end-user confidence.
- Led test review sessions with internal teams and client stakeholders, ensuring alignment and timely QA sign-off before production rollouts.
- Wrote and optimized complex SQL queries to validate transformation logic and data integrity throughout the ETL workflow.
- Authored key testing deliverables including Test Plans, Test Cases, QA Summary Reports, and documentation aligned with compliance standards.
Programmer Analyst Trainee
Cognizant
06.2022 - 07.2023
Internship (Part time)
Cognizant
12.2021 - 05.2022
Education
BE - Electrical and Electronics Engineering
RMK Engineering college
Chennai, Tamil NaduSkills
ETL Testing – Data validation, transformation testing, reconciliation testing, data integrity checks
undefinedAccomplishments
Electric vehicle – Valorous line up
An electric race car designed and built by our team for the engineering design
competition FORMULA GREEN 2020.
Electric vehicle
An electric bicycle was designed and developed with multi-source and self-charging
concept with improved efficiency.
Electric vehicle – Valorous line up
An electric race car designed and built by our team for the engineering design
competition FORMULA IMPERIAL 2020 by ISIE.
Surfing through Internet
Enjoy exploring diverse online content to stay updated on the latest trends in technology, business, and global affairs. Regularly engage with educational platforms, tech blogs, and forums to broaden knowledge, discover innovative tools, and enhance problem-solving skills. This hobby reflects curiosity, adaptability, and a continuous learning mindset.
Timeline
Associate
Cognizant
06.2024 - Current
Programmer Analyst
Cognizant
07.2023 - 06.2024
Programmer Analyst Trainee
Cognizant
06.2022 - 07.2023
Internship (Part time)
Cognizant
12.2021 - 05.2022
BE - Electrical and Electronics Engineering
RMK Engineering college
Similar Profiles
RABAB FATIMARABAB FATIMA
Agency Success Lead – DV360 at CognizantAgency Success Lead – DV360 at Cognizant
Rene Villasenor RiestraRene Villasenor Riestra
Technical Program Manager/Service Delivery Manager at CognizantTechnical Program Manager/Service Delivery Manager at Cognizant
ASMA FARHEEN AASMA FARHEEN A
Associate (QA Lead) at CognizantAssociate (QA Lead) at Cognizant
Navya VootlaNavya Vootla
Associate at CognizantAssociate at Cognizant
PIYUSH RANJAN DASPIYUSH RANJAN DAS
Associate at BNY IndiaAssociate at BNY India