Ashutosh Mahato

Associate Consultant

Kolkata, West Bengal, India7 yrs 9 mos experience

AI ML PractitionerAI Enabled

Key Highlights

Expert in ETL Testing and Data Quality Assurance.
Reduced manual testing efforts by 50% using automation.
Led successful Azure Data Factory validation projects.

Stackforce AI infers this person is a Data Quality and ETL Testing expert in the SaaS industry.

Contact

Skills

Core Skills

Etl TestingTest AutomationTest ManagementData QualityManual Testing

Other Skills

Python (Programming Language)SQLGenerative AIAzure Data FactoryAzure DevOpsMicrosoft SQL ServerTransact-SQL (T-SQL)Microsoft Power BIExtract, Transform, Load (ETL)ETL ToolsData AnalysisRoot Cause AnalysisMicrosoft Azure Data FundamentalsPower BIMicrosoft Outlook

About

With over seven years of experience as an ETL Test Engineer, I specialize in ensuring data integrity and quality across complex data ecosystems. My passion lies at the intersection of data validation and automation, where I leverage modern tools to build robust, efficient testing frameworks. At PwC, I've had the opportunity to lead initiatives in test automation, designing Python-based utilities and harnessing Generative AI (GenAI) to automate test case and data generation. This approach successfully reduced manual testing efforts by 50% and improved test coverage by 20% by simulating critical edge cases. Core Competencies: ETL & Data Warehouse Testing: Deep expertise in SQL-based validations (counts, NULLs, duplicates, data types) , transformation logic , and validating SCD Type 0, 1, and 2 logic. * Cloud & Azure: Hands-on experience testing Azure Data Factory (ADF) pipelines, activities, and data flows , including history and incremental loads. * Automation & API: Proficient in Python for test automation and API validation using tools like Postman. * Test Management: Skilled in the full STLC , from Requirement Analysis and RTM development to defect management in Azure DevOps and JIRA. I have applied these skills across diverse domains, including Insurance, Salesforce (Opportunities & Engagements), Financial Reporting, and Workday Employee Data. I am always interested in connecting with other data professionals and exploring new challenges in data quality and test automation.

Experience

7 yrs 9 mos

Total Experience

3 yrs 9 mos

Average Tenure

2 mos

Current Experience

Tata consultancy services

Assistant Consultant

Mar 2026 – Present · 2 mos · Kolkata, West Bengal, India · On-site

Python (Programming Language)SQLETL TestingTest Automation

Pwc india

Senior Associate

Apr 2023 – Mar 2026 · 2 yrs 11 mos · Kolkata, West Bengal, India · On-site

As a Senior Associate, I focus on automating and validating complex data pipelines, ensuring data integrity from source to target.
Key Achievements:
GenAI & Python Automation: Designed and implemented Python-based automation frameworks and leveraged Generative AI to automate test case/data generation. This landmark project reduced manual effort by 50% and boosted test coverage by 20%.
Azure Data Factory Validation: Led end-to-end testing of ADF pipelines, validating data transformations , incremental and historical data loads , and complex SCD (Type 0, 1, and 2) logic.
Advanced SQL & Integration Testing: Authored complex SQL queries to ensure 100% data integrity. Validated TIBCO Data Virtualization views against SQL Server and ADF processes.
Test Strategy & Management: Achieved 100% test coverage by developing a comprehensive Requirement Traceability Matrix (RTM). Managed test cases, defects, and issue resolution within Azure DevOps.
API & Functional Testing: Executed API tests to validate response data against business requirements and conducted both White Box and Black Box testing.

Data QualitySQLTest Management

Cognizant

2 roles

Associate

Promoted

Jan 2022 – Apr 2023 · 1 yr 3 mos

I was responsible for the full testing lifecycle, from requirements analysis to execution and reporting, ensuring data accuracy across multiple platforms.
Key Achievements: * Advanced SQL & Data Quality: Designed complex SQL queries and implemented REGEX to validate data formats and business rule transformations, identifying critical issues before migration. * End-to-End Test Management: Collaborated with cross-functional teams (developers, BAs, stakeholders) to define critical testing scenarios. Created detailed Test Strategy and Test Summary Reports. * Functional & Regression Testing: Developed deep domain expertise in Annuity applications. Led Manual Testing efforts, designing and executing Functional, E2E, and Regression test suites to ensure system integrity. * Defect & Process Management: Managed the defect lifecycle, including documentation, tracking, and retesting. Validated data flows across diverse systems (File to DB, DB to File, Data Warehouse to Mainframe).

SQLManual Testing