revathy sankaran
ETL Tester
About
ETL Tester with 5 years of IT experience in ETL Testing, Data Validation, Database Testing, and Data Quality across Banking and Retail domains. Experienced in validating ETL workflows, performing source-to-target data validation, data reconciliation, and database testing using SQL. Strong expertise in analysing business requirements, preparing test scenarios, executing ETL test cases, and ensuring data accuracy, completeness, and integrity. Proficient in writing complex SQL queries for backend validation, identifying data discrepancies, and tracking defects using JIRA. Skilled in Python for test automation and data validation with hands-on experience in Informatica, Talend, Airflow, Autosys, AWS, SQL, and Power BI. Good understanding of SDLC, STLC, Agile methodology, and Defect Life Cycle with excellent analytical, problem-solving, and communication skills.
Skills & Expertise (20)
Work Experience
ETL Tester
ILINK SYSTEMS AND DIGITAL SOLUTION
May 2024 - Present
Validated end-to-end ETL workflows by reviewing Business Requirement Documents (BRD), Functional Requirement Documents (FRD), and Source-to-Target (S2T) mapping documents. Created detailed ETL test cases to verify data extraction, transformation, and loading processes. Performed comprehensive data validation using SQL by comparing source and target systems. Verified data completeness, accuracy, data quality, business rules, and transformation logic across multiple warehouse tables. Executed Functional Testing, System Integration Testing (SIT), Regression Testing, and User Acceptance Testing (UAT). Identified defects, logged issues in JIRA, collaborated with developers, and validated fixes through retesting. Validated scheduled ETL batch jobs executed through AutoSys and monitored Talend data integration workflows. Ensured successful job execution, analysed ETL logs, and confirmed data availability within defined SLA timelines. Prepared daily and weekly test execution reports, defect summaries, and data validation dashboards using Power BI. Worked closely with business analysts, developers, and stakeholders to ensure high-quality releases and successful production deployments.
ETL Tester
ILINK SYSTEMS AND DIGITAL SOLUTION
Apr 2021 - Mar 2024
Validated end-to-end data migration by reviewing Business Requirement Documents (BRD), Functional Requirement Documents (FRD), and Source-to-Target (S2T) mapping documents. Designed ETL test cases to verify accurate migration of customer, account, and transaction data. Performed source-to-target data validation using SQL by comparing records between legacy systems and Snowflake. Verified data completeness, transformation logic, referential integrity, and reconciliation of financial data after migration. Executed Functional Testing, System Integration Testing (SIT), Regression Testing, and User Acceptance Testing (UAT). Identified defects, documented issues, coordinated with developers, and validated fixes before production deployment. Monitored ETL workflows developed in Informatica and scheduled through Airflow on AWS. Analysed job execution logs, resolved data load failures, and ensured successful batch processing within defined SLA timelines. Supported data reconciliation and reporting by using Python scripts and SQL queries to identify data mismatches and validate financial balances. Prepared test summary reports, defect metrics, and collaborated with business stakeholders to ensure data accuracy.
Education
Master of Business Administration - Bharathidasan University
2014 - 2016 · Afghanistan
Bachelor of Computer Applications - A.V.C College of (Autonomous)
2011 - 2014 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (20)
Click a skill to find developers with the same skill
