Darshit Jain
Pune,Maharashtra
Summary
Results-oriented data professional, bringing extensive experience in developing, testing, and maintaining ETL processes. Proficient in various ETL tools including Informatica PowerCenter, IICS, Ab Initio, and Microsoft Azure (Microsoft certified). Extensive experience in Banking, Retail, and Healthcare domains. Proven ability to deliver complex projects on time with great value. developing and optimizing ETL workflows. Skilled in transforming complex data sets into actionable insights while maintaining data integrity. Known for fostering team collaboration and adaptability in dynamic environments, utilizing expertise in SQL, data warehousing, and problem-solving.
Overview
11
11
years of professional experience
Work History
Data Engineer
UBS (Credit Suisse)
Pune
10.2022 - Current
- Designed, developed, and managed scalable ETL pipelines using Informatica PowerCenter and Azure data Factory,Python, Unix shell scripting and Oracle database.
- Implemented key data transformation modules, including Data Acquisition, Auto Ingestion,
Harmonization, Late-Arriving Dimension Handling, and SCD Type-2. - Mentored junior engineers, providing guidance in best practices and fostering professional
growth opportunities.
ETL Developer
Hexware
Pune
05.2021 - 10.2022
Developed and implemented ETL processes to extract, transform, and load data from
legacy systems such as Informatica PowerCenter and Ab Initio to AWS Glue.
Implemented Slowly Changing Dimensions (SCD Type-2), late-arriving data handling, and
data harmonization using Informatica PowerCenter, SQL, and Unix.
Provided product support during various testing cycles, including SIT and UAT, ensuring
smooth deployment and issue resolution.
Participated in design and planning exercises for future software rollouts.
Collaborated with stakeholders regarding project capabilities and limitations to deliver
optimal functionality.
ETL Developer
Bitwise solution pvt ltd
Pune
10.2014 - 05.2021
- Worked on the migration of existing Ab Initio code (graphs) to Informatica PowerCenter
(mappings/workflows) to enhance performance and maintainability. - Designed and implemented end-to-end ETL processes using Informatica PowerCenter,
including job scheduling and workflow automation. - Provided production support for ongoing ETL workflows, ensuring stability and performance.
Automated support processes using Unix scripting improve operational efficiency and
reduce manual intervention. - Worked closely with clients to establish specifications and system designs.
- Tested and deployed scalable and highly available software products.
Identified opportunities for process improvement within the development team,
implementing changes that led to increased efficiency and collaboration among
members. - Contributed to successful project completion with effective time management and
prioritization skills, meeting tight deadlines consistently. - Communicated complex technical concepts clearly to non-technical stakeholders during
project discussions and progress updates.
Education
MCA - Masters in computer application
NBN Sinhgad School of Computer Studies, Pune
BCA - Bachelors in computer application
University College of Science, Udaipur
Skills
- Extract Transform Load (ETL)
- Informatica Powercenter
- Azure data factory
- IICS
- Python
- Ab Initio
- SQL
- Data Warehousing
- Unix shell Scripting
- Git
- IBM tivoli and Control-M
Websites
Languages
English
Hindi
Personal Information
Title: Senior ETL Developer
Timeline
Data Engineer
UBS (Credit Suisse)
10.2022 - Current
ETL Developer
Hexware
05.2021 - 10.2022
ETL Developer
Bitwise solution pvt ltd
10.2014 - 05.2021
MCA - Masters in computer application
NBN Sinhgad School of Computer Studies, Pune
BCA - Bachelors in computer application
University College of Science, Udaipur