QA Automation Engineer with 6+ years in ETL Testing & Data Warehousing
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Detail-oriented ETL Quality Analyst with 6 years of experience in data validation, ETL testing, and ensuring data integrity across diverse platforms. Skilled in SQL, automation testing, and data warehousing, with a strong focus on identifying discrepancies and optimizing ETL processes for accuracy and efficiency. Experienced ETL Quality Analyst with 6 years of expertise in data validation, ETL testing, and data integrity assurance. Proficient in SQL, PL/SQL, and database testing to ensure accurate data extraction, transformation, and loading (ETL). Hands-on experience with ETL tools like Informatica, Talend, and SSIS for end-to-end data pipeline testing.
Tamil Nadu Open University
MCA
August 1, 2021 – June 30, 2023
A.M. Jain College
BCA
August 1, 2014 – June 30, 2017
R Systems International Ltd
ETL Quality Analyst
May 1, 2025 – Present
India
Vilwaa Tech Enablers Pvt Ltd
ETL Quality Analyst
November 1, 2024 – February 1, 2025
Chennai, Tamil Nadu, India
TVS Credit
ETL Quality Analyst
July 1, 2023 – August 1, 2024
India
Sterling Software
ETL Quality Analyst
April 1, 2022 – June 1, 2023
India
Pathfinder
ETL Quality Analyst
February 1, 2021 – April 1, 2022
India
Altruist Technologies Pvt Ltd
ETL Quality Analyst
June 1, 2019 – January 1, 2021
India
Fisdap
May 1, 2025 – April 1, 2026
Conducted functional, regression, and integration testing to validate ETL data flow and transformation logic. Used Selenium for basic UI testing of ETL applications with web-based dashboards. Investigated ETL job failures, identified root causes, and implemented corrective actions to prevent recurrence. Worked closely with data engineers, BI analysts, and stakeholders while maintaining test documentation and best practices. Ensured data integrity, accuracy, and consistency across ETL processes and data warehouses. Validated data completeness, correctness, and transformation logic in ETL workflows. Compared and verified source vs. target data across Oracle DB, Snowflake, and SQL databases. Analyzed ETL job execution times and optimized performance in SSIS.
Sumitomo Mitsui Trust Bank
November 1, 2024 – February 1, 2025
Performed end-to-end ETL testing to ensure data integrity, accuracy, and consistency across various platforms. Wrote and optimized complex SQL queries to validate data transformations in Oracle DB, Snowflake, and other databases. Worked with Informatica and Talend to validate ETL workflows and data pipelines. Validated data warehousing solutions and cloud-based ETL processes in AWS and VMware environments. Used Python and Pandas for ETL test automation, data validation, and performance optimization in big data environments.
TVS Credit
July 1, 2023 – August 1, 2024
Identified, logged, and tracked defects using JIRA and ServiceNow, collaborating with developers to resolve data issues. Performed testing and validation of Power BI reports, ensuring accurate data visualization and business insights. Utilized Linux/Unix commands and shell scripting for job automation, log analysis, and ETL job execution. Worked with DBAs to optimize SQL queries, indexing, partitioning, and ETL job performance.
Tata Mutual Fund / Kotak Mutual Fund
February 1, 2021 – April 1, 2022
Performed functional, integration, and regression testing to validate ETL and data warehouse updates. Designed test cases, test scripts, and automation frameworks for ETL validation. Validated data modeling, schema design, and transformations in a data warehouse environment. Wrote and optimized complex SQL queries, PL/SQL scripts, and stored procedures for ETL validation. Validated cloud-based data integration pipelines on AWS and Snowflake. Worked with DBAs to optimize SQL queries and indexing for faster ETL job execution. Performed data validation and transformation testing in big data environments using Pandas.
Cultural Fit Analysis
The candidate has worked across various industries (Healthcare, Banking/Finance) and with different clients, indicating adaptability and exposure to diverse business contexts. The consistent role as an 'ETL Quality Analyst' across multiple companies suggests a focused career path and commitment to data quality. The breadth of technologies and tools used across projects also points to a willingness to learn and integrate into different technical environments. The candidate's profile aligns well with a role requiring meticulous attention to data integrity and collaborative problem-solving.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical and problem-solving skills through root cause analysis of ETL job failures and optimizing performance. Collaboration with data engineers, BI analysts, DBAs, and stakeholders is consistently mentioned across projects, indicating good teamwork and communication for operational fit. The focus on maintaining test documentation and best practices suggests an organized and process-oriented approach.