Manaswini Dudam

Detail-oriented ETL & Automation Test Engineer with 5+ years of experience in data validation, ETL testing, and system integration testing within banking and financial services environments. Strong expertise in SQL, data warehousing concepts, ETL validation, and defect lifecycle management, with hands-on exposure to automation using Selenium (Java), Python basics, and API testing. Proven ability to ensure data accuracy, integrity, and reliability across large datasets while working in Agile delivery models and client-facing projects.

Associate Consultant - Capgemini - Pune, India

(2021-04)

Domain: Banking. Client: Barclays – Investment Banking

• Executed end-to-end ETL testing for large-scale banking data pipelines, validating data flow from source systems to target data warehouses, ensuring 99%+ data accuracy.
• Designed and executed complex SQL queries to perform data reconciliation, count validation, referential integrity checks, null checks, and business rule validations across high-volume datasets.
• Performed System Integration Testing (SIT) and regression testing across DEV/SIT environments, identifying and resolving data mismatches and transformation issues early in the release cycle.
• Validated newly introduced functionalities and enhancements in both database and UI layers, ensuring seamless reflection of backend data on reporting and portal applications.
• Created and maintained detailed test cases, test scenarios, and execution reports, achieving timely Dev/BA sign-offs for each release.
• Actively contributed to defect management lifecycle, logging, tracking, retesting, and closing defects using JIRA and HP ALM, reducing production data issues.
• Supported automation initiatives using Selenium (Java) and assisted in Python-based test scripting to improve regression coverage and execution efficiency.
• Collaborated with cross-functional teams including developers, business analysts, and data engineers in an Agile setup, ensuring on-time delivery under tight SLAs.
• Mentored and guided new joiners, helping them onboard faster on ETL testing processes, SQL validations, and project-specific data models.
• Participated in requirement walkthroughs and impact analysis discussions to understand upstream and downstream data dependencies before test execution.

Bachelor of Technology (B.Tech) - Electronics & Communication Engineering - Stanley College of Engineering & Technology for Women (OU) (2016 - 2020)