Summary
Overview
Work History
Education
Skills
Languages
Timeline
Shashank Mahalle

Shashank Mahalle

Banglore

Summary

Senior Software Engineer with expertise in ETL processes, data validation, and SQL querying. Demonstrated success in developing and testing workflows using Informatica PowerCenter while leading teams to ensure effective test data management and application testing. Transitioned from individual contributor to team leader, mentoring team members and overseeing project deliverables.

Overview

9
9
years of professional experience

Work History

Senior Software Engineer

Wipro
Banglore
12.2016 - Current
  • ETL Developer:
  • Designed ETL processes to extract, transform, and load data efficiently.
  • Worked with business analysts to gather and define project requirements.
  • Participated in requirement analysis meetings to clarify project specifications.
  • Optimized existing ETL workflows for improved performance and reliability.
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Performed unit testing of mappings, sessions, and workflows developed in Informatica PowerCenter.
  • Documented ETL processes and created user manuals for team reference.
  • ETL Tester:
  • Performed end-to-end validations using SQL queries across different databases like Oracle and Teradata.
  • Conducted regression testing on ETL processes to maintain system reliability.
  • Designed test cases based on the Business Requirements Document and the Functional Requirements Document.
  • Identified discrepancies between source and target systems during ETL process testing cycles.
  • Created detailed documentation of all findings from ETL application tests performed.
  • Test Data Platform:
  • I lead a team of test data management.
  • Provided test data to the application testing team by analyzing the test cases in the lower as well as the production environments.
  • Supported the PRT on each planned release.
  • I worked on synthetic data creation.

Education

MTECH - IT

BITS Pilani, Banglore
12-2021

Bachelor Of Computer Applications - IT

BNCPE, Yavatmal
06-2016

Skills

  • ETL processes and development
  • Data validation and warehousing
  • SQL querying and analysis
  • Informatica PowerCenter expertise
  • Application testing and management

Languages

English
Intermediate (B1)
B1
Hindi
Upper Intermediate (B2)
B2
Marathi
Native
Native

Timeline

Senior Software Engineer - Wipro
12.2016 - Current
BITS Pilani - MTECH, IT
BNCPE - Bachelor Of Computer Applications, IT
Shashank Mahalle