Home About Skills Projects Experience Contact
Data Engineer · Pune, India

Building pipelines
that make data
move.

I design and build scalable data infrastructure, ETL/ELT pipelines, real-time streaming architectures, dimensional data models, and the dashboards that sit on top of them. 2+ years turning raw sensor data, APIs, and enterprise sources into clean, reliable analytics layers.

About me

Engineering the data layer, not just reading it

I'm a Data Engineer based in Pune, India. My work lives in the middle layer, between raw, messy source data and the clean, trusted datasets that analysts and decision-makers actually use. I build the pipes, models, and infrastructure that make that journey reliable and fast.

At C4I4 Labs / Kirloskar Solar, I've designed star-schema data warehouses, built real-time IoT streaming pipelines, and integrated data from sensors, ERP systems, and APIs into unified analytics platforms. I'm equally comfortable in Python, SQL, SSIS and I know how to make all three work together.

When I'm not engineering pipelines, I enjoy trekking, chess, reading, and swimming.

Current role
Data Engineer
C4I4 Labs · Kirloskar Solar · Jul 2024 – Present
Education
MCA
Savitribai Phule Pune University
Experience
2+ years
+ 1 year internship
Languages
English · Hindi
Marathi (native) · Japanese (basic)
What I work with

Skills & stack

⚙️
Data pipelines
SSISETL / ELTPythonPandasNumPyn8n
📡
Real-time streaming
Apache KafkaMQTTIoT pipelinesPySpark
🗄️
Databases & SQL
SQL ServerPostgreSQLMySQLMongoDBMariaDB
🏗️
Data modeling
Star schemaSnowflake schemaData warehousingData architecture
📊
BI & visualization
Power BIDAXPower QueryRLSDeneb / Vega
☁️
Cloud & DevOps
AWS S3DockerGitCI/CDPower BI Service
What I've built

Featured projects

01
Energy Analytics Platform
End-to-end analytics platform combining batch and real-time pipelines. Delivers KPI monitoring across multiple stations, anomaly detection, consumption forecasting, and prescriptive analytics for renewable energy optimization.
KafkaMQTTPythonSQL ServerPower BI
02
IoT Streaming Pipeline
Real-time streaming architecture: MQTT → Kafka → SQL Server → Power BI. Designed for industrial data ingestion with low-latency monitoring and live dashboarding. Built to handle high-volume sensor telemetry reliably.
MQTTKafkaSQL ServerReal-timePower BI
03
Digital Twin & CBM
Digital twin for industrial compressors with synthetic dataset generation, real-time dashboards, and KPI-driven monitoring. Enables equipment health tracking, anomaly detection, and multi-level drilldown analytics.
Digital TwinPythonPower BIAnomaly Detection
04
Warranty Claims Analytics & AI
Full-stack analytics solution with data pipeline development, historical trend analysis, ML-based forecasting, and an LLM chatbot for automated insights and reporting. Deployed end-to-end in production.
MLLLMPythonSQLPower BI
Career

Experience

Jul 2024
Present
Data Engineer
C4I4 Labs · Kirloskar Solar
  • Designed star-schema data warehouses and dimensional models supporting analytics across energy and operations domains
  • Built ETL/ELT pipelines (SSIS + Python) integrating sensors, APIs, ERP systems, SharePoint, and flat files
  • Architected real-time IoT pipeline: MQTT → Kafka → SQL Server → Power BI, enabling near real-time monitoring and anomaly detection
  • Optimized SQL queries, views, and stored procedures; improved pipeline performance and reliability significantly
  • Delivered Power BI dashboards and governance (RLS, workspace admin, report endorsement) across multiple teams
  • Ran Power BI and data engineering training workshops for clients including Tata Motors stakeholders
Jan 2024
Jul 2024
Data Science Intern
Indi4 Consult Pvt Ltd
  • Built Power BI dashboards with Deneb/Vega custom visuals for BRSR sustainability reporting
  • Performed analysis on multi-source datasets, supporting stakeholder reporting and business insights
  • Assisted in data modeling, transformation, and reporting workflows using Power BI and SQL
Aug 2023
Dec 2023
Database Intern
Pune Municipal Corporation · IT Dept
  • Supported database administration and data management for government IT systems
  • Assisted with data quality validation, reporting, and query optimization
Let's connect

Get in touch

Open to Data Engineer, Analytics Engineer, and BI Developer roles. Comfortable with hybrid and remote setups.

✉
anujgaikwad392@gmail.com
Email
 in
linkedin.com/in/anujgaikwad
LinkedIn
 ⌥
github.com/anujgaikwad
GitHub
 M
medium.com/@anujgaikwad
Medium
Let's build something
reliable together.

Based in Pune, India. Available for full-time roles and freelance data engineering projects.

Outside of work
🏔 Trekking ♟ Chess 📚 Reading 🏊 Swimming