I am a detail-oriented Software Development Engineer in Test (SDET) with 14+ years of experience in end-to-end testing across front-end UI, backend APIs, and data layers, ensuring reliable releases for complex financial systems. I have led test automation initiatives across UI, API, and ETL to deliver high-quality software. I design robust test automation frameworks (UI, API, ETL) using Selenium, Playwright (TypeScript), Pytest, and PySpark, and drive continuous testing through CI/CD pipelines (Jenkins, Git, Maven). I bring strong expertise in data warehousing, data validation with advanced SQL, and REST API validation, complemented by leadership and stakeholder collaboration in Agile/DevOps environments.

Mayuri Pednekar

I am a detail-oriented Software Development Engineer in Test (SDET) with 14+ years of experience in end-to-end testing across front-end UI, backend APIs, and data layers, ensuring reliable releases for complex financial systems. I have led test automation initiatives across UI, API, and ETL to deliver high-quality software. I design robust test automation frameworks (UI, API, ETL) using Selenium, Playwright (TypeScript), Pytest, and PySpark, and drive continuous testing through CI/CD pipelines (Jenkins, Git, Maven). I bring strong expertise in data warehousing, data validation with advanced SQL, and REST API validation, complemented by leadership and stakeholder collaboration in Agile/DevOps environments.

Available to hire

I am a detail-oriented Software Development Engineer in Test (SDET) with 14+ years of experience in end-to-end testing across front-end UI, backend APIs, and data layers, ensuring reliable releases for complex financial systems. I have led test automation initiatives across UI, API, and ETL to deliver high-quality software.

I design robust test automation frameworks (UI, API, ETL) using Selenium, Playwright (TypeScript), Pytest, and PySpark, and drive continuous testing through CI/CD pipelines (Jenkins, Git, Maven). I bring strong expertise in data warehousing, data validation with advanced SQL, and REST API validation, complemented by leadership and stakeholder collaboration in Agile/DevOps environments.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

Javanese
Fluent
English
Fluent

Work Experience

Career Break
August 1, 2023 - Present
Maternity break; continued learning in Selenium, Pytest, Python, SQL, and AWS.
Principal Engineer – Data Test Lead at Derisk360 (Client: NatWest Group)
May 1, 2021 - August 1, 2023
Designed automated test suites for ETL, APIs, and data validation. Increased test coverage from 0% to 95%. Published long-term Data & Analytics test strategy. Automated REST API tests using Python + Pytest. Integrated automation with Jenkins.
Associate Director – Database Test Manager at UBS Business Solutions, Pune
May 1, 2019 - April 1, 2020
Led QA team of 10+ engineers. Defined test plans & ETL test-first strategy. Built SQL libraries for transformation validation. Developed ETL automation integrated with Git & TeamCity.
Associate Engineer – ETL & Automation at Deutsche Bank (DBOI), Pune
June 1, 2018 - May 1, 2019
Tested Treasury Data Hub pipeline & regulatory reporting. Built SQL automation frameworks. Developed UI/API tests using Selenium & REST Assured.
Test Lead at Wipro Technologies (Credit Suisse), Pune
December 1, 2015 - June 1, 2018
Led SIT/UAT/ETL testing. Automated Selenium TestNG framework. Validated SAP BO reports.
Test Lead at BMC Software, Pune
January 1, 2007 - February 1, 2014
ETL & report testing (ODI, Pentaho, SQL). Automated UI tests (Selenium + Java). Mentored testers.
Test Analyst at Wipro Technologies, Bangalore
July 1, 2005 - January 1, 2007
Firmware testing & automation scripts (Perl/Shell/TCL).
Principal Engineer – Data Test Lead at Derisk360
May 1, 2021 - August 1, 2023
Led a team of 4 testers in validating ETL jobs and batch pipelines using Informatica, PySpark, and Kafka. Built modular PySpark-based ETL automation framework, improving regression cycle by 40%. Automated REST API validations using Python (Requests, Pytest). Developed UI automation using Playwright with TypeScript, enabling faster and more reliable cross-browser testing. Designed reusable page objects and test utilities in Playwright, improving maintainability and execution speed. Integrated UI, API, and ETL tests into CI/CD pipelines (Jenkins) and authored automated test reports. Increased test coverage from 0% to 95%, reducing production defects. Created schema checks, transformation rule tests, and dummy test datasets.
Associate Director – Database Test Manager at UBS Business Solutions Pvt. Ltd.
May 1, 2019 - April 30, 2020
Managed QA team of 10+ engineers; defined test plans and led end-to-end test execution. Designed and executed comprehensive test plans (unit, integration, regression) for a Java–SQL ETL tool ensuring accurate extraction, transformation and loading of enterprise data. Built reusable SQL queries to verify data integrity, check row-level transformations and confirm end-to-end data completeness. Developed automated tests in Java and SQL scripts to validate complex transformation logic and stored procedures. Enhanced regression testing using reusable test components integrated with TeamCity and Git. Collaborated with stakeholders to define the test objectives, organizational test policies, test strategies and test plans in an Agile development environment.
Associate Engineer – ETL and Automation Engineer at Deutsche Bank (DBOI)
June 1, 2018 - May 1, 2019
Planned and led end-to-end testing of the Treasury Data Hub (TDH) pipeline, validating adjusted feeds from the Stewardship application through transformation in Saturn Data Warehouse to SAP BO regulatory reports. Designed and executed test strategy and test cases covering data extraction, transformation logic, and regulatory reporting requirements. Developed and reviewed automated SQL validation scripts to ensure data integrity, completeness, and accuracy across TDH and Saturn layers. Coordinated a distributed testing team, managing task allocation, defect triage, and stakeholder reporting to meet project timelines. Collaborated with business, development, and reporting teams to clarify business rules, resolve data issues, and ensure regulatory compliance. Developed and maintained UI/API automation using Selenium and REST Assured in BDD (Cucumber).
Test Lead at Wipro Technologies (Client: Credit Suisse)
December 1, 2015 - June 1, 2018
Managed SIT, UAT, regression, and ETL testing efforts in Risk and Finance domain. Automated UI testing using Selenium (Hybrid + POM) and TestNG. Validated reporting through SAP BO and ETL data pipelines via Informatica. Led Intellimatch reconciliation testing and coordinated UAT support. Created reusable components and test scenarios; guided junior testers. Automated testing components and ensured alignment with Agile processes.
Test Lead at BMC Software
January 1, 2007 - February 1, 2014
Oversaw ETL testing for BMC Reporting Products using ODI, Pentaho, and SQL. Performed Cognos report validation, cross-product integration testing, and API verifications. Mentored 6 testers, trained new team members, and coordinated testing with US stakeholders. Automated UI tests with Selenium + Java and managed test strategy & scheduling.
Test Analyst at Wipro Technologies-Bangalore
July 1, 2005 - January 1, 2007
Executed firmware validation for MFP products: memory, duration, and performance testing. Authored Perl, Shell, and TCL scripts for automation. Handled defect triage and collaborated closely with development teams. Played a key role in test lab setup and hardware-software integration testing.

Education

B.E. Electrical Engineering at University of Mumbai
January 11, 2030 - January 1, 2004
Bachelor of Engineering (B.E.), Electrical Engineering at University of Mumbai
January 11, 2030 - January 1, 2004

Qualifications

ISTQB Certified Tester – Foundation Level
January 11, 2030 - December 8, 2025
AWS Certified Cloud Practitioner
January 11, 2030 - December 8, 2025
Certified Scrum Master (CSM)
January 11, 2030 - December 8, 2025
ISTQB Certified Tester – Foundation Level
January 11, 2030 - April 23, 2026
AWS Certified Cloud Practitioner
January 11, 2030 - April 23, 2026
Certified Scrum Master (CSM)
January 11, 2030 - April 23, 2026

Industry Experience

Financial Services, Software & Internet, Professional Services, Other