I am a Senior ETL Test Engineer with ~8 years of experience in Data Warehousing, ETL testing, and development. I have hands-on experience with Informatica, SSIS, Teradata, Oracle, Snowflake, Azure Data Warehouse, and MS SQL Server. I am Snow Pro Core and ISTQB Foundation certified, and I completed Python training to support automation. I have worked across Finance, Banking, and Healthcare domains, collaborating with stakeholders to gather requirements and drive high-quality data solutions. I excel in end-to-end ETL testing, including data extraction, transformation, loading, mapping, and back-end validation, plus test strategy, release planning, and status reporting. I am proficient with dashboard validation (Power BI, Qlik Sense/View), data migration/testing, and defect tracking using JIRA, HP ALM, and Azure DevOps. I also have experience with job scheduling tools and data integration platforms such as Informatica, SSIS, and DataStage, and I am comfortable with UNIX-based test data prep and scripting in Python.

Santhiya Hariharan

I am a Senior ETL Test Engineer with ~8 years of experience in Data Warehousing, ETL testing, and development. I have hands-on experience with Informatica, SSIS, Teradata, Oracle, Snowflake, Azure Data Warehouse, and MS SQL Server. I am Snow Pro Core and ISTQB Foundation certified, and I completed Python training to support automation. I have worked across Finance, Banking, and Healthcare domains, collaborating with stakeholders to gather requirements and drive high-quality data solutions. I excel in end-to-end ETL testing, including data extraction, transformation, loading, mapping, and back-end validation, plus test strategy, release planning, and status reporting. I am proficient with dashboard validation (Power BI, Qlik Sense/View), data migration/testing, and defect tracking using JIRA, HP ALM, and Azure DevOps. I also have experience with job scheduling tools and data integration platforms such as Informatica, SSIS, and DataStage, and I am comfortable with UNIX-based test data prep and scripting in Python.

Available to hire

I am a Senior ETL Test Engineer with ~8 years of experience in Data Warehousing, ETL testing, and development. I have hands-on experience with Informatica, SSIS, Teradata, Oracle, Snowflake, Azure Data Warehouse, and MS SQL Server. I am Snow Pro Core and ISTQB Foundation certified, and I completed Python training to support automation. I have worked across Finance, Banking, and Healthcare domains, collaborating with stakeholders to gather requirements and drive high-quality data solutions.

I excel in end-to-end ETL testing, including data extraction, transformation, loading, mapping, and back-end validation, plus test strategy, release planning, and status reporting. I am proficient with dashboard validation (Power BI, Qlik Sense/View), data migration/testing, and defect tracking using JIRA, HP ALM, and Azure DevOps. I also have experience with job scheduling tools and data integration platforms such as Informatica, SSIS, and DataStage, and I am comfortable with UNIX-based test data prep and scripting in Python.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate

Language

English
Fluent

Work Experience

Sr. ETL Tester at Aventure Systems
March 1, 2025 - Present
Collaborated in release planning, gathered requirements, and performed data mapping to ensure accuracy between source and target systems. Designed and executed SQL queries to validate data in target tables per test cases. Created and maintained key project documents (Weekly/Daily Status Reports, Test Traceability Matrix, Sprint Review summaries). Used Microsoft Azure DevOps to manage test cases, defects, and user stories. Participated in System Integration Testing (SIT), reported defects, and conducted retesting after fixes. Assisted in scheduling jobs in the UAT environment and supported UAT testing with mock data and data loads. Contributed to the development of Release Test Plans and Master Test Plans.
Sr. ETL Tester at GLAXO SMITHKLINE
September 1, 2021 - May 1, 2023
Analyzed Functional Design Documents (FDD) and Business Requirement Documents (BRD) for Power BI dashboards to understand system workflows and business rules. Conducted detailed data mapping between source systems (Workday, Oracle, FTP servers) and target systems (Azure Cloud Data Warehouse). Designed, prepared, and executed test scenarios and SQL queries to verify data integrity. Participated in alignment calls with development teams and business stakeholders, ensuring clear understanding of reporting requirements. Attended weekly stand-up meetings to ensure timely updates and cross-functional collaboration. Validated data migration and transformation across source systems into Azure Cloud; ensured data completeness by comparing Power BI outputs with Azure data. Tracked, reported, and validated defects using HP ALM, prepared Weekly Status Reports, and supported team during critical phases of test execution.
Senior Tester at The Royal Bank of Scotland
August 1, 2020 - January 1, 2021
Participated in Release Planning to understand project requirements and business objectives. Collaborated with Business Analysts to gain a clear understanding of data entities and their functional relevance. Created and loaded test data, prepared and executed SQL queries to verify target tables, and validated data entities in the RP2 environment to ensure readiness for production deployment. Participated in alignment calls with development teams and stakeholders for in-depth understanding of entity structures. Created and executed SQL scripts to support data validation and tracked defects using JIRA, ensuring timely resolution and retesting. Delivered knowledge transfer sessions on SSIS package creation and SQL scripting; maintained collaborative team environment, assisting teammates in meeting scripting deadlines during peak periods.
Senior ETL Tester at PHILIPS - Health Care Services
April 1, 2017 - July 1, 2020
Participated in Release Planning meetings to gather project requirements and understand business needs. Analyzed existing systems and business rules to support accurate testing and validation. Conducted data mapping between source and target systems, including dimensional and fact tables. Prepared Test cases, designed and executed SQL queries to verify Target, Dimensional, and Fact Tables. Actively participated in daily Scrum, Sprint Planning, Sprint Review, Product Backlog Refinement, Sprint Retrospective, and Scrum of Scrums. Prepared and maintained key deliverables including Weekly Status Reports, Daily Status Reports, Test Traceability Matrix, and Sprint Review documentation. Tracked test cases, defects, and user stories using Microsoft Azure DevOps for test management and traceability. Validated flat files using UNIX commands; used WinSCP for parameter file changes and reviewed session/workflow logs and source files. Participated in SIT, data loads in UAT, and supported release te
Developer at HSBC Banking & Finance
September 1, 2015 - December 1, 2016
Participated in Release Planning sessions to understand project requirements. Analyzed data mapping for both source and target systems. Developed BTEQ scripts for data transformation and loading. Performed code deployments to SIT and UAT environments, ensuring environment readiness. Configured, scheduled, and monitored batch jobs using Control-M for automation. Executed data loads to support business validations and functional testing. Created Change Requests (CRs) for production cutovers with detailed back-out plans. Engaged in testing, debugging, and problem-solving throughout development and QA cycles. Participated in production deployment and post-deployment support. Logged SIT and UT defects using Quality Controller tools. Worked with HSBC’s CIM tool for campaign execution and management activities.

Education

M. Tech in Software Engineering at BITS, PILANI
January 11, 2030 - May 12, 2026
Bachelor of Science in Information Technology at Nallamuthu Gounder Mahalingam College, Pollachi, Coimbatore
January 11, 2030 - May 12, 2026

Qualifications

Snow Pro Core Certified
January 11, 2030 - May 12, 2026
ISTQB Foundation Level Certified
January 11, 2030 - May 12, 2026
Python training
January 11, 2030 - May 12, 2026

Industry Experience

Software & Internet, Financial Services, Healthcare, Professional Services, Media & Entertainment