Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Dipali Pawar

Pune

Summary

A results-driven and customer-focused ETL Automation Test Engineer with over 3.10 years of experience in ETL/Data Warehouse Testing, Manual Testing, and Integration Testing. Skilled in identifying and resolving complex issues using SQL databases (DML and DDL commands) and conducting detailed source-to-target data mapping validation.

Possesses strong domain expertise in Insurance (BFSI)and Healthcare, with comprehensive knowledge of various testing types, including Smoke Testing, Sanity Testing, Functional Testing, GUI Testing, Database Testing, Retesting, Regression Testing, and User Acceptance Testing (UAT).

Key Competencies and Tools:

  • Proficient in ETL tools such as Informatica IICS and Snowflake, as well as BI tools like Power BI and Tableau.
  • Experienced with defect management tools such as JIRA, QC (HP ALM), Mantis, and Zephyr.
  • Skilled in Python libraries like Pandas, Jupyter, and PyCharm, with experience in Databricks for data handling.
  • Sound understanding of Metadata, Star schema, and Snowflake schema.
  • Writing and reviewing Test Cases based on requirements and executing them to ensure quality assurance.
  • Conducting thorough defect analysis and ensuring data completeness, transformation rule validation, and referential integrity testing.
  • Validating fact and dimension tables in the target data warehouse and analyzing the Source Systems and Staging areas.
  • Strong problem-solving skills, articulate communication, and a collaborative mindset.
  • Adept at working in Agile environments, participating in Scrum meetings, and providing detailed daily/weekly status reports to higher management.

This comprehensive skill set, combined with a passion for delivering high-quality solutions, makes me an asset to teams involved in ETL processes, data warehouse projects, and software testing initiatives.

Overview

4
4
years of professional experience
1
1
Certification

Work History

ETL Tester

VSign Software
Pune
02.2023 - Current

Requirement Analysis: Analyzing the requirements and communicating with the BA team for a better understanding of the requirements.
Responsible for testing deliverables, prioritizing, and monitoring activities to meet such dates for individual assigned features.
Identified end-to-end test scenarios, test cases, and test data.
Execution of test cases from the Test Lab in the Quality Center.
Performing functional testing, regression testing, and end-to-end testing.
Validation of expected output vs. Actual output in the respective log files.
Validation of expected output vs. Actual output in the respective database tables using SQL.
Identification of defects, registering them in QC, and reporting them to the lead, analysis of the mapping document, and query development.
I collected the requirements from clients and completed them on time.
Validations of data based on business criteria, and updating of test cases in the JIRA tool.
Reporting to the client on a weekly basis.
Provide daily status update reports to the onsite and business teams, along with sprint calls.

ETL Tester

VSign Software
Pune
03.2021 - 02.2023


Conduct detailed analysis of mapping documents to understand requirements and develop accurate and efficient SQL queries.

Collaborate with clients to gather requirements, ensuring timely completion and alignment with project goals.

Manage and maintain test cases using JIRA, ensuring updates are accurately documented.

Perform comprehensive data validations based on business rules and criteria to maintain quality standards.

Prepare and present weekly progress reports to clients, highlighting achievements, and addressing challenges.

Provide daily status updates to onsite and business teams during sprint calls, ensuring transparency and alignment.

Verify data integrity by assessing accuracy, completeness, and consistency in source systems.

Test and validate ETL processes to ensure data transformations are executed accurately, as per business requirements.

Monitor and validate data loading processes into target systems, ensuring data volume, speed, and error handling meet performance benchmarks.

Conduct data quality checks to identify discrepancies, and proactively resolve issues.

Foster effective communication and collaboration with ETL developers, business analysts, and other stakeholders to ensure successful project execution.

Education

B.com -

KBC North Maharashtra University

Diploma in Computers -

KBC North Maharashtra University

Higher Secondary Certificate -

State Board

Secondary School Certificate -

State Board

Skills

  • ETL automation testing
  • ETL, Data Warehouse Testing
  • SQL databases
  • Database Testing
  • Snowflake Cloud DB
  • Informatica IICS
  • Oracle SQL Developer
  • Microsoft SQL Server
  • My SQL
  • Basic Python
  • Pandas
  • Jupiter
  • Databricks
  • PyCharm
  • Functional Testing
  • Manual testing
  • Smoke Testing
  • Sanity Testing
  • GUI Testing
  • Integration Testing
  • Retesting
  • Regression Testing
  • User Acceptance Testing
  • HPQC (ALM)
  • JIRA
  • Power BI
  • Tableau
  • Mantis
  • Zephyr
  • AWS Cloud
  • AWS Glue
  • AWS RedShift
  • AWS S3

Certification

Completed Advanced Power BI Masterclass Basic to Advanced Power BI Certificate

Timeline

ETL Tester

VSign Software
02.2023 - Current

ETL Tester

VSign Software
03.2021 - 02.2023

B.com -

KBC North Maharashtra University

Diploma in Computers -

KBC North Maharashtra University

Higher Secondary Certificate -

State Board

Secondary School Certificate -

State Board
Dipali Pawar