MARUTHU PANDIAN S

Client : Walmart | Domain - Retail & E-commerce

April 2024 – May 2025

Roles & Responsibilities

• Executed ETL and backend data validation with complex SQL queries, ensuring reliable data transformations and enhancing data quality.
• Ensured completeness, accuracy, consistency, and integrity of source-to-target data across ETL workflows.
• Used Amazon S3 to validate source files, including record counts, file structures, data formats, null values, and duplicate records.
• Performed source-to-target data reconciliation by comparing source records with transformed and target data using SQL.
• Validated full and incremental data loads and verified ETL transformations against business rules and mapping documents.
• Monitored scheduled ETL workflows using AutoSys, validating job execution status and dependencies to ensure timely completion of data processes.
• Designed and executed ETL test scenarios and test cases based on business requirements and source-to-target mapping documents.
• Performed upstream and downstream data validation to identify missing records, duplicate records, null values, and transformation discrepancies.
• Applied Python-based data validation and automation concepts for repeatable data-testing activities.
• Facilitated automated regression and data validation for ETL workflows and data pipelines, enhancing testing effectiveness.
• Collaborated with developers, Business Analysts, and team leads to analyse data discrepancies, facilitating root-cause analysis and resolution of data issues.
• Retested defect fixes and validated corrected data before defect closure.

Client - Amazon | Domain -Retail & E-commerce

August 2020 – March 2024

Roles & Responsibilities

• Worked closely with business teams to understand application functionality, requirements, and expected business behaviour.
• Reviewed BRD documents and prepared comprehensive test plans, scenarios, test data, and test cases, ensuring thorough requirement coverage.
• Tested ETL mappings, mapplets, and reusable transformations for daily data loads.
• Performed backend data validation using SQL queries to verify data accuracy and integrity.
• Executed Functional, Integration, Regression, Smoke, Sanity, and End-to-End testing.
• Validated data transformations and ETL processing against business requirements and design documents.
• Validated data consistency and completeness, ensuring integrity across upstream and downstream application flows.
• Supported automated regression and data-validation testing using Python-based testing concepts, enhancing testing efficiency and accuracy.
• Validated structured data and integration payloads using JSON/API testing concepts.
• Participated in defect analysis, root-cause investigation, retesting, and verification of fixes.
• Identified, logged, tracked, and retested defects using JIRA.
• Followed Agile Scrum, SDLC, and STLC processes.
• Coordinated with developers and environment teams to resolve critical defects.

Client - RT | Domain - Insurance

May 2019 – March 2020

Roles & Responsibilities

• Collaborated with team to clarify insurance application functionality and business requirements.
• Analysed user stories and requirement documents to create test scenarios, test cases, and test data.
• Conducted functional testing of insurance application features and workflows to ensure quality.
• Executed Smoke, Sanity, Functional, Regression, and End-to-End testing to validate insurance application functionality.
• Performed basic SQL queries to validate backend data and verify key field values.
• Validated basic data flow and consistency across insurance business modules.
• Tested basic Policy Administration, Quote Generation, Customer Management, Premium Calculation, Claims, and Renewals workflows.
• Performed basic validation of business rules, mandatory fields, input fields, and error messages.
• Identified, logged, tracked, and retested defects to ensure quality assurance using JIRA.
• Participated in requirement clarification meetings with Business Analysts and developers.
• Conducted basic end-to-end testing to validate insurance business workflows.
• Verified fixes and performed regression testing before release. Followed Agile Scrum, SDLC, and STLC methodologies.