MOHITA VERMA
Lead Data Engineer
Summary
Passionate about Data & Analytics with over 8+ years of experience specializing in Snowflake data warehouse, and AWS services. Skilled in designing and implementing scalable data solutions with a deep understanding of ETL processes, data modelling, and performance optimization. Proficient in Python for data processing and automation and experienced in using Power BI for data visualization and reporting. Known for delivering high-quality, reliable data solutions that empower business decision-making.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Lead Data Engineer
Advance Auto Parts
Hyderabad
09.2023 - Current
- Managing Snowflake Platform end to end for 1000+ users
- Code & Design review for Snowflake Objects
- Providing solutions to end users using Snowflake functionalities like Snowpipe, Streams & Tasks, Secure Data sharing, Optimization techniques like clustering & search optimization, Dynamic tables, Tagging & Masking
- Data Integration with various applications like Kafka, Talend, Collibra, Power BI, AWS services, Palantir, SQL Server, Airflow, DataStage and so on with best recommended authentication method
- Implementation of CI/CD Pipeline for Code Deployment
- Platform & Data Security - Network Policies, Inbound & Outbound Data Policies, etc
- Data Governance - Data quality, tagging & masking, lineage, RBAC, User Access Management, Object Lifecycle Policies
- Automation on platform manual activities like alerts, maintenance, onboarding, user access management etc
- Developed solutions leveraging Cortex AI capabilities to facilitate seamless data explorations
Data Engineer II
Advance Auto Parts
Hyderabad
11.2020 - 08.2023
- Migrating on-prem Data Warehouse (Teradata) to cloud (Snowflake)
- Strategy to Migrate Static and Incremental Data
- Code & Data Migration of 2300+ tables (~13 TB) and 200 procedures using SnowSQL, TPT scripts, Snowflake Copy Commands, Shell Scripting, & Python
- Data validation for all tables, and functional validation of all codes, views, and procedures
- Redesigning of Oracle Reports to Power BI Reports pointing to Snowflake along with enhancements
Data Engineer
Kalpa Softech Private Limited
Pune
10.2018 - 10.2020
- Building a Data Warehouse in Snowflake, creating a business layer on Denodo, and reporting on Looker
- Collaborate with stakeholders to gather business requirements and define key performance metrics
- Set up data pipelines using the ETL tool Pentaho
- Design a business layer on Denodo based on business requirements
- Define LookML models to structure the data as per reporting requirements
Software Engineer
Zensar Technology
Hyderabad
10.2016 - 10.2018
- Building pipelines using Azure Data Factory and stored procedures to load data into Azure SQL Database, and data is processed further for reporting
- Design data models and identify necessary tables in the Azure SQL Database
- Design and develop ADF pipelines to ingest data from various sources
- Use activities like Copy Data, Lookup, and Data Flow for extracting and loading data
- Implement mechanisms for incremental data loading to optimize performance and reduce processing times.
Education
Bachelor of Engineering - Computer Science (Hons)
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV)
Bhopal, Madhya Pradesh 04.2012 - 01.2016
Skills
Snowflake Data Warehouse
ETL Tools - Pentaho, Azure Data Factory
Data Modelling
Reporting Tools - Power BI, Looker
undefinedCertification
1. SnowPro Advanced Architect
Accomplishments
- Reduction of Overall cost by 30% in Snowflake Platform.
- Developed a Data Validation Engine on Python which reduced the human effort by 90%.
- Developed a versatile job utilizing Pentaho Metadata Injection, enabling dynamic table creation and data loading from Oracle to Snowflake. This solution significantly enhanced our ELT use case.
Timeline
1. SnowPro Advanced Architect
12-2026
2. SnowPro Core Certification
12-2025
Lead Data Engineer
Advance Auto Parts
09.2023 - Current
Data Engineer II
Advance Auto Parts
11.2020 - 08.2023
Data Engineer
Kalpa Softech Private Limited
10.2018 - 10.2020
Software Engineer
Zensar Technology
10.2016 - 10.2018
Bachelor of Engineering - Computer Science (Hons)
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV)
04.2012 - 01.2016
Similar Profiles
Mohammed Aliuddin AhmedMohammed Aliuddin Ahmed
Senior Financial Analyst at Advance Auto Parts,Inc.(Retailer Automotive Parts)Senior Financial Analyst at Advance Auto Parts,Inc.(Retailer Automotive Parts)
Tyler WrightTyler Wright
NA at Mobile Parts Professional, Advance Auto PartsNA at Mobile Parts Professional, Advance Auto Parts
DANIEL CUNNINGHAMDANIEL CUNNINGHAM
Parts Specialist and Parts Delivery Driver at Advance Auto Parts - Auto Part InternationalParts Specialist and Parts Delivery Driver at Advance Auto Parts - Auto Part International