Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Nikhil Ranade

Lead Engineer
Pune

Summary

Data Engineer with 2 years of expertise in Snowflake, proficient in ETL tools like Matillion and Fivetran for pipeline development. Skilled in data modeling, adept at crafting stored procedures in Snowflake, and experienced in cost optimization strategies. Demonstrated ability in developing Python scripts for efficient data ingestion and transformation. Proven track record in overseeing and executing complex projects, contributing to successful outcomes. Keen to learn new technologies related to visualization and data science

Overview

4
4
years of professional experience
1
1
Certification

Work History

Lead Engineer

Kipi.bi
12.2021 - Current
  • Proficient in Snowflake data warehouse platform with 2 years of extensive hands-on experience.
  • Developed and maintained ETL pipelines using Matillion ETL and Fivetran, ensuring efficient and reliable end to end data processing.
  • Demonstrated expertise in data modeling within Snowflake, worked on Data vault and dimensional modelling.
  • Expertise in creating stored procedures in Snowflake for streamlined data processing and manipulation.
  • Implemented cost optimization strategies in Snowflake and Matillion ETL, contributing to significant cost savings and efficient resource utilization.
  • Developed Python scripts and Azure functions for seamless data ingestion from diverse API sources to Azure blob storage, enhancing automation and scalability of data processes.
  • Led a team of 3 in the development of an in-house accelerator using Streamlit (Python based web development framework) for Snowflake data sharing, enabling streamlined and efficient data access and analysis within the organization.

Senior System Engineer

Infosys
08.2019 - 12.2021
  • Developed ETL solutions using Apache Nifi and Apache Kafka for data movement and transformation to NPM database (Apache Druid).
  • Created stored procedures and user-defined functions in Oracle and MySQL for data processing and maintenance of data retention policies.
  • Automated processes using shell scripts for report generation, transfer, alert generation, and discrepancy reports.
  • Proficient in Unix environment and experienced working in distributed ecosystems such as HDFS and Zookeeper.
  • Deployed pipelines using version control systems like GIT, writing YAML scripts through Docker and Kubernetes.
  • Prepared design documents aligned with business requirements, emphasizing clear and effective communication.
  • Demonstrated proficiency in coordinating with other teams, client interaction, and participation in meetings.

Education

Bachelor of Engineering - IT

Sinhgad College of Engineering
Pune
04.2001 -

Skills

    Snowflake

undefined

Certification

SnowPro Core Certified

Timeline

SnowPro Core Certified

02-2022

Lead Engineer

Kipi.bi
12.2021 - Current

Senior System Engineer

Infosys
08.2019 - 12.2021

Bachelor of Engineering - IT

Sinhgad College of Engineering
04.2001 -
Nikhil RanadeLead Engineer