# Prerit Mahajan

Prerit Mahajan is a remote worker on Himalayas, Senior Data Engineer at Oasys International, LLC, based in United States.

Source: https://himalayas.app/@preritmahajan1

```text
Senior Data Engineer building scalable ETL/ELT and lakehouse architectures that power analytics and AI/ML pipelines.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Senior Data Engineer, Data Engineer, Data Scientist, SQL Developer, Senior Data Engineering, Senior Data Analytics Engineer, Senior Data Management Engineer |
| Skills | Python, SQL, PySpark, NumPy, Java, C++, Scala, ETL ELT Data Pipelines, Data Modeling, Schema Design, Medallion Architecture, Lakehouse Architecture, Data Lake, Apache Spark, Spark Structured Streaming, Kafka, Databricks, Delta Lake, Unity Catalog, Pandas, Apache Parquet, Avro, Data Warehouse, S3, ORC, Snowflake, Redshift, Azure Synapse, BigQuery, PostgreSQL, MySQL, Redis, AWS Glue, AWS Lambda, AWS Sagemaker, Azure Data Factory, ADLS, Azure Databricks, Great Expectations, Data Validation, Data Quality, Metadata Management, Data Lineage, DBT, CI CD, Terraform, Docker, Kubernetes, Git, Pipeline Development, Feature Engineering, Model Evaluation, REST, gRPC, OpenAPI, Protobuf, Power BI, Tableau, Matplotlib, SeaBorn, 100ms, Airflow, BASH, Factory, JSON, Redis Cloud |

## What I'm looking for

```text
I’m looking for a production-focused data engineering role where I can design resilient ETL/ELT, strengthen data quality monitoring, and partner with data scientists to deliver AI/ML-ready datasets at scale.
```

## About

```text
I’m a Senior Data Engineer with 10+ years designing and maintaining scalable ETL/ELT pipelines, data models, and lakehouse/data warehouse architectures across AWS, Azure, and GCP. I turn raw, semi-structured data into reliable, structured formats that directly support analytics and AI/ML workflows.

At Oasys International, I architected enterprise pipelines using Python, PySpark, NumPy, and SQL—reducing analysis turnaround by 30% and cutting 8-hour processing runs to under 6 hours. I also built Medallion Architecture models for 500,000+ record datasets and deployed data quality monitoring aligned with Great Expectations across 5+ concurrent workstreams.

I’ve driven production impact through REST API integrations, CI/CD-driven automation (reducing manual operations by 70%), and cross-team collaboration—improving congestion prediction model accuracy by 25%. Earlier roles include building ELT/ETL systems for 5M+ records/month with 99.9% uptime, and delivering high-performance ML and data services at Nike supporting 50M+ users during global launches.
```

## Experience

### Senior Data Engineer

Oasys International, LLC. Apr 2021 - Jan 2026

```text
Architected and maintained enterprise ETL/ELT pipelines that reduced analysis turnaround by 30% and cut 8-hour runs to under 6 hours. Built Medallion Architecture data models and Great Expectations-aligned data quality monitoring, improving data integrity across 5+ concurrent research workstreams.
```

Skills: Python, PySpark, SQL, ETL, Medallion-Architecture, Delta-Lake, Great-Expectations, Terraform, Docker, Airflow

### Data Engineer

The Judge Group. May 2017 - Mar 2021

```text
Designed and maintained ELT/ETL pipelines across 6 integrations for a top-10 U.S. health payor, processing 5M+ member/claims records per month while reducing processing delays by 50% and increasing throughput by 40%. Implemented data models, validation rules, and batch workflows with Airflow to reduce data quality incidents by 60% and cut manual operations by 80%, saving 20+ hours/week.
```

Skills: ETL, SQL, Python, Data-Modeling, Data-Validation, PostgreSQL, MySQL, Data-Quality, Batch-Processing, Airflow

### Data Scientist

[Nike](https://himalayas.app/companies/nike). Sep 2013 - Apr 2017

```text
Built high-performance Python and Java data services on the SNKRS platform, sustaining 2M+ simultaneous requests with sub-100ms latency during global launch events. Developed an ML-based anti-bot detection pipeline that reduced automated abuse by 65% and protected $10M+ in annual GMV.
```

Skills: Python, Java, Machine-Learning, Data-Pipelines, Anti-Bot-Modeling, Redis, AWS, GCP, Performance-Optimization

### SQL Developer

[Google](https://himalayas.app/companies/google). Jan 2012 - Aug 2013

```text
Developed SQL and C++ components for Mesa to support analytics pipelines processing 10B+ rows/day across petabyte-scale, multi-datacenter environments. Contributed to MapReduce ETL optimizations and improved cross-datacenter reliability from 97.2% to 99.4% through consistency and replication mechanisms.
```

Skills: SQL, C++, MapReduce, Distributed-Systems, ETL, Replication, Cross-Datacenter-Reliability, Performance-Optimization

## Education

### Harvard University

Master's degree, Computer Science. 2008 - 2012

```text
Earned a Master's degree in Computer Science at Harvard University from 2008 to 2012.
```

### University of Illinois Urbana-Champaign

Bachelor's degree, Computer Science. 2004 - 2008

```text
Earned a Bachelor's degree in Computer Science at the University of Illinois Urbana-Champaign from 2004 to 2008.
```

## Tech stack

- OpenAPI
- Azure Synapse
- Apache Spark
- Kubernetes
- NumPy
- Pandas
- PySpark
- dbt
- MySQL
- PostgreSQL
- Databricks
- Redis
- Terraform
- Java
- JSON
- Kafka
- gRPC
- Protobuf
- Avro
- Airflow
- Redis Cloud
- SQL
- Delta Lake
- Great Expectations
- Bash
- Apache Parquet
- Transform
- 100ms
- Unity Catalog
- Factory
- Jan
- Seaborn

To contact Prerit, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Syeda Yasir](https://himalayas.app/@syedayasir): Staff Data Engineer, Monte Carlo
- [Saujan Baniya](https://himalayas.app/@saujanbaniya): Senior Data Engineer, Pfizer
- [Sakchham Shrestha](https://himalayas.app/@sakchhamshrestha): Senior Data Engineer, CVS Health
- [Bin Yasir](https://himalayas.app/@binyasir2): Solution Architect, G2O
- [Haven Intezar](https://himalayas.app/@havenintezar1): Senior Data Engineer, Square
- [Mohiba Jalil](https://himalayas.app/@mohibajalil): Senior Data Engineer, Databricks
- [Sabina Gurung](https://himalayas.app/@sabinagurung): Senior Data Engineer, Metlife
- [luke lopez](https://himalayas.app/@lukelopez): Senior Data Engineer, Walmart
- [Michael Carrell](https://himalayas.app/@michaelcarrell): Senior Data Engineer, Redfin
- [Anish Pokharel](https://himalayas.app/@anishpokharel): Senior Data Engineer, Mass Mutual
