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.