Tirtha Mandal

Lead Data Engineer & Cloud Solution Architect

Innovative leader with 11+ years of experience designing enterprise-scale data platforms across AWS, Azure, and GCP. Specializing in real-time streaming, data lakehouse architecture, and AI-driven analytics.

View Projects Contact Me
Scroll Down

About Me

Get to know me better

Innovative Leader in Data Engineering

Results-driven Lead Data Engineer & Solution Architect with 11+ years of experience designing and delivering enterprise-scale data platforms across AWS, Azure, and GCP. Adept at building real-time streaming pipelines, modern ETL/ELT workflows, and scalable data lakehouse solutions that power analytics and AI.

Proven track record in healthcare, finance, and SaaS industries, enabling secure, compliant, and highly available data systems that process billions of events daily. Skilled at driving digital transformations, improving operational efficiency, and reducing infrastructure costs through automation, architecture modernization, and governance frameworks.

Recognized for mentoring teams, leading cross-functional initiatives, and bridging the gap between technical execution and business strategy. Passionate about creating data ecosystems that accelerate innovation, enable self-service analytics, and ensure data trust across the enterprise.

7+ Years Experience
10+ Projects Completed
10+ Technologies

Technical Skills

My expertise areas

Cloud Platforms

  • AWS (Redshift, Glue, EMR, S3, Lambda)
  • Azure (Synapse, Data Factory, Data Lake)
  • GCP (BigQuery, Dataflow, Vertex AI)
  • Databricks, Snowflake

Streaming & Processing

  • Apache Kafka, Flink, Spark
  • Kinesis, Google Pub/Sub
  • Real-time Data Pipelines
  • Event-driven Architecture

Data Engineering

  • ETL/ELT, Data Modeling
  • Data Lakes, Data Warehouses
  • Delta Lake, Apache Hudi
  • SQL, Python, Scala

DevOps & Security

  • Terraform, Kubernetes, Docker
  • CI/CD, GitOps
  • HIPAA, SOC 2, GDPR
  • Data Governance

Professional Experience

My career journey

2021 – Present

Sr Data Engineer

LA Global

  • Designed real-time healthcare data integration platform handling HL7/FHIR messages and IoT medical device data
  • Architected streaming pipelines using Apache Kafka and Flink for low-latency patient event processing
  • Built Databricks-based predictive analytics platform improving proactive interventions by 22%
2021 – Present

Adjunct Lecturer

City University of New York

  • Designed multi-cloud enterprise data platforms unifying AWS, GCP, and Azure
  • Created high-throughput streaming framework processing 20B+ daily transactions
  • Reduced infrastructure costs by 40% through workload optimization
2018 – 2020

Data Engineer

IBM

  • Designed and maintained enterprise data warehouse for financial reporting
  • Migrated legacy ETL workflows to Python, improving throughput by 50%
  • Developed Tableau dashboards for executive decision-making

Key Projects

Highlighted work and achievements

Healthcare Predictive Analytics Platform
Healthcare

Healthcare Predictive Analytics Platform

Built a HIPAA-compliant real-time patient data ingestion and analytics platform integrating EMR/EHR systems, HL7/FHIR feeds, and IoT medical devices.

Apache Kafka Databricks Azure Synapse
Multi-Cloud Data Lakehouse
Multi-Cloud

Multi-Cloud Data Lakehouse

Led migration from fragmented on-prem warehouses to a unified multi-cloud lakehouse, enabling federated queries across AWS, Azure, and GCP.

AWS Redshift GCP BigQuery dbt + Airflow
Supply Chain Visibility System
Supply Chain

Supply Chain Visibility System

Developed a real-time monitoring system processing 5B+ daily events from IoT sensors, ERP systems, and partner APIs with predictive analytics.

AWS S3 Delta Lake Apache Spark

Get In Touch

Let's work together

Contact Information

Feel free to reach out for project inquiries, collaborations, or just to connect!

tirtha.mandal7812@gmail.com
East Meadow, NY, 11554, USA