Available for opportunities

Hi, I'm Mayank Khurmai

> _

Cloud-certified Senior Data Engineer with 4+ years designing scalable data lakehouses, ETL pipelines & Data Vault 2.0 models across AWS, GCP & Azure — turning raw data into reliable, decision-ready intelligence for BFSI & fintech leaders.

Hire me Download CV
Portrait of Mayank Kumar Khurmai, Senior Data Engineer
AWS
Spark
DBT
Airflow
0 Years of Experience
0 BFSI Clients Served
0 Production APIs
0 Industry Certifications

01 — About

Engineering data that businesses trust

I'm a cloud-certified Senior Data Engineer based in India with over four years of hands-on experience designing and operating modern data platforms across BFSI & fintech — including major insurance firms, banks, and asset-management companies.

I'm currently a Senior Data Engineer at KFintech (KFin Technologies), building cloud-native data platforms for asset-management and investor-servicing data. Previously, at LUMIQ, I delivered scalable data lakehouses and Data Vault 2.0 models for 8+ BFSI clients — cutting data-retrieval time by 40% and boosting processing speed by 80% while reducing operational cost by 50%.

I care about reliability, traceability, and clean architecture — pipelines that are observable, compliance-ready, and built to scale.

LocationIndia
Experience4+ Years
RoleSr. Data Engineer @ KFintech

02 — Skills

My technical toolkit

Languages

PythonSQLPHP

Databases

MySQLPostgreSQLBigQueryRedshiftDatabricksDuckDB

Tools

Apache SparkDBTAirflowDocker

Cloud Platforms

AWSGCPAzure

Analytics

Data VaultData ModellingQuery Optimization

Familiar With

KafkaReal-time StreamingPower BIQuickSight

03 — Experience

Where I've made an impact

Senior Data Engineer

KFintech (KFin Technologies) Dec 2025 — Present

Cloud-native data engineering for one of Asia's largest registrar & transfer-agent (RTA) and fund-administration platforms.

  • Architect & scale cloud-native data platforms for asset-management, mutual-fund and investor-servicing data across KFintech's SaaS ecosystem.
  • Design high-throughput ETL/ELT pipelines with PySpark, DBT & Airflow powering fund accounting, investor and regulatory reporting.
  • Lead data modelling & warehouse design for high-volume transactional RTA datasets, ensuring accuracy and performance at scale.
  • Drive data quality, lineage & governance to meet SEBI and financial-compliance requirements, and mentor data engineers while shaping team engineering standards.

Data Engineer

LUMIQ Jun 2022 — Nov 2025

Worked with 8+ leading BFSI clients — major insurance firms, banks & AMCs.

  • Designed & implemented modern data pipelines and scalable data architectures (lakehouses, warehouses, marts) on AWS (EC2, RDS, Redshift, EMR, Lambda), Azure & GCP — cutting data-retrieval time by 40% and enabling accurate sales, operations & compliance reporting.
  • Built end-to-end Data Vault 2.0 models with DBT, PySpark & SQL, enhancing data traceability and supporting BI solutions for analytics & customer reporting.
  • Automated dynamic data ingestion & reporting with Apache Airflow and Power BI — enabling self-service analytics, 80% faster processing and 50% lower operational cost.
  • Developed & deployed 20+ production-grade APIs with encrypted authentication and dynamic tokenization, ensuring robust security & operational monitoring.
  • Built scalable changelog-based reporting solutions and metadata-driven pipelines for pipeline standardization & compliance-ready reporting across investment-lifecycle flows.
  • Implemented Spark SQL validation rules & reconciliation mechanisms on large transactional datasets, catching data anomalies early and improving reliability of monthly BI reports.
  • Optimized ETL pipelines across multiple sources for high availability & consistency, collaborating with data-science teams to support predictive modelling & customer insights.
  • Led cross-functional project teams and mentored junior engineers to deliver high-quality projects on time.

04 — Education

Academic background

B.Tech — Computer Science & Engineering

Ajay Kumar Garg Engineering College, Ghaziabad, UP 2018 — 2022

Advanced Diploma — Software Engineering

WAP Institute 2018 — 2021

05 — Projects

Selected work

A selection of platforms I've engineered across BFSI & fintech. Client specifics are generalized for confidentiality.

Data Platform

BFSI Data Lakehouse

Multi-cloud lakehouse on AWS/Azure/GCP unifying sales, operations & compliance data with 40% faster retrieval for reporting.

AWSRedshiftEMRSpark
Data Modelling

Data Vault 2.0 Engine

End-to-end Data Vault models in DBT + PySpark giving full lineage & traceability for analytics and customer reporting.

DBTPySparkSQL
Automation

Airflow Ingestion Suite

Metadata-driven, dynamic ingestion & reporting orchestrated with Airflow — 80% faster processing, 50% lower cost.

AirflowPythonPower BI
APIs

Secure Data API Layer

20+ production APIs with encrypted authentication & dynamic tokenization, plus monitoring for operational reliability.

RESTTokenizationPostman

06 — Certifications

Cloud & security certifications

AWS

Certified Data Analytics – Specialty

AWS

Certified Solutions Architect – Associate

AWS

Certified Developer – Associate

AWS

Certified Cloud Practitioner

GCP

Associate Cloud Engineer

GCP

Cloud Digital Leader

EC

Certified Ethical Hacker (CEHv11)

07 — Contact

Let's build something with your data

Open to data engineering roles, consulting & collaborations. The fastest way to reach me is email or LinkedIn.

Email me Connect on LinkedIn
Email Phone+91 97203 15564 GitHub@mayank-khurmai