QA Automation Engineer with 4+ years in ETL testing, data warehouse, and QA automation.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven ETL Test Engineer with 4+ years of experience at Tata Consultancy Services (TCS) specializing in end-to-end ETL testing, data warehouse validation, and QA automation in the healthcare domain. Proven expertise in SQL-based data validation across Oracle and SQL Server, ETL testing using Talend, data integrity verification across Source, Staging, Fact, and Dimension tables, and report testing via Cognos and Power BI. Skilled in Java, Selenium WebDriver, and Cucumber BDD for automation. Delivered measurable impact: 40% increase in automation coverage, 35% reduction in manual regression effort, and 50% reduction in report validation time. Hands-on experience with JIRA, Azure DevOps, and Agile/Scrum methodologies.
St. Joseph College of Engineering
Bachelor of Engineering (BE) · Civil Engineering
August 1, 2017 – June 30, 2021
Tata Consultancy Services (TCS)
System Engineer — ETL Test Engineer / QA Automation
May 1, 2022 – Present
Chennai, Tamil Nadu, India
Data Migration Project — Cloud Platform
August 1, 2023 – June 1, 2026
Enterprise application migration to cloud under the Specialty Pharmacy portfolio, healthcare domain. • Validated end-to-end data migration across Raw, Curation, Federation, and Reporting layers ensuring data integrity and zero data loss. • Designed and executed a data-driven automation framework using Java, Selenium WebDriver, and TestNG to validate 200+ Cognos reports. • Performed ETL testing by inserting and verifying test data across multiple database layers prior to report generation. • Conducted Oracle SQL-based backend validation, feed validations, and data warehouse testing for migrated data. • Deployed and validated Talend jobs; tested ETL data warehouse components and report validation via Cognos. • Generated Allure execution reports for stakeholder visibility; presented project demos to customers and business teams.
Development Project — Cloud-Based Prescription System
June 1, 2022 – August 1, 2023
Migration of a legacy prescription application to a cloud-based enterprise platform, healthcare domain. • Performed ETL testing and backend SQL validation to verify patient, prescription, and transaction data across Oracle, SQL Server, and Databricks. • Achieved 80%+ automation coverage of critical paths: Patient Registration, Data Review, Prescription Entry, Drug Details, Product Review, and Sales modules. • Validated data across Source, Staging, and Target layers; tested Fact and Dimension Tables for data integrity and accuracy. • Executed functional, regression, smoke, and sanity testing; tracked and resolved defects using JIRA and Azure DevOps. • Gained hands-on expertise in Microsoft Azure, Databricks, and Power BI for ETL and report validation.
Enhancement Project - Healthcare Compliance Applications
May 1, 2022 – August 1, 2023
Testing and validation of UI-based healthcare compliance applications within the 340B drug pricing program. • Tested and supported 15+ UI-based healthcare compliance applications, ensuring functional correctness of UI enhancements including new screens, tabs, and workflow updates. • Analyzed FRD and HLD documents to design and execute comprehensive test cases for functional and regression scenarios. • Performed functional, smoke, sanity, and regression testing; logged and tracked defects in Azure DevOps (ADO) with clear reproduction steps. • Verified UI data creation through backend SQL validation, ensuring consistency between front-end display and database records. • Actively participated in Agile/Scrum ceremonies and contributed to sprint velocity and quality goals.
Cultural Fit Analysis
The candidate's experience across multiple projects within the healthcare domain, involving data migration, prescription systems, and compliance applications, demonstrates adaptability and a broad understanding of complex enterprise environments. Their proactive approach to automation and continuous improvement, coupled with mentoring new associates, suggests a positive contribution to team culture and a willingness to share knowledge. The diversity of tools and technologies used (Java, Selenium, Rest Assured, SQL, Talend, Azure, Databricks) indicates a strong learning aptitude and versatility.
Soft Skills & Operational Fit
The candidate demonstrates strong operational fit through active participation in Agile/Scrum ceremonies, defect tracking, and collaboration with developers. Their experience in presenting project demos and mentoring new associates highlights good communication and teamwork skills. The 'Best Tester Award' and customer appreciation indicate a results-driven attitude and commitment to quality.