Gadgets
Vipul Jain
BI Senior ETL Developer
Bengaluru,Karnataka
Summary
Experienced BI Developer with over 13 years of experience adept in bringing forth expertise in System Analysis, Design and Development of Data Warehousing Applications. Demonstrated versatility and adaptability in working on different technologies. Able to effectively self-manage during independent projects, as well as collaborate as part of a productive team.
Overview
4
4
Certifications
4
4
years of post-secondary education
13
13
years of professional experience
Work History
Senior Manager Data Management and Delivery
JLL
Bengaluru, Karnataka
05.2019 - Current
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
- Developed ingestion pipelines and data analysis systems
- Utilized Azure Data lake, Azure Data factory, Azure Databricks and MS SQL Server studio
- Developed PySpark scripts to automate manual load performed during failures.
- Troubleshoot ETL failures and performed manual loads
- Assisted a dynamic team of engineers in the UK and India to implement global infrastructure changes that enhanced network performance and customer provision services in a timely manner
- Implement enhancements to existing applications in addition to onboarding Property data from new countries using IICS.
- Rich experience to extract data from REST API's using IICS.
System Analyst
Australia and New Zealand Bank(ANZ)
Bengaluru, Karnataka
01.2016 - 04.2019
- Delivered in-depth informatic ETL training, imparting knowledge of best practices for protecting data and minimizing errors.
- Gathered requirements and performed gap analysis through design workshops with users.
- Developed Database & Unix scripts for a major investment Banking and Insurance/Finance Client.
- Good experience on autosys and control-M scheduling tools
- Coordinate build and deploy, release acceptance, release communications, preparations and training activities, distribution and installation of releases
- Worked as a Technical Designer for Smart Choice Super plus product and APRA 2016
- Developed flowcharts and diagrams to describe and lay out logical operational steps.
Principal Consultant - BI
NTT DATA
Bengaluru, Karnataka
12.2011 - 12.2015
- Liaise and support Business Analyst team in requirements feasibility studies and discussions
- Created Informatica Mappings with Source qualifier, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Rank, Stored Procedure, XML, Expression and Sequence Generator transformations.
- Improving the Performance issue in overall ETL batch load and created a Unix shell script for post-production validation.
- Performed Upgrades for Informatica Power centre Version 8.6.0 to Informatica Power center 9.1.0
- Close collaboration with QA, Enterprise Reporting and System Integration teams in driving the enterprise projects
- Directed onsite training for business users to maximize productivity.
- Developed comprehensive business cases to analyze costs, benefits, ROI and TCO of proposed solutions.
Programmer Analyst
Cognizant
Bengaluru, Karnataka
10.2007 - 12.2011
- Evaluated and adopted new technologies to address changing industry needs.
- Design and implement feature enhancements supporting the business processes for the core enterprise systems: AIX, COBOL, JCL Informatica, DWH and Oracle.
- Coordinate, build and deploy, release acceptance, release communications, preparations and training activities, distribution and installation of releases.
- Develop or improve the engineering system to enable higher-quality tools and products to be developed and delivered; identifies risks, costs, and opportunities for improvement
- Successfully build, tested and integrated features/functions through system life cycle (e.g. integration, customer feedback, release, and engineering phases)
Education
Bachelor of Engineering - Electronics And Communications Engineering
University Of Rajasthan
Kota, Rajasthan 07.2003 - 05.2007
Skills
Informatica and IICS
ETL processes
Azure Data Factory
Warehousing solutions
Azure DataBricks
SQL programmer
GitHub
Python and PySpark Programming
Certification
Certified PowerCenter Data Integration 9.x:Developer Specialist, Informatica
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Interests
Technology
Quote
Everything we see hides another thing; we always want to see what is hidden by what we see.
René Magritte
Timeline
Senior Manager Data Management and Delivery
JLL
05.2019 - Current
System Analyst
Australia and New Zealand Bank(ANZ)
01.2016 - 04.2019
Principal Consultant - BI
NTT DATA
12.2011 - 12.2015
Programmer Analyst
Cognizant
10.2007 - 12.2011
Bachelor of Engineering - Electronics And Communications Engineering
University Of Rajasthan
07.2003 - 05.2007