Radha Krishna Addagalla
Data Test Lead
Sydney
Summary
Highly experienced Data Test Lead with over 11 years of expertise in ensuring data quality, integrity, and performance across diverse data ecosystems. Proficient in advanced SQL scripting, Azure Databricks, Azure Cosmos DB, and API testing using JavaScript. Demonstrated ability to lead cross-functional teams, automate testing processes using FinalBuilder and QuickTest top;, and deliver reliable data solutions that drive business insights and operational efficiency. Adept at optimizing ELT/ETL pipelines, conducting comprehensive data validation, and leveraging modern data technologies to solve complex data challenges.
Overview
11
11
years of professional experience
Work History
Data Test Lead
AEMO
2 2022 - Current
- Managing team of Ten by coordinating with client and onshore team members.
- Responsible for various phases of Testing: Functional Testing, End to End Testing, End user Acceptance testing.
- Responsible for Preparing Test estimation, Testing strategy, Test scripts, Test plans, and Test Summary reports for complex Data migration. Data transformation and ETL and data warehouse projects.
- Primary point of contact for all testing activities.
- Automating Data testing using Final Builder, Quick Test automation tools.
- Perform root cause analysis on data discrepancies and provided recommendations for data quality improvements.
- Utilize data technologies such as Azure databricks and SQL to test and validate structured and unstructured data in distributed systems.
- Responsible for developing SQL queries and ETL scripts for querying data against Azure databricks for data verification process and Source to Target mappings.
- Responsible for validating source to target mapping rules for different types of source/targets i.e., data base/file/excel to data base/file/excel.
- Involved in testing of data from multiple systems to cloud platforms like Azure cosmos DB using Azure data factory.
- Utilized SQL API and other Cosmos DB interfaces to validate data operations and queries, ensuring they meet performance and accuracy criteria.
Data Test Lead
Westpac
2017.02 - 2 2022
- Managed team of Eight by coordinating with onshore and offshore stakeholders.
- Responsible for various phases of Testing: Functional Testing, End to End Testing, End user Acceptance testing.
- Responsible for Preparing Test estimation, Testing strategy, Test scripts, Test plans, and Test Summary reports for complex data migration. data transformation and ETL and data warehouse projects.
- Primary point of contact for all the testing activities.
- Designed and implemented scalable data pipelines in Azure Databricks for processing large datasets, ensuring data integrity and performance.
- Developed and executed complex SQL queries and Spark jobs within Databricks to validate data transformations and ensure accuracy.
- Leveraged Databricks notebooks for automated data validation and quality checks, improving the efficiency of the testing process.
- Coordinated with data engineers to optimize ETL workflows and troubleshoot data issues in the Databricks environment.
- Automated data integration and testing workflows using FinalBuilder, significantly reducing manual intervention and errors.
- Developed custom SQL scripts/ windows batch scripts and build processes in FinalBuilder to automate the deployment and testing of ETL pipelines
- Integrated FinalBuilder with version control systems and CI/CD pipelines to streamline data testing and deployment processes
- Monitored and maintained automated jobs, ensuring timely execution and accurate results.
- Performed comprehensive testing of data stored in Azure Cosmos DB, ensuring data consistency, availability, and performance.
- Utilized SQL API and other Cosmos DB interfaces to validate data operations and queries, ensuring they meet performance and accuracy criteria.
- Designed and implemented automated testing frameworks for Cosmos DB to validate data replication, partitioning, and indexing.
- Collaborated with development teams to optimize Cosmos DB configurations and resolve data-related issues.
Test Analyst
Infosys
2015.02 - 2017.02
- Prepares test plans, Test cases and test summary reports for all data projects
- Developed complex SQL queries for data validation, reporting, and analysis, ensuring high performance and accuracy across large datasets.
- Utilized advanced SQL techniques such as window functions, common table expressions (CTEs), and sub queries to solve complex data challenges and optimize query performance.
- Created stored procedures, and views to prepare test data, automate repetitive data tasks and enhance database functionality.
- Conducted performance tuning and optimization of SQL queries, reducing execution times by up to 50%.
- Leveraged SQL for ETL processes, transforming and loading data from various sources into data warehouses.
- Collaborated with data engineers and developers to design and implement robust database schemas that support scalable applications.
- Automated data quality checks using SQL scripts, reducing manual verification efforts by 70% and ensuring consistent data accuracy.
- Developed dynamic SQL scripts to handle various data scenarios, enhancing flexibility and adaptability of data processing pipelines.
Associate Software Engineer
Tech Mahindra Pvt. Ltd.
2013.10 - 2014.12
- Prepared Test cases by understanding functional requirements
- Developed complex SQL queries for data validation, reporting, and analysis, ensuring high performance and accuracy across large datasets.
- Utilized advanced SQL techniques such as window functions, common table expressions (CTEs), and sub queries to solve complex data challenges and optimize query performance.
- Leveraged SQL for ETL processes, transforming and loading data from various sources into data warehouses.
- Collaborated with data engineers and developers to design and implement robust database schemas that support scalable applications.
- Automated data quality checks using SQL scripts, reducing manual verification efforts by 70% and ensuring consistent data accuracy.
- Developed dynamic SQL scripts to handle various data scenarios, enhancing flexibility and adaptability of data processing pipelines.
Education
Bachelor of Science -
Jawaharlal University of Technology
IndiaSkills
JavaScript
My SQL, Oracle, PostgreSQL
ALM, PractiTest, JIRA, Confluence
Putty, Control M, SMD, Informatica, Foxe, Soap UI, Post man, ETL automation
Windows batch scripting
SQL Scripts to create huge volume of data
Teradata, Big data
Azure Cosmos DB
Azure databricks
Final builder to Automate data validations
QuickTest to automate Data testing
Visastatus
Permanent Resident
Personal Information
- Date of Birth: 24th July 1992
- Gender: Male
- Nationality: Indian
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Timeline
Data Test Lead
Westpac
2017.02 - 2 2022
Test Analyst
Infosys
2015.02 - 2017.02
Associate Software Engineer
Tech Mahindra Pvt. Ltd.
2013.10 - 2014.12
Data Test Lead
AEMO
2 2022 - Current
Bachelor of Science -
Jawaharlal University of Technology
Similar Profiles
Rebecca AhmedRebecca Ahmed
Principal Consultant at Australian Energy Market Operator (AEMO)Principal Consultant at Australian Energy Market Operator (AEMO)
Xinjian WangXinjian Wang
Intern at Sichuan Huakun Zhenyu Intelligent TechnologyIntern at Sichuan Huakun Zhenyu Intelligent Technology
Simone TregnagoSimone Tregnago
Intern at Fanin S.p.a.Intern at Fanin S.p.a.