Welcome to

PrakharMittal’s

Portfolio

000

Data Engineering Leadership · PMP® Certified · Banking & Financial Services

Data Solution Analyst & PMP® Certified Leader

8+ years directing enterprise-scale ETL pipelines, Big Data transformations, and cross-functional technology initiatives — combining deep technical acumen with rigorous project management methodologies.

Mumbai, Indiaprakharmittal1510@gmail.com

Experience & Leadership

Bridging complex big data engineering with strategic project management.

As an accomplished Data Engineering Leader and Project Management Professional (PMP®), I design scalable cloud architectures, direct cross-functional technology initiatives, and build high-performance analytics platforms using AWS, Apache Spark, Hadoop, PySpark, SQL, and Airflow. By combining deep technical expertise with rigorous project management methodologies—such as Agile/Scrum, risk mitigation, and resource allocation—I help global financial institutions align complex engineering roadmaps with strategic business objectives.

  1. IDFC FIRST Bank logo

    IDFC FIRST Bank

    Data Solution Analyst

    • Leading end-to-end development of scalable ETL pipelines using Amazon Web Services EMR, PySpark, and Jupyter Notebooks, processing high-volume banking datasets with ~30% improvement in data processing efficiency.
    • Spearheaded migration of enterprise data workloads from AWS (S3/EMR) to on-prem HDFS, ensuring a seamless transition and enhancing governance while achieving ~25% reduction in cloud infrastructure costs.
    • Engineered automated data orchestration using Apache Airflow, designing DAGs for complex dependencies; reduced manual intervention by ~70% and improved pipeline reliability.
    • Optimized PySpark transformations and execution strategies (partitioning, caching, join tuning), achieving ~35% reduction in job runtime and improved cluster resource utilization.
    • Developed interactive data analysis and validation frameworks using AWS Jupyter Notebooks, enabling faster debugging and reducing data validation effort by ~40%.
    • Implemented data quality checks, reconciliation logic, and monitoring mechanisms across pipelines, improving data accuracy and consistency by ~85%.
    • Collaborated with business stakeholders and analytics teams to design scalable data solutions, accelerating delivery timelines by ~20% for critical reporting use cases.
    • Managed production data pipelines with proactive risk monitoring and issue resolution, maintaining ~99.9% SLA adherence for enterprise data platforms.
  2. LTIMindtree logo

    LTIMindtree

    Specialist — Data Engineering

    • Directed Informatica migration from v10.1 to v10.4 Virtual Server Component, optimizing mappings, sessions, and pushdown queries for a 40% improvement in data processing speed.
    • Designed and optimized ETL pipelines with data quality rules and partition pruning, improving data accuracy and consistency by 80–85% across downstream compliance systems.
    • Managed and supported 100+ enterprise-scale ETL applications across the African continent using Hadoop, Teradata, Informatica, Unix/Linux, TWS Tivoli, CA WADE, and Airflow, ensuring 99.9% SLA adherence.
    • Developed and deployed scalable ETL scripts (Python, Spark, Sqoop, Shell) for integrating structured and semi-structured data into Hadoop, enabling near real-time analytics.
    • Refactored legacy data models by introducing partitioning, bucketing, and clustered tables, and switching Spark execution to the Tez engine, reducing query runtime by 35%.
    • Drove migration of legacy on-prem Hadoop data marts to Dell ECS hybrid cloud object storage using HDFS-S3A DistCP, reducing on-prem storage overhead by 45% with 11-nines durability.
    • Onboarded 10+ business units onto Big Data platforms, providing ingestion frameworks, access governance (Ranger/Atlas), and scheduling automation, increasing enterprise adoption by 50%.
  3. ABSA · Barclays Africa Group logo

    ABSA · Barclays Africa Group

    Senior Data Engineer — On-site with LTIMindtree

    • Initiated and led the Data Rail Program, transforming legacy Teradata warehouses into a scalable Hadoop-based architecture and enabling SQL-to-Spark SQL translation with a 45% reduction in query processing time.
    • Managed an on-site and offshore team of 12 Big Data Engineers, ensuring cross-functional coordination and maintaining over 98% delivery compliance.
    • Converted Teradata marts and extracts for 12 African countries into Hadoop marts using Hive, Spark, and Teradata utilities, achieving 50% faster ingestion and 30% savings in infrastructure and licensing.
    • Built complex business and financial analytics pipelines by integrating multi-source data, doubling data-driven revenue potential for ABSA through enhanced decision-making capabilities.

Education & research

  • 2026

    Executive MBA, Business Administration & Management

    Symbiosis International University (SCMHRD), Pune

    • Highest CGPA in the batch
    • Student of the Year
    • Top scorer in Finance & Business Analytics

    8.25/10

    CGPA

  • 2019

    B.Tech in Information Technology

    SRM Institute of Science and Technology, Chennai

    7.11/10

    CGPA

  • 2026

    Project Management Professional (PMP)®

    Project Management Institute (PMI) · Global Credential

    • Passed with Above Target result
    • Certified in Agile, Hybrid & Predictive Delivery
  • 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 analyzing the measurable effect of U.S. tariff-policy announcements on Indian equity prices.

Resume

The full record, on one page.

PDF · 108 KB · Updated October 2026

Capabilities

The stack, measured.

0+

Years in data engineering & leadership

0+

Enterprise ETL applications supported

0

African markets managed on-site

0%

Production SLA adherence

Skill Domain Focus

  • Big Data & CloudSpark · Hadoop · AWS94
  • Project ManagementPMP · Agile · Risk & Delivery96
  • Data EngineeringETL · Migration · Tuning95
  • Databases & SQLTeradata · Oracle · SQL88
  • Programming & GovernancePython · Scala · Airflow90

Active Tech Stack Heatmap

96
Project Management & PMP
95
Spark & PySpark
92
Hadoop EcosystemHDFS · Hive · Tez
88
AWSEMR · S3
90
ETL & OrchestrationInformatica · Airflow

Interactive Project & Skill Filter

IDFC FIRST Bank

Banking ETL Pipelines & Governance

Scalable PySpark & AWS EMR pipelines with automated Apache Airflow orchestration, reducing manual intervention by 70%.

PySparkAWS EMRAirflowProject Management (PMP)

ABSA · Barclays Africa

Legacy Data Rail Program

Led cross-functional delivery across 12 African countries, migrating Teradata to Hadoop at 98%+ delivery compliance.

HadoopTeradataPySparkProject Management (PMP)

LTIMindtree

Hybrid Cloud Migration & Cost Optimization

On-prem Hadoop to Dell ECS (S3) object storage transition, reducing storage overhead by 45% and cloud costs by 25%.

HadoopAWS EMRInformaticaAgile/Scrum

Data Pipeline & Quality Viewer

S3 LandingExtractValidateTransformReconcileLoad · HivePublish Mart

Airflow dependency graph — the shape of a nightly banking load: extract fans out to validation and transform, reconciles, then publishes.