Shubham Satpute
Pune
Summary
Results-driven Data Engineer with 8 years of proven experience in ETL Development, SQL Performance Tuning, Data Quality, and Data Management across the insurance and finance domains. Adept at designing and optimizing complex SQL queries, stored procedures, and data pipelines to deliver reliable, high-quality solutions. Experienced in leading teams, managing deliverables, and coordinating with stakeholders to ensure smooth project execution. Skilled in Azure Data Factory (ADF), Synapse Analytics, Storage Explorer, Oracle, and SQL Serve. Recognized for hands-on technical expertise combined with managerial and mentoring capabilities to drive operational excellence and project success.
Overview
3
3
years of professional experience
Work History
Software Engineer
Starsun Technology Pvt. Ltd.
Pune
2017.07 - 2020.08
- 3 years of experience in Informatica IICS
- Involved in development with Intelligent Informatica Cloud Services mappings, MCT's, Task flows, Synchronization and replication tasks.
- Involved with SQL transportation and calling stored procedures, converting stored procedures logic into IICS code.
- Worked on the source systems like Salesforce, Flat file, Snowflake
- Proficient in the development of ETL process with a good understanding of source to target data mapping.
- Involved in creating end to end design document with respect to layers, defining transformation logic as per business logic.
- Implemented dimensions like SCD I and SCD II.
- Involved in maintenance and enhancement of the code.
Education
Bachelor of Science - Computer Engineering
Pune University
PuneSkills
- SQL
- IICS
- ADF
- Synapse
- Storage Explorer
Highlights of relevant industry client experience
Insurance Domain-ETL & Data Engineering
- Design and developed complex SQL queries, stored procedures and views for analytics and reporting.
- Led a team of engineers, managing deliverables, peer review and client coordination.
- Designed and Implemented an ADF pipeline to copy data from production to pre-production for testing purpose.
Finance Domain-SQL Developer
- Developed and optimized complex SQL queries, SPs and views to support reporting and analytics
- Handled ad-hoc client requirements by analyzing business needs and modifying SQL queries to accommodate new changes.
- Provided technical support to colleagues by troubleshooting and resolving query related issues, ensuring smooth project delivery.
Additional Experties
- Strong background in data quality.
- Hands on in team leadership and mentoring junior engineers.
Timeline
Software Engineer
Starsun Technology Pvt. Ltd.
2017.07 - 2020.08
Bachelor of Science - Computer Engineering
Pune University