ETL Testing & Data Quality Assurance Specialist

RANGANATH KUNTUMALLA

Bengaluru, Karnataka r ********************@*****.*** +91-889*******

https://www.linkedin.com/in/ranganath-kuntumalla-5005771a1 Professional Summary

ETL Testing professional with 4+ years of experience in data validation and quality assurance within complex data pipelines. Specialized in cloud-based ETL testing using AWS and Snowflake, with extensive expertise in SQL and Informatica, knowledge in Python and Unix with foundational knowledge of Generative AI and LLM concepts through Google Cloud certification. Successfully optimized testing processes, resulting in a reduction in defect leakage and improved overall data quality. Committed to leveraging automation and best practices to enhance efficiency and mentor junior team members.

Key Highlights

• Hands-on experience in end-to-end ETL testing across source systems, staging and target layers.

• Strong expertise in data reconciliation, aggregation validation and transformation logic testing.

• Hands-on experience in Agile scrum, actively contributing to sprint planning, daily standups.

• Actively involved in knowledge sharing, peer reviews and mentoring junior testers.

• Successfully reduced defect leakage through optimized test case design, negative scenarios, early defect identification.

• Good understanding of data lineage, metadata validation and audit controls.

• Strong knowledge of Data Warehousing concepts including fact tables, dimension tables and Slowly Changing Dimensions (SCD’s).

• Experience working with large data volumes in cloud and on-prem environments.

• Skilled in data governance and compliance validation, ensuring accuracy and consistency of business- critical data.

• Exposure to performance testing of jobs, validating job run times and resource utilization.

• Designed and contributed to automation frameworks using Python and PySpark, Automated SQL-based regression tests reducing manual validation effort and accelerated regression testing.

• Recognized for clear documentation, knowledge sharing and team coordination, ensuring smooth project delivery.

• Performed automated comparison of pre-migration and post-migration datasets to ensure data consistency and integrity for high-volume data loads. Technical Skills

ETL & Data Tools: Informatica, DBT, AWS Glue.

Databases & SQL: Oracle, PostgreSQL, Hive, Snowflake. Programming & Scripting: SQL(Strong), Unix & Python (Working Knowledge). Cloud & Big Data: AWS (S3, EMR, EC2), Spark, PySpark. Testing & QA: Test Planning, Test Case Design, System Testing, Regression Testing, UAT. Defect Tracking & Agile Tools: Jira, Agile Scrum.

Scheduling & Orchestration: IBM Workload Scheduler (TWS), Apache Airflow (Exposure). Utilities & Others: MS Office, Beyond Compare, SFTP. Professional Experience

Tata Consultancy Services (TCS) – Bengaluru, India Test Analyst Aviva UK Life Insurance

Aug 2023 –

• Validated large-scale data movement in Data Lake environments, ensuring accuracy in reporting and analytics.

• Performed data quality validations including record counts, reconciliation, audit logs, nulls and SCD validations.

• Designed and executed complex SQL queries for data validation from source to target systems.

• Conducted functional, regression, integration, functional and UAT Testing across multiple ETL workflows.

• Improved test coverage by designing comprehensive test plans, test data and scenarios.

• Performed data quality check (counts, audit logs, transformations) across multiple Data Lake layers.

• Coordinated defect triage meetings with cross-functional teams, reducing resolution time.

• Reduced defect leakage by ~25% through improved test case design and early defect identification.

• Worked in Agile scrum framework, actively involved in sprint ceremonies and client interactions. ETL Tester British Telecom

March 2022 – May 2023

• Tested ETL processed migrating satellite data from flat files into Oracle Data Warehouse.

• Designed and executed test cases and test scenarios based on business requirements.

• Performed SQL validations for dimension and fact tables using complex queries.

• Ensured data mapping accuracy between source and target systems.

• Delivered daily test reports and collaborated with developers for defect resolution. Education

BE/BTech in Electronics and Communication Engineering Jawaharlal Technological University, Anantapur

2016–2020

Additional Information

Learning & Growth:

• Actively upskilling in Python, AWS Glue, PySpark, Apache Airflow and cloud based ETL automation to support modern data platforms and orchestration frameworks. Professional Strengths:

• Strong analytical and problem-solving skills with expertise in root cause analysis using SQL, Logs and recon outputs.

• Effective collaborator with experience working across QA, development and business stakeholders in Agile model. Languages:

English (Professional), Telugu (Native), Kannada (Basic), Hindi (Basic). Aug 2026

Contact this candidate