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
12-2021
Bachelor Of Computer Applications - IT
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