Vaishnavi Gurav

Data Engineer

Mumbai 2+ yrs exp 84 · Excellent

About

Results-driven Data Professional with 2+ years of experience in data analytics and engineering, with strong proficiency in Python, SQL, and Power BI. Experienced in developing end-to-end ETL pipelines for data extraction, transformation, automation, and reporting, along with creating 100+ Power BI dashboards for business insights. Hands-on experience with technologies including PySpark, Kafka, Debezium, AWS Glue, Apache Airflow, PostgreSQL, Snowflake, Docker, and Concourse through professional and internship experience. Applied LLM and Retrieval-Augmented Generation (RAG) techniques in projects to enhance data extraction and processing workflows. Strong ability to understand business requirements and translate data into reliable, actionable solutions.

Skills & Expertise (30)

Power BI Intermediate

8.0/10

Years Exp

SQL Intermediate

7.8/10

Years Exp

Python Intermediate

7.6/10

Years Exp

ETL Intermediate

7.5/10

Years Exp

Postgresql Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.4/10

Years Exp

Cross-functional Teamwork Intermediate

7.0/10

Years Exp

Critical thinking Intermediate

7.0/10

Years Exp

stakeholder communication Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

NumPy Intermediate

6.8/10

Years Exp

Kafka Intermediate

6.5/10

Years Exp

Apache Airflow Intermediate

6.5/10

Years Exp

User Acceptance Testing Intermediate

6.5/10

Years Exp

AWS Glue Intermediate

6.0/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Spark Streaming Intermediate

6.0/10

Years Exp

Docker Intermediate

5.5/10

Years Exp

Azure AI Foundry BeautifulSoup Requests Word SharePoint Vault Automation Anywhere Retrieval-Augmented Generation PowerPoint Power Query Snowflake PySpark

Work Experience

IT Executive

Kalpataru Projects International Limited

Nov 2024 - Present

Designed, built, and automated end-to-end ETL processes using Python (web scraping), SQL, RPA, and LLM-based workflows to extract, clean, transform, and load data from multiple structured and unstructured sources into reporting-ready formats. Developed 100+ interactive Power BI dashboards used across business teams, translating complex, multi-source datasets into clear, actionable insights that support day-to-day operational and strategic decisions. Built and optimized SQL queries, views, and stored procedures to support fast, reliable analytics, ad-hoc reporting, and high-volume data retrieval. Integrated LLM-based workflows into existing RPA pipelines to automatically parse and structure unstructured documents (PDFs, web content), reducing manual data entry and extraction effort. Partnered directly with business stakeholders to gather requirements, translate them into technical and pipeline specifications, and led User Acceptance Testing (UAT) to validate deliverables before go-live.

Data Engineer Intern

Go Digital Technology

Jun 2024 - Aug 2024

Designed and deployed end-to-end ETL pipelines in Python to automate data processing workflows using a mix of cloud-native and open-source technologies. Built a real-time streaming architecture using Kafka and Debezium to capture change data (CDC) and feed it into downstream relational stores for near real-time analysis. Automated data ingestion and web scraping workflows using CI tooling, with structured, query-ready storage in PostgreSQL. Performed scalable, distributed data transformations using Spark Streaming on cloud infrastructure, supporting large-volume data processing needs.