Headline

Data Engineer | Analytics Engineer | Snowflake | dbt | SQL

About

Senior Analytics/Data Engineer with 6+ years across BI and the modern data stack. I build ETL/ELT pipelines on Snowflake and dbt that process 15M+ records a day. Recent wins: cut data-prep time 35%, reduced Snowflake credit spend through warehouse tuning, and built PySpark transformations on Databricks. Earlier at Capgemini, I designed star-schema data models and dashboards serving 300+ stakeholders. I also ship product. I built OneOnOne, a B2B SaaS, solo (Next.js, Supabase, LLMs, real billing), then built its analytics layer on live production data: Python ingestion into Snowflake, 17 dbt models with 80+ tests, a MetricFlow semantic layer, and a daily Dagster asset graph. Having designed the product, I know what every metric means. Open to Senior Analytics Engineering and Data Engineering roles. Stack: SQL, Python, dbt, Snowflake, Databricks, PySpark, Dagster, Airflow, AWS, dimensional modeling (Kimball, SCD), Qlik Sense, Metabase Let's build: kara_himanshu@yahoo.com

Location

Bengaluru

AI stack

antigravity

claude code

claude

codex

cursor

langgraph

Work experience

Senior Data Engineer at KPMG, Apr 2024 - Present · 2 yrs 7 mos, Hybrid, - Build and own ETL/ELT pipelines processing 15M+ records daily into Snowflake for an energy-trading analytics platform, using Advanced SQL (CTEs, window functions, stored procedures), cutting data-prep time 35%. - Own the dbt staging-to-marts architecture on Snowflake: governed, tested, self-serve dimensional data models (star schema, SCD Type 1/2) that replaced manual reporting for cross-functional teams. - Reduced long-running query times and Snowflake warehouse credit spend via performance tuning: clustering high-volume tables, partition pruning, right-sizing warehouses. - Engineered PySpark transformations on Databricks to process high-volume raw datasets beyond SQL-only limits into analysis-ready Snowflake tables.

Data Engineer at KPMG, Jun 2022 - Apr 2024 · 1 yr 11 mos, On-site, - Built dbt models and ETL/ELT ingestion pipelines into Snowflake for the energy-trading analytics platform, transforming raw multi-source data into tested, documented datasets. - Established data quality testing, naming conventions, and monitoring across the dbt project, improving dataset reliability and enabling self-serve analytics. - Wrote Python ingestion and automation scripts; worked with incremental loading and CDC patterns for high-volume tables.

Senior Data Analyst at Capgemini, Sep 2020 - Jun 2022 · 1 yr 10 mos, Mumbai, - Improved dashboard query performance 30% for 300+ stakeholders by designing and optimizing star-schema dimensional data models in SQL Server and Qlik Sense (Business Intelligence). - Reduced dashboard refresh time 60% while ensuring data accuracy via incremental loading and change data capture (CDC).

Data Analyst at Capgemini, Sep 2019 - Sep 2020 · 1 yr 1 mo, Pune District, - Saved 360+ analyst hours annually by automating 25+ reporting workflows with Python and Qlik load-script automation. - Developed and maintained Qlik Sense BI dashboards on SQL Server data; wrote complex SQL for reporting datasets.

Intern - Capgemini at Capgemini Engineering, Dec 2018 - Mar 2019 · 4 mos, Chennai

Intern - Center for Artificial Intelligence and Robotics (CAIR), DRDO at Centre for Artificial Intelligence & Robotics, DRDO, Sep 2018 - Dec 2018 · 4 mos, Bengaluru, Karnataka, India

Education

Bachelor of Technology - BTech, Electrical, Electronics and Communications Engineering, Veltech Dr.RR Dr.SR University

Class XII, HSC, Aditya Birla Higher Secondary School, Nagda

Public links

github: https://github.com/whysokara