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, MP06-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
Similar Profiles
TRUPTI PATILTRUPTI PATIL
Principal Engineer at Wissen TechnologyPrincipal Engineer at Wissen Technology
Selvakumar NSelvakumar N
Senior Software Engineer at Wissen TechnologySenior Software Engineer at Wissen Technology
Rahul SanadhyaRahul Sanadhya
Principal Architect at Wissen TechnologyPrincipal Architect at Wissen Technology
Rutuja PatilRutuja Patil
Consultant at Wissen TechnologyConsultant at Wissen Technology
Simran SSimran S
Travel Consultant at BCD TravelTravel Consultant at BCD Travel