Suchitra G P
ETL Tester
Bangalore,TG
Summary
Experienced with data extraction, transformation, and loading processes, ensuring high data quality and accuracy. Utilizes SQL and data validation techniques to streamline data flow and enhance system efficiency. Strong understanding of ETL tools and methodologies, ensuring seamless integration and data integrity.
Overview
4
4
years of professional experience
4
4
Certifications
Work History
ETL Test Engineer
Standard Chartered Bank
01.2023 - 01.2025
- Gathered requirements from Data Engineers via ADO and analysed user stories for test planning.
- Performed manual and automation testing based on requirements documented in Confluence.
- Designed and executed SQL and PySpark test queries including: Count validation, Duplicate checks, Data validation, Structure validation.
- Prepared and executed detailed test cases and test evidence through ADO.
- Collaborated with product owners for SIT handover and test sign-off.
- Conducted PTIA (Performance Testing Impact Assessment) and submitted findings to solution architects.
- Performed regression testing using shell scripts, executed in Unix CMD, and monitored batch processes for troubleshooting.
- Involved in data modelling activities after regression completion and coordinated handover to the solution architect.
- Supported production deployment processes and ensured successful go-live execution.
Data QA Analyst
Gulf Marketing Group
01.2021 - 01.2022
- Used Jira as the primary platform for requirement gathering and tracking.
- Performed ETL processes and validated data pipelines using SQL and Python.
- Wrote medium-complexity SQL and Python queries for data validation and transformation.
- Documented test results and handed them over to clients for review.
- Executed and monitored full batch runs and deployed solutions into production.
- Tools Used: WinSCP, Hue, Putty, SQL, Python
Education
BE - Computer Science
Erode Sengunthar Engineering College
Erode, Tamil Nadu03-2021
Skills
ETL modeling
Regression testing
Data analysis
Data pipeline design
Data modeling
Data warehousing
Scripting languages
Spark framework
Hadoop ecosystem
SQL programming
Agile methodologies
Python
Roles And Responsibilities
- Analyzed business and technical requirements from Data Engineers and stakeholders using ADO and Jira to plan effective ETL testing strategies.
- Designed and executed SQL and PySpark-based data validation including source-to-target checks, count validation, duplicate detection, and schema validation.
- Performed manual and automation testing for large-scale data pipelines across banking and retail domains.
- Developed and maintained test cases, test evidence, and defect reports to support SIT and UAT sign-offs.
- Conducted regression testing and batch job monitoring using Unix and shell scripting, ensuring data accuracy and pipeline stability.
- Executed performance impact assessments (PTIA) and collaborated with solution architects to address scalability concerns.
- Supported production deployments and go-live activities, including batch execution, monitoring, and post-deployment validation.
- Coordinated with cross-functional teams for data modeling validation, handovers, and production support, ensuring high-quality delivery of business-critical data solutions.
Accomplishments
- Delivered end-to-end ETL validation for large-scale banking and retail data pipelines using SQL and PySpark, ensuring high data accuracy, reduced production defects through robust regression testing, and improved batch job reliability via proactive Control-M monitoring and shell scripting.
- Enabled on-time SIT and production releases by providing complete test cases, evidence, and sign-offs through ADO and Jira, while supporting go-live activities with post-deployment validation and minimal business impact.
- Enhanced pipeline scalability and data governance by conducting performance impact assessments (PTIA), contributing to data modelling validation, and collaborating closely with data engineers and solution architects.
Certification
ETL Testing Certification -Trained in complete ETL testing lifecycle, data validation, transformation checks, and workflow testing.
Timeline
ETL Test Engineer
Standard Chartered Bank
01.2023 - 01.2025
Data QA Analyst
Gulf Marketing Group
01.2021 - 01.2022
BE - Computer Science
Erode Sengunthar Engineering College