Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Vishal M

Pune

Summary

Accomplished Test Lead at IRIS Software with expertise in ETL & DWH testing and team leadership. Proven track record in defining test strategies and ensuring data quality through effective defect management. Skilled in SQL and Agile methodologies, driving successful project outcomes and enhancing stakeholder collaboration.

Overview

11
11
years of professional experience

Work History

Test Lead

IRIS Software
Pune
09.2021 - Current
  • Define test strategy, scope, and objectives for ETL and data warehouse projects
  • Lead onshore-offshore coordination, manage team deliverables, and resolve blockers
  • Participate in Agile ceremonies like sprint planning, backlog grooming, and retrospectives
  • Collaborate with stakeholders, architects, and business analysts to understand requirements
  • Design and review test scenarios, test cases, and test data for ETL workflows
  • Validate data extraction, transformation logic, and loading into target systems
  • Perform functional, system, integration, and UAT testing
  • Ensure data quality checks like file validation, transformation accuracy, and audit trail verification
  • Conduct ETL code reviews and validate mapping documents
  • Use SQL, Python, or Spark scripts for data profiling and validation
  • Work with tools like Informatica, ABinitio, SSIS and AWS Glue
  • Track and triage defects using tools like JIRA and HP ALM
  • Generate test summary reports, metrics, and dashboards for stakeholders
  • Ensure regression testing and performance validation for incremental loads
  • Validate data lineage, latency, and survivorship rules
  • Ensure compliance with business rules, data privacy, and audit requirements

Senior Software Engineer

Infodeal technologies PVT LTD
Pune
08.2018 - 09.2021

Software Test Engineer

Cognizant
Pune
05.2014 - 07.2018

Education

MCA -

Pune University

Skills

  • ETL & DWH Testing
  • Team leadership
  • Test planning
  • Defect management
  • Data quality checks
  • ETL validation
  • Test strategy
  • Test Strategy Design
  • Agile Scrum
  • SQL
  • Power BI
  • Python
  • Spark
  • Data Validation & Profiling
  • Informatica
  • SSIS
  • AWS Glue
  • Defect Management
  • JIRA
  • ALM
  • UAT Support
  • Data Lineage

Projects

PDC Calculator, BMO (Bank of Montreal), Business Intelligence –BI, Jira, Postman, AWS RDS, Performed ETL validation and data reconciliation across AWS RDS databases, Developed and executed SQL-based data integrity tests, Utilized Postman to conduct API testing for ETL triggers, Managed defect lifecycle using Jira, Conducted incremental load testing INsights Enterprise, Premier INC, Business Intelligence –BI, ETL, Jira, ABinitio, DataStage, Unix, Tableau, Prepared and ran SQL queries, Defect Analyzing and Reporting, Interactions with Dev. teams to resolve the issues Re Insurance, Munich Re HSB, Business Intelligence –BI, DWH/ETL, VSTS, Informatica Power Centre 9.6, Doing data validations by source system testing with staging area, Involved in functional study of business rules, Prepared and ran SQL queries Sales productivity Management, Ingram Micro, USA, Business Intelligence –BI, Dwh/ETL, HP ALM, Analyze User Requirements and Specifications, Prepared test plans, test cases, test Scripts, Co-ordination with cross team to get the project requirements Streamline Payment Processing, First Data Corporation, USA, manual testing, HPALM, Responsible for validating the data sources, Designing, documenting and executing test plans, Strong attention to detail and excellent organization skills

Timeline

Test Lead

IRIS Software
09.2021 - Current

Senior Software Engineer

Infodeal technologies PVT LTD
08.2018 - 09.2021

Software Test Engineer

Cognizant
05.2014 - 07.2018

MCA -

Pune University
Vishal M