Hemal Jain

Background

About Hemal Jain

Aug 2023 – Till date : Technical Lead Design best practice technical and business solution. Lead and mentor team of ETL Developer to meet committed project timelines. Troubleshoot and resolved technical issues that team is facing. Started Implementation of CDP2.0 framework for data ingestion. Lead the technical team to deliver 24 projects on time, within budget and with excellent quality. Engaged with vendors to understand technical aspect of requirement. Collaborated with stakeholders to discuss project milestone and objectives. Mar 2022 – Jul 2023 : ETL development Successfully contributed to multiple projects within short timeframe. Worked on preparing centralized script for data quality check of all the incoming feeds. Contributed to Migration of the project to Snowflake. Dec 2015 – Feb 2022 : ETL development Contributed as an Informatica Admin for 1.5 years for my First Project (General Electric Client). Automated code migration process that reduced manual effort by 80%. Worked on informatica version upgrade from 9 to 10.1 Started working as an Informatica Developer in Second Project for the same client. Developed Slowly Changing Dimension Mappings for Type 1 SCD, Type 2 SCD and also business rules for the validation and processing of data. Handled end to end SDLC process. Proficiently Utilized HVR Tool for data replication and got hands-on experience on different DB tools.