Welcome to

PrakharMittal’s

Portfolio

000

Data Engineering · Banking & Financial Services

Data Solution Analyst at IDFC FIRST Bank

Seven years building ETL and Big Data platforms on Spark, Hadoop and AWS — designing pipelines that move enterprise banking data reliably, at scale, and on time.

Mumbai, Indiaprakharmittal1510@gmail.com

Experience

Transforming data into intelligent business solutions.

With over 7 years of experience in Data Engineering and Big Data, I design scalable cloud architectures, optimize enterprise ETL pipelines, and build high-performance analytics platforms using AWS, Apache Spark, Hadoop, PySpark, SQL, and Airflow. My work has helped global financial institutions improve processing efficiency, reduce infrastructure costs, and unlock the full potential of their data.

  1. IDFC FIRST Bank

    Data Solution Analyst

    • Leads end-to-end development of scalable ETL pipelines on AWS EMR, PySpark and Jupyter, processing high-volume banking datasets with ~30% better processing efficiency.
    • Spearheaded the migration of enterprise workloads from AWS S3/EMR to on-prem HDFS, cutting cloud infrastructure cost by ~25% while tightening governance.
    • Orchestrates dependencies through Apache Airflow DAGs, reducing manual intervention by ~70%.
    • Runs reconciliation, data quality and monitoring across pipelines, holding ~99.9% SLA adherence in production.
  2. ABSA · Barclays Africa Group

    Senior Data Engineer — on-site with LTIMindtree

    • Initiated and led the Data Rail Program, moving legacy Teradata warehouses onto a Hadoop architecture and translating SQL to Spark SQL — 45% faster query processing.
    • Managed 12 Big Data engineers across on-site and offshore teams at >98% delivery compliance.
    • Converted Teradata marts for 12 African countries into Hadoop marts, 50% faster ingestion and 30% infrastructure savings.
  3. LTIMindtree

    Specialist — Data Engineering

    • Supported 100+ enterprise-scale ETL applications across the African continent on Hadoop, Teradata, Informatica, TWS Tivoli, CA WADE and Airflow.
    • Led the Informatica 10.1 → 10.4 migration, tuning mappings, sessions and pushdown queries for a 40% gain in processing speed.
    • Drove the move of on-prem Hadoop data marts to Dell ECS object storage via HDFS–S3A DistCp, tiering and JCEKS-encrypted credentials — 45% less on-prem storage overhead.
    • Onboarded 10+ business units onto the Big Data platform with ingestion frameworks and Ranger/Atlas access governance.

Education & research

  • 2026

    Executive MBA, Business Administration & Management

    Symbiosis International University (SCMHRD), Pune

  • 2019

    B.Tech in Information Technology

    SRM Institute of Science and Technology, Chennai

  • 2026

    Event Study of the Effect of U.S. 2025–26 Tariffs on the Indian Stock Market

    MBA dissertation — hand-collected dataset, event-study methodology on Indian equity prices.

Resume

The full record, on one page.

PDF · 108 KB · Updated July 2026