Pranali Awari

Data Quality Engineer with 5 years of experience in ETL and Data Warehouse testing across banking and insurance domains for US and Australian clients. Experienced in end-to-end ETL validation, source-to-target data validation, data reconciliation, incremental data load validation, and large-scale data migration, with SQL expertise (Teradata, PostgreSQL) for validating data accuracy, completeness, consistency, and integrity. Currently involved in enterprise data warehouse testing, supporting batch processing and production data validation through Control-M, ESP, Mainframe, and Informatica log analysis to ensure reliable, high-quality data delivery.

Skilled in analyzing complex data mappings, validating transformation rules, performing root cause analysis of data issues, and collaborating with cross-functional teams to deliver trusted data for business-critical decisions. Contributed to AI-assisted automation initiatives within the EDW testing team, using GitHub Copilot and Claude to enhance test case generation and testing utilities.

Quality Engineering Analyst - Infosys - Pune

(2025-11)

Client: Westpac Banking Corporation (Australia)

• Performed end-to-end ETL and Data Quality validation across enterprise data warehouse systems, validating source-to-target transformations, data reconciliation, incremental data loads, and business rules to ensure data accuracy, completeness, consistency, and integrity across multiple data layers.
• Executed, monitored, and validated enterprise batch pipelines using Control-M, ESP, and Mainframe, performing job scheduling, reruns, and production data validation while analyzing Informatica and batch logs to investigate failures, identify dependency issues, and perform root cause analysis.
• Performed complex data validation using Teradata SQL, validating transformation logic, aggregation rules, and source-to-target reconciliation across millions of records to ensure reliable downstream reporting and business-critical data accuracy.
• Independently managed end-to-end testing across multiple concurrent projects and data streams by analyzing mapping documents, DTDs, and impact assessments, designing test scenarios, and delivering high-quality releases within project timelines.
• Contributed to automation initiatives within the EDW testing team, leveraging GitHub Copilot and Claude to develop and enhance utilities for test case generation, run-sheet generation, SQL execution, result validation, and standardized test reporting.

Custom Software Engineering Analyst - Accenture - Mumbai

(2022-12 - 2025-11)

Client: Challenger Limited (Australia) – Insurance

• Led ETL and DWH testing for migration from legacy systems to the ALIP platform, ensuring accurate data transformation and end-to-end validation, including validation of data across AWS staging and downstream layers.
• Designed and executed detailed test scenarios based on complex mappings, performing extensive data validation using advanced SQL, while handling both ETL and functional testing to ensure alignment between UI, backend data, and business requirements.
• Acted as a hybrid QA & Business Analyst, contributing to requirement analysis, mapping validation, and defect analysis, collaborating with cross-functional teams to identify & resolve discrepancies, actively participating in defect triage discussions.
• Extensively used Jira for test case management, bulk uploads, execution tracking, and end-to-end defect lifecycle management, including JQL-based reporting and coordination with stakeholders.
• Acted as a key contributor within the team by guiding junior members and sharing knowledge on ETL testing approaches, improving overall team efficiency and delivery quality.

Application Development Associate - Accenture - Mumbai

(2021-07 - 2022-11)

Client: Allstate Benefits (US – Group Life)

• Quickly developed a strong understanding of the insurance domain and testing processes during initial project exposure, demonstrating fast learning ability and adaptability in a new environment.
• Executed structured test cases and performed backend validations based on data mappings & requirements, while working on the EIS platform for functional and regression testing of group life insurance products across multiple state variations.
• Validated end-to-end policy lifecycle, ensuring consistency between UI, backend data, XML/JSON payloads, and generated outputs, building a solid foundation in testing lifecycle, defect tracking, and quality assurance practices.

Bachelor of Engineering - Information Technology - University of Mumbai (2021-06)