Ruchit Yadav

Data Engineer with 3+ years of experience designing scalable ETL/ELT solutions, enterprise data warehouses, and AI-powered analytics platforms using Snowflake, Azure Data Factory, Azure Databricks, SAP SNP Glue, Python, SQL, and Power BI. Experienced in SAP S/4HANA integrations, Snowflake Cortex AI implementations, Redshift-to-Snowflake migrations, real-time data ingestion frameworks, and cloud-based analytics solutions. Proven track record of optimizing data pipelines, reducing processing times by over 99%, and delivering business-critical analytics platforms for finance, supply chain, procurement, and trading domains.

Data Engineer at Mindsprint (OLAM Information Services Pvt. Ltd.) (2023-06 – Present)

• Designed and deployed 50+ production-grade ETL pipelines using Azure Data Factory (ADF) and SNP Glue, improving data ingestion performance through dynamic partitioning, parameterization, and parallel processing.
• Developed AI-powered business assistants using Snowflake Cortex AI and Cortex Analyst on Sales, Purchase, and Finance data marts, enabling natural language querying and delivering accurate, data-driven insights that improved business decision-making and operational efficiency.
• Designed and implemented semantic models for enterprise data marts, allowing business users to retrieve Sales, Purchase, and Finance insights through conversational AI interfaces without requiring technical expertise.
• Implemented Python automation to send email alerts for Snowflake password expirations, warehouse usage anomalies, and data load failures.
• Integrated and optimized Fivetran pipelines for high-volume SQL Server and Oracle sources, replicating millions of records into Snowflake and reducing end-to-end data load times from 90 minutes to under 10 minutes while improving reliability and scalability.
• Implemented end-to-end SAP S/4HANA to Snowflake integrations using SNP Glue, automating extraction, transformation, and loading of enterprise datasets.
• Built scalable Snowflake data warehouse solutions including dimensional models, data marts, incremental loading frameworks, and automated data quality validation processes.
• Streamlined ingestion of complex market-data JSON feeds by building scalable ETL pipelines using Python and PySpark on Azure Databricks, transforming and loading data into Azure Data Lake Storage (ADLS) for downstream analytics and reporting applications.
• Participated in Azure resource migration and Snowflake tenant migration initiatives, ensuring seamless data transition with complete validation and minimal business disruption.
• Collaborated with business stakeholders, SAP teams, data architects, and analytics teams to deliver enterprise reporting and self-service analytics solutions.

Bachelor of Technology (B.Tech) in Information Technology – Guru Ghasidas Vishwavidyalaya (Central University) (2019-01 – 2023-12)