Sanket Raut
Data Engineer
Nagpur
Summary
Results-driven Data Engineer & MSTR Developer with strong expertise in Snowflake–Databricks migrations and scalable ETL pipelines. Skilled in designing optimized stored procedures, ADF workflows, and automated data solutions. Experienced in delivering high-impact dashboards that improve business decision-making. Seeking to contribute modern data engineering and BI skills to a forward-thinking organization.
Overview
6
6
Certifications
4
4
years of professional experience
Work History
Data Engineer
Ernst & Young
04.2025 - Current
- Migrating end-to-end data processing workflows from Databricks to Snowflake by converting complex Databricks notebooks into optimized Snowflake Stored Procedures.
- Enhancing existing logic and implementing new business requirements to improve performance, scalability, and maintainability across migrated pipelines.
- Monitoring and troubleshooting multi-layered data pipelines built on numerous stored procedures, ensuring seamless execution through Azure Data Factory (ADF).
- Performed critical validation and result-set testing on newly developed Snowflake Stored Procedures to ensure accuracy, functional correctness, and alignment with expected business outcomes.
- Deploying newly developed and enhanced stored procedures to UAT and Production environments through Git-based CI/CD workflows, ensuring accuracy and zero-defect releases.
- Collaborating with cross-functional teams to validate data, support testing cycles, and ensure successful migration and stabilization of all pipeline components.
Executive Data Analyst
INFOCEPTS Data & AI
04.2024 - 04.2025
- Led comprehensive ETL workflows, from requirement analysis to design documentation, development, testing, deployment, and ongoing support, effectively managed through JIRA.
- Worked extensively with stakeholders to understand their requirements and concerns and provide high-quality data solutions to them.
- Implemented Dynamic table by replacing views, substantially reducing query processing time by 80% and costs ~30%.
- Improved numerous ETL jobs and system stability.
- Resolved multiple high-priority production issues, ensuring swift resolution and client satisfaction through effective collaboration and problem-solving.
- Played a pivotal role in onboarding and mentoring 10+ associates across multiple grades, ensuring a smooth transition by providing comprehensive technical and business guidance.
Associate Data Analyst
INFOCEPTS Data & AI
08.2022 - 03.2024
- Developed and enhanced 10+ MicroStrategy visually appealing Dossiers and Dashboards with complex calculations for the Luxury Retail Fashion Group to reduce client efforts.
- Resolved critical issues on MicroStrategy to enhance data visualization efficiency, resulting in an increase in client satisfaction scores.
- Led the project through User Acceptance Testing (UAT) and smoothly transitioned it to the production phase, taking on the responsibility of addressing and supporting any identified defects.
- Developed a workflow in Snowflake to obtain current-day sales data from source and create a dossier in MSTR to display the same for pick period reporting for Retail Fashion Brand.
- Monitored and troubleshot data loads and quality issues, resolving 90% of issues within 24 hours and minimizing data downtime.
- Enhanced numerous jobs from an ETL and job end standpoint, achieving a 15% boost in system stability.
Education
BE - Computer Science Engineering
S. B. Jain Institute of Technology
Nagpur, India07.2022
Skills
Technical Skills: Snowflake Development, ETL, SQL, Azure Data Factory, Databricks, Data Visualization, Data Analysis, MicroStrategy Development, Jira, ADF, Snowflake Notebook, Python
Soft Skills: Problem-Solving, Business Management, Communication, Leadership, Tech Documentation, Teamwork, Collaboration, Project Management
Certification
Received Emerging Star, All-Rounder & Dream Team Appreciation Awards
Timeline
Data Engineer
Ernst & Young
04.2025 - Current
Executive Data Analyst
INFOCEPTS Data & AI
04.2024 - 04.2025
Associate Data Analyst
INFOCEPTS Data & AI
08.2022 - 03.2024
BE - Computer Science Engineering
S. B. Jain Institute of Technology