Ronak Vijay
Jaipur
Summary
Data Engineer with 1+ years of experience in ETL (Extract, Transform, Load), data warehousing, and big data platforms. Skilled in Snowflake, AWS (S3, Glue, Athena), Azure Databricks, SQL, and Python. Experienced in data modeling, pipeline automation, and business intelligence with Power BI, Tableau, and Superset. Proven ability to design scalable data pipelines, optimize performance, and deliver analytics-ready datasets for BI and ML teams.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Engineer
Midoffice Data
09.2024 - Current
- Designed and optimized end-to-end ETL/ELT pipelines in Snowflake for BI, Analytics, and ML use cases.
- Integrated SAP-ECC data to Snowflake via CData, reducing processing time by 30%.
- Built data models (Star Schema, Snowflake Schema) with 50+ tables and 20+ views, improving query performance by 25%.
- Implemented Slowly Changing Dimensions (SCD Type 2) for master data management, ensuring 99% accuracy.
- Automated ingestion from AWS S3 using Snowpipe for real-time batch processing with
- Developed ETL pipelines using AWS Glue to extract data from Salesforce CRM, loaded to S3, and queried with Athena external tables.
- Created Airflow DAGs and Python-based workflows, cutting manual effort by 40%.
- Conducted BI evaluations (Power BI vs QuickSight) to enhance data visualization and reporting, reducing reporting time by 25%.
- Engineered an AI-powered chatbot (RAG architecture) using Python, Snowflake, PostgreSQL, Pinecone, and AWS services.
- Deployed REST APIs using Flask, Docker, and Postman for seamless integration.
Data Engineer Intern
Midoffice Data
01.2024 - 09.2024
- Designed and optimized SQL queries, stored procedures, and indexing strategies to improve query performance.
- Developed POCs with Apache Superset and Metabase for analytics visualization.
- Gained practical expertise in AWS (S3, EC2, VPC, IAM) and Azure (Databricks, Data Lake, VMs).
- Integrating Azure Databricks with Snowflake for processing and transformations with Spark SQL and Databricks SQL.
Education
Bachelor of Technology - Computer Science
Lovely Professional University
07.2024
Skills
- Data Engineering & ETL: Snowflake, AWS Glue, Hadoop, Hive, ELT/ETL, CData Sync
- Cloud Platforms: AWS (S3, EC2, VPC, Athena, IAM), Azure (Databricks, Data Lake, VMs)
- Programming & Databases: Python, SQL, PostgreSQL, Stored Procedures, Performance Tuning
- Data Modeling: Star Schema, Snowflake Schema, Normalization, Partitioning
- Orchestration & Automation: Apache Airflow, Snowpipe, CI/CD, Docker, APIs
- Big Data & Analytics: Data Lake, Batch Processing, Real-Time Streaming (Snowpipe)
- BI & Visualization: Power BI, Tableau, Apache Superset
- Collaboration & Tools: Git, JIRA, MS Excel
Certification
- Snowflake SnowPro Associate – Platform
- Microsoft Certified – Azure Fundamentals
Timeline
Data Engineer
Midoffice Data
09.2024 - Current
Data Engineer Intern
Midoffice Data
01.2024 - 09.2024
Bachelor of Technology - Computer Science
Lovely Professional University