Headline

Software Developer Engineer II @ Kapture CX | Data Engineering & OLAP | Java • Python • SQL | Building real time analytics (Kafka, Flink, StarRocks, Apache Iceberg)

About

Software Developer Engineer II at Kapture CX, focused on data engineering and real-time analytics infrastructure. I build the systems that turn raw operational data into fast, self-serve business intelligence. My current and most impactful work centers on OLAP, change data capture, and large-scale data migration: • Engineered core components of an analytics infrastructure that migrated reporting from MySQL to an OLAP stack, delivering 10X faster querying and self-serve BI dashboards. • Designed a CDC pipeline capturing MySQL changes into RisingWave with S3 persistent storage, streaming to StarRocks on demand — offloading analytical querying off the transactional production database (MySQL). • Executed a zero-downtime bulk migration using OLake to move MySQL data into an Apache Iceberg data lake, decoupling historical storage from active compute. • Implemented multi-tenant security and RBAC via client-specific views for isolated, secure external BI reporting. • Developed Python-based ETL pipelines processing 1M+ records daily. Core stack: Java, Python, SQL, Kafka, Apache Flink, RisingWave, Apache Iceberg, OLake, StarRocks, MySQL, Redis, Metabase, AWS, GCP, Spring Boot, Docker. Recognized with Kapture CX's Spot Award (Jan 2026) and Top Performer Award (July 2025).

Location

Greater Bengaluru Area

AI stack

claude code

claude

codex

gemini

Work experience

Software Engineer II, Data Platform at Kapture CX, Oct 2025 - Present · 1 yr, • Engineered core components of an analytics infrastructure, migrating from MySQL to OLAP, which enabled self-serve BI dashboards and resulted in 10X faster querying. • Offloaded analytical querying off the transactional production database (MySQL) by designing a CDC pipeline that captures MySQL changes into RisingWave, using S3 persistent storage to safely stream data to StarRocks on demand. • Implemented strict multi-tenant security and Role-Based Access Control (RBAC) via client-specific views, ensuring fully isolated and secure data access for external BI reporting. • Implemented a zero-downtime bulk data migration using OLake to extract MySQL data into an Apache Iceberg data lake via off-peak batch processing, decoupling historical storage from active compute. • Developed Python-based ETL pipelines to process 1M+ records daily, automating complex business logic and reducing client reporting time.

Software Engineer at Kapture CX, Jul 2024 - Sep 2025 · 1 yr 3 mos, • Reduced report generation memory consumption by 80% (from 10 GB to 2 GB) via day‑wise batch processing, switching heavy XLSX exports to CSVs, and leveraging Redis caching instead of local hashmaps. • Re‑architected dashboard data flow using token‑based asynchronous processing, reducing load wait time by ~70% and enabling scalable, non‑blocking data retrieval. • Simplified dashboard creation for industry‑specific clients, cutting setup time from ~30 minutes to one click and improving onboarding efficiency. • Owned the full lifecycle of critical production issues from detection to root cause analysis and long‑term prevention, helping maintain 100% SLA compliance.

Software Developer Trainee at Kapture CX, Jul 2023 - Jun 2024 · 1 yr, • Developed a serverless data export pipeline using Google Cloud Functions, achieving ~5x faster processing for large datasets with asynchronous execution and auto-scaling. • Re-engineered core components of 5+ APIs during a migration to microservices: upgraded to Java 17, refactored data access from native SQL to Hibernate ORM, and introduced Redis cache. • Automated client-wise uploads using the Amazon S3 Java SDK, saving 40+ hours of manual work per month.

Education

Bachelor of Engineering, Computational Science, Chitkara University

Public links

leetcode: https://leetcode.com/gambhirsamarth

github: https://github.com/gambhirsamarth