Data Engineer with less than a year in ELT pipeline design & BI reporting.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
B.Tech IT student (graduating 2027) with internship experience and self-driven projects across ELT pipeline design, dimensional modeling, and BI reporting. Built production-pattern data systems on Databricks, BigQuery, and AWS S3 from raw ingestion through medallion architecture to star-schema outputs consumed by Tableau.
ABES Engineering College, Ghaziabad
B.Tech · Information Technology
N/A – June 30, 2027
Nest N Wings
Data Engineering Intern
January 1, 2026 – April 1, 2026
India
Olist Data Pipeline & Analytics Dashboard
May 1, 2026 – May 1, 2026
Designed a layered dbt data model (staging → fact → marts) with a central fact_orders table at order-level grain joined to 4 dimension tables (customers, sellers, products, dates), enabling accurate multi-dimensional analysis across 100K+ e-commerce orders. Built an end-to-end ELT pipeline (AWS S3 → Snowflake → dbt → Tableau) with incremental models, dbt snapshots for slowly changing customer records, and automated not null / unique data quality tests ensuring analytics reliability.
View ProjectFMCG Data Engineering Pipeline
December 1, 2025 – December 1, 2025
Implemented a Bronze→Silver→Gold ELT pipeline on Databricks with full-load and incremental ingestion (UPSERT); Silver-layer quality checks caught ~4.8% duplicate rows and ~3.1% null/invalid records before Gold promotion. Designed a star schema (fact_orders + 3 dimension tables) with grain-level contracts across sales, customers, products, and pricing, eliminating metric ambiguity across 4+ reporting use cases. Automated a nightly Databricks Workflow with sequential notebook execution and failure alerting, producing analytics-ready Delta tables consumed by a live dashboard.
View ProjectSupply Chain Performance Analytics & Forecasting
September 1, 2025 – September 1, 2025
Processed 180K+ order records end-to-end from BigQuery transformation to Tableau, delivering KPIs on delivery delays, fulfillment rates, and regional sales via CTE-based logic and window functions (RANK, LAG). Engineered reusable SQL transformation logic standardising metrics across 6+ reporting dimensions, including MoM trend analysis and delivery delay attribution by region and carrier. Trained a Prophet demand forecasting model on 18 months of order history; exposed outputs through a parameter-driven Tableau dashboard for inventory planning scenario analysis.
View ProjectDatabricks Lakehouse Fundamentals
Databricks
June 1, 2026 – Present
AWS Academy Cloud Architecting (Trained)
AWS Academy
June 1, 2026 – Present
Big Data Computing
NPTEL, IIT Kanpur
November 1, 2025 – Present
Cultural Fit Analysis
The candidate's diverse project portfolio, covering supply chain, FMCG, and e-commerce domains, indicates adaptability and a broad interest in applying data engineering principles across different industries. Their focus on building robust, analytics-ready data systems aligns well with a data-driven culture. The certifications in Big Data Computing and AWS Cloud Architecting show a commitment to continuous learning and staying updated with industry trends, which is a positive cultural fit.
Soft Skills & Operational Fit
The candidate demonstrates strong problem-solving skills through their project work, tackling complex data challenges like demand forecasting and supply chain analytics. Their ability to design and implement end-to-end data pipelines suggests good operational thinking and attention to detail. The project descriptions indicate a proactive and self-driven individual capable of independent work.