Overview
Work History
Education
Skills
Professional Highlights
Timeline
Generic
Neeraj Goyal

Neeraj Goyal

Bangalore

Overview

9
9
years of professional experience

Work History

Senior Principal Engineer

Wissen Technology
09.2020 - Current
  • Coordinated resources across multiple departments while managing expectations throughout the life cycle of a project.
  • Mentored junior members of the engineering team by providing feedback on their work performance.
  • Developed a data warehouse on Snowflake from scratch and an ELT pipeline for data integration
  • Migrated data from on-premises (IBM Db2) to Snowflake Cloud
  • Created reusable ETL jobs for data extraction and loading into target systems
  • Implemented configuration-based ETL processes in Python for API data retrieval and Snowflake loading
  • Designed data warehouses to meet diverse reporting requirements
  • Developed Talend jobs for data extraction and archival processes
  • Automated data transfer tasks using Python scripting

Data Engineer

Zoomcar India Pvt Ltd
12.2019 - 09.2020
  • Developed optimal ETL pipelines and DataMarts
  • Maintained databases, created database tables, and stored procedures
  • Developed a metadata framework for database monitoring
  • Processed large volumes of data and maintained SQL code
  • Tracked project development with GitHub
  • Developed a comprehensive business dashboard

Database Manager, Alumni Relations Division

BITS Pilani
10.2018 - 12.2019
  • Optimized database performance and ensured security and availability
  • Developed and maintained complex stored procedures and documentation
  • Handled common database server optimization tasks
  • Maintained ETL processes and Tableau dashboards

Engineer

Cartesian Consulting Pvt Ltd
09.2017 - 09.2018
  • Part of the product team, responsible for developing analytics solutions
  • Designed advanced SQL queries, procedures, cursors, and triggers
  • Designed and developed data warehouses and data marts handling millions of rows
  • Performed database import/export, backup, and monitoring

Project Engineer

Wipro Ltd
06.2015 - 08.2017
  • Designed and developed ETL processes using Informatica PowerCenter
  • Developed data warehouses and data marts
  • Analyzed large datasets using SQL and delivered reports and dashboards in Tableau
  • Extensively worked on SQL performance tuning and data warehousing solutions

Education

MCA - Computer Applications

Madhav Institute of Technology & Science
Gwalior, MP
06-2015

Skills

  • Informatica PowerCenter 105x
  • Talend Open Studio Data Integrator 7
  • Talend Enterprise version
  • Pentaho data integration
  • Python
  • Autosys
  • SQL
  • Shell
  • Snowflake
  • Db2
  • Amazon Redshift
  • Amazon Athena
  • Azure
  • Windows
  • Linux

Professional Highlights

  • Cloud Technology Implementation: Hands-on experience with AWS technologies including AWS Redshift, AWS Athena, AWS S3, and Azure DevOps (AZDO) and Snowflake Cloud DB, enhancing cloud-based data solutions and operational efficiency.
  • Extensive ETL Expertise: Proficient in leveraging advanced ETL tools such as Informatica Power Center, Pentaho Data Integration (PDI), and Talend to streamline data processes and enhance data management efficiency.
  • Architectural Design and Strategy: Successfully designed ETL architectures and developed robust strategies for data cleansing, data quality assurance, and data consolidation using Informatica Power Center and Talend (Open Studio Data Integrator 7 and Talend Enterprise Version).
  • Leadership in Data Warehousing: Over two years of leadership experience as a Senior Principal Engineer (Lead), managing and mentoring a team of 7 members in a comprehensive data warehouse project.
  • Business User Engagement: Effectively engaged with business users to consolidate and analyze requirements, presenting and implementing design solutions that meet their needs.
  • Lifecycle Management Proficiency: Expert in managing product code and development lifecycles through GitHub, ensuring seamless version control and collaborative development.
  • Enterprise-Level Reporting Solutions: Designed and implemented enterprise-level end-to-end reporting solutions, delivering comprehensive and actionable insights for business decision-making.
  • Comprehensive Design Development: Developed detailed Low-Level Designs (LLD) for system development and High-Level Designs (HLD) for user training, ensuring clarity and precision in technical and user documentation.

Timeline

Senior Principal Engineer

Wissen Technology
09.2020 - Current

Data Engineer

Zoomcar India Pvt Ltd
12.2019 - 09.2020

Database Manager, Alumni Relations Division

BITS Pilani
10.2018 - 12.2019

Engineer

Cartesian Consulting Pvt Ltd
09.2017 - 09.2018

Project Engineer

Wipro Ltd
06.2015 - 08.2017

MCA - Computer Applications

Madhav Institute of Technology & Science
Neeraj Goyal