Rutvik Deshpande

Data Engineering professional with 3+ years of experience in cloud data warehousing and ETL/ELT pipeline design. Skilled in implementing multi-layer Medallion architectures and optimizing data workflows across Snowflake, Matillion, and SQL Server. Proven track record of reducing ETL batch runtimes by up to 60% and maintaining 99.5%+ pipeline reliability through robust validation and error handling.

Software Engineer at Stridely Solutions (2023-06 – Present)

• Migrated legacy systems (Oracle ODI and SQL Server) to Snowflake using Matillion, modernizing the data stack and reducing operational overhead with exposure to dbt workflows.
• Designed and implemented a multi-layer Medallion Architecture to transform raw data into analytics-ready tables, enhancing data ingestion and curation processes.
• Built automated CDC and historical tracking pipelines with Snowflake Streams and SCD patterns, ensuring audit compliance and data integrity.
• Developed scalable ELT workflows in Matillion, integrating diverse data sources into centralized Snowflake stages, improving overall efficiency.
• Optimized SQL models and processes in Snowflake, cutting batch runtimes and reporting latency by 60%, enhancing performance.
• Systematized data validation scripts using Python to maintain strict quality and governance standards throughout the transition.
• Collaborated with cross-functional teams to gather requirements, troubleshoot data issues, and deliver reliable data solutions, ensuring smooth system transitions.

Trainee Engineer at Stridely Solutions (2023-06)

• Engineered ETL pipelines with SSIS, Alteryx, and T-SQL to automate financial data processing, enhancing sales-level profitability calculations across business units.
• Converted 18+ Alteryx workflows into production T-SQL, optimizing financial KPI calculations like Net Sales and Gross Sales, boosting efficiency by up to 70%.
• Boosted KPI processing efficiency with set-based SQL transformations and indexed datamart structures, achieving a 70% improvement in processing speed.
• Designed a centralized SQL Server datamart to provide a single source of truth for business reporting, supporting executive Power BI dashboards.
• Automated data reconciliation, ensuring ERP data accuracy; eliminated reporting discrepancies pre-release.
• Performed comprehensive data validation and reconciliation, ensuring accuracy and efficient retrieval for Power BI reporting.
• Developed a centralized data warehouse to support efficient data storage, retrieval, and visualization, facilitating improved business insights.

Bachelor of Engineering in Mechanical Engineering – Pimpri Chinchwad College of Engineering & Research (PCCOER) (2019 – 2023)