Kavita Sood
Ontario,Canada
Summary
With over 10 years of diverse domain experience in Health Care, Financial Tech, Insurance, Telecommunications, Anti- Money Laundering (AML) and Salesforce, I bring expertise in ETL testing, Data Analysis, Automation (E2E, API), and AI/ML testing Using Python, JavaScript, and Java for automation and data analysis tasks. Skilled in Azure DevOps, Git-based CI/CD pipelines, and a range of testing frameworks including Playwright, Cypress, Appium and Selenium WebDriver. Proficient in WCAG 2.0 standards and experienced in client-facing roles, I am committed to delivering high-quality solutions tailored to meet client needs.
Overview
20
20
years of professional experience
1
1
Certification
Work History
QA Analyst and ETL Testing and Automation
ScotiaBank
10.2024 - Current
- The project involved validating ETL pipelines designed to ingest, clean, transform, and load invoicing data from multiple sources into a centralized data warehouse (Google BigQuery)
- The objective was to enable advanced business analytics and reporting for decision-making by management teams
- The data originated from various structured and unstructured sources, including APIs, Oracle databases, and Parquet files, with data volumes ranging from 700 GB to 1 TB
- Conducted validation of ETL pipelines built using IBM DataStage and integrated with Airflow and Databricks workflows
- Wrote and executed SQL queries to validate data integrity, completeness, and accuracy after each ETL run
- Performed reconciliation checks between the source and target data using QuerySurge
- Verified transformation logic by cross-checking data mappings and business rule adherence
- Validated data processing performance with large datasets in Data Lakes
- Ensured ETL pipelines scaled effectively for high data volumes using PySpark
- Tested data integration with cloud platforms such as Azure and AWS
- Validated data movement across distributed systems using cloud services and ensured compliance with data security standards
- Implemented validation rules for detecting duplicates, null values, and inconsistent records
- Collaborated with data stewards and business analysts to resolve data anomalies
- Integrated ETL test execution within Jenkins pipelines for continuous validation
- Automated tests using QuerySurge and validated deployment pipelines following CI/CD methodologies
- Validated ETL jobs in containerized environments using Docker and Kubernetes
- Ensured proper deployment and functioning across virtualized environments
- Generated detailed test reports highlighting discrepancies, failures, and pass rates for each ETL run
- Documented test cases, workflows, and issue resolution logs
- Successfully automated more than 95% of ETL test cases, improving testing efficiency and reducing manual effort
- Validated high-volume data processing workflows, ensuring no data loss during pipeline runs
- Improved data accuracy through comprehensive validation checks, reducing production errors by 20%
- Testing with large datasets across distributed systems with varying data formats
- Managing integration dependencies between multiple upstream and downstream systems across cloud platforms
ETL Tester - SDET
Fundthrough Inc.
07.2023 - 07.2024
- Developed a robust Robot framework using Python, increasing test coverage from 10% to 50%
- Wrote well-documented, maintainable code for a Python Automated E2E Test Framework
- Leveraged Python libraries for API testing, including intercept and route, creating mocks, schema validation, and contract testing
- Provided solutions to automation challenges and supported team members as needed
- Worked on environment where is been used to design, implement, and execute ETL workflows, involved in in verification of data extraction, transformation, and loading processes from various source systems into the data warehouse
- Performed ETL testing using Hadoop for large-scale data processing, validating data ingestion, transformation, and storage within the Hadoop ecosystem
- Collaborated with data engineers to ensure accurate and efficient handling of big data through HDFS, Hive, and Pig
- Performed database testing using complex SQL queries to validate data migration for invoices in Quickbooks
- Performed load testing and performance monitoring using JMeter with different data size while migration and simulating it for bigger migration
- Used CloudWatch for AWS infrastructure monitoring and New Relic for application performance monitoring, identifying performance-related issues and analyzing improvements after fixes
- Worked in Agile environment, collaborating with cross-functional teams to continuously monitor and improve systems
- Supported the team through active involvement in sprint planning, testing cycles, and delivering high-quality automation solutions
- Identified reporting requirements, configured Oracle Fusion Cloud ERP and BI Publisher, designed and developed reports for regulatory purposes
- Implemented incremental data loads, deployed reports, and provided ongoing support for report generation using Oracle Fusion
SDET- ETL Tester
CRATE
07.2022 - 07.2023
- Leading payment domain testing with FinTech that utilize the SWIFT network for interbank communication and transactions
- This includes ensuring that systems are compliant with SWIFT messaging standards, understanding the specific workflows and protocols associated with SWIFT transactions, and possibly integrating or testing systems that interact with the SWIFT network
- Performing ETL testing using Informatica PowerCenter and Apache NiFi to extract financial data from transaction databases and market APIs
- Conduct database testing, data cleansing, and transformation using SQL queries and scripting languages like Python, ensuring adherence to data quality standards before loading into the Data Warehouse
- API - Schema Validation and Contract Testing using mocks created using jest and Super Test libraries
- Instrument code to find out code coverage and publish report to create future target to increase test coverage
- Quickly identify Failed Tests during code deployment in CI/CD and provide solution to Fix
- Created and implemented effective BRDs by analyzing business requirements, developing Test Strategies, Test planning, Test Case Design, Test Data, Test Execution Cycles, Defect reporting and Tracking
- Utilized AWS Cloud services such as AWS Lambda, S3, and RDS to enhance payment processing efficiency and scalability
- Implemented secure and scalable testing environments on AWS Cloud, ensuring robust and reliable payment module testing
Technical Quality Analyst
TCS Canada - CIBC Bank
05.2021 - 07.2022
- Performed ETL testing using Hadoop for large-scale data processing, validating data ingestion, transformation, and storage within the Hadoop ecosystem
- Collaborated with data engineers to ensure accurate and efficient handling of big data through HDFS, Hive, and Pig
- Performed database testing by writing complex queries to ensure proper data migration and transformation
- Conducted web automation using Robot Framework with Python
- Automated API testing using the Python Request library
- Facilitated meetings and coordinated with project stakeholders
- Executed automated tests and generated reports using CI/CD pipelines with Jenkins
- Designed test strategies, plans, test cases, and executed them while tracking defects
- Participated in backlog refinement and suggested stories for upcoming sprints
- Contributed to devising a comprehensive test strategy for Google Kubernetes Engine (GKE) and conducted rigorous testing for Google Cloud Platform (GCP) migration initiatives
- Identified and resolved issues related to load testing, ensuring optimal performance and scalability of applications on GKE
- Deployed the latest SIT code to the Master branch and analyzed automated sanity testing reports daily
- Offered solutions to the team for automation challenges
- Utilized Python libraries such as panda and pytesseract for effective optical character recognition (OCR) in desktop-based applications with embedded chromium, where selectors were not exposed
- Used Google Analytics to track traffic and user interactions on the portal to monitor user engagement with articles, videos, or health resources to understand which content is most popular among patients and healthcare professionals
SDET
Publics Sapient
11.2018 - 07.2020
- Developed automation script for trade capture and trade workflow for MarkitWire, which is a platform used worldwide by banks, dealers, inter-dealer brokers, prime brokers and buy-side clients, to exchange trade data and confirm over-the-counter (OTC) transactions to achieve straight through processing
- Adept at implementing ETL (Extract, Transform, Load) processes to efficiently ingest, cleanse, and transform Big data from diverse sources into the data warehouse using complex SQL / SOQL queries and data visualization tools i.e
- Power BI
Ontario Energy board (Publics Sapient)
Publics Sapient
11.2017 - 11.2018
- Worked in Machine Learning, Data Engineering and NLP domain
- Created framework in Protractor tool using Jasmine architecture and JavaScript for writing scripts
- Framework was based on Page object model framework and application developed over NodeJS
- To create emulators for testing on different virtual devices
- Creating and retesting defects
- Assigning and ensuring teamwork and guiding in technical issues
- Part of product designing Testing Conduct Usability and Accessibility Testing according to WCAG 2.0 guidelines, ensuring adherence to various Levels of Conformance, with expertise in AODA and Section 508 standards
Test Lead - Microsoft Corp
Publics Sapient
11.2017 - 11.2018
- Designed and implemented complex Automation solutions in Appium tool for native mobile app for Artificial Intelligence and NLP based mobile Application product by Microsoft Corp
- Involved large amount of data used for Machine Learning
- Understood concept of Knowledge Graph (A product of Microsoft which works as Brain for ML and Data Science based products
- Completed a detailed list of Mobile Application Testing for entire team to use as a benchmark document
- Developed understanding of Usability Testing and Accessibly in a product designing using Section 508 and WAS
- Continuously evolving AI capabilities to support future iterations and ensure scalability, reflecting a commitment to advancing technology in collaboration with Publics Sapient and Microsoft
QA Lead
Magic EdTech
11.2014 - 06.2016
- Worked with Intel as Client - in Mobile Application Testing and Education plus Payment Domain
- Managing KPI and QA Matrix and presenting it to project stakeholders with analysis
- Automation using Appium for Native mobile app
- Utilized Google Analytics for data-driven insights into user s escalation person in the event of any risks or issues with testing overall
- Interact with as project SPOC for requirement understanding and query resolution
- Worked on Robot Framework tool for Automation and provided Automation Solution to client
- Ensuring Product Usability and Accessibly - product is passing WCAG 2.0 guidelines on different Levels of Conformance (A, AA, AAA)
- Participating in project auditing and billing using tools like JAWS and TalkBack
Module Leader
Impetus Pvt. Ltd
11.2008 - 03.2013
- Worked as a QA Team lead for the project which involves building a new enterprise data warehouse for client, Entrust Datacard in Banking Domain
- Security testing for digital interaction
- Orchestrated the QA team in implementing Agile methodologies, utilizing tools like JIRA for issue tracking and Confluence for documentation
- Implemented automated testing frameworks using Selenium Webdriver (Java)
- Created Framework in using module approach
- Executed SQL queries and utilized database management tools like SQL Server Management Studio (SSMS) to validate data integrity and perform backend testing
- Employed OWASP tools like ZAP (OWASP Zed Attack Proxy) for security testing to ensure robust protection of digital interactions and transactions
- Utilized version control systems like Git to manage test scripts and collaborate effectively with cross-functional teams
Analyst
AON Hewitt
06.2005 - 06.2008
- In HRIS Domain - USA DB Pension - Partnered with design team to review specifications and offer feedback from engineering standpoint or direct testing results
- Developed test plans and procedures and conducted software systems tests
- Analyzed test results and provided recommendations for improvements
Education
Masters - Computer Application
Banasathali Vidyapeeth
Tonk, Rajasthan01.2004
Bachelor - Science
M.M. College
Modinagar, U.P.01.2001
Skills
- ETL testing
- Data Analysis
- Automation (E2E, API)
- AI/ML testing
- Python
- JavaScript
- Java
- Azure DevOps
- Git-based CI/CD pipelines
- Playwright
- Cypress
- Appium
- Selenium WebDriver
- WCAG 20 standards
Certification
- Certified Entry-Level Python Programmer (PCEP)
- Microsoft Certified: Power BI Data Analyst Associate
- Certified Tester Advanced Level Test Automation Engineering (CTAL-TAE)
Languages
English
Timeline
QA Analyst and ETL Testing and Automation
ScotiaBank
10.2024 - Current
ETL Tester - SDET
Fundthrough Inc.
07.2023 - 07.2024
SDET- ETL Tester
CRATE
07.2022 - 07.2023
Technical Quality Analyst
TCS Canada - CIBC Bank
05.2021 - 07.2022
SDET
Publics Sapient
11.2018 - 07.2020
Ontario Energy board (Publics Sapient)
Publics Sapient
11.2017 - 11.2018
Test Lead - Microsoft Corp
Publics Sapient
11.2017 - 11.2018
QA Lead
Magic EdTech
11.2014 - 06.2016
Module Leader
Impetus Pvt. Ltd
11.2008 - 03.2013
Analyst
AON Hewitt
06.2005 - 06.2008
Bachelor - Science
M.M. College
Masters - Computer Application
Banasathali Vidyapeeth
Similar Profiles
Raquel JohnRaquel John
Senior Customer Care Advisor-Social Media at ScotiabankSenior Customer Care Advisor-Social Media at Scotiabank
Kevin LevyKevin Levy
Director, Commercial Card Solutions, Global Transaction Banking, North America at ScotiabankDirector, Commercial Card Solutions, Global Transaction Banking, North America at Scotiabank
Radhika NarayananRadhika Narayanan
Officer III, Commodities Wind-down Operations at ScotiabankOfficer III, Commodities Wind-down Operations at Scotiabank
Madhav MakkerMadhav Makker
Senior Customer Experience Associate at ScotiabankSenior Customer Experience Associate at Scotiabank
Kelly BouchardKelly Bouchard
Owner, Coach at PrepWise Accountability and Meal Prep CoachingOwner, Coach at PrepWise Accountability and Meal Prep Coaching