# Sumanjali B

Sumanjali B is a remote worker on Himalayas, Senior Data Engineer at PNC Bank, based in United States.

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

```text
Senior Data Engineer at PNC Bank who built an Azure Databricks lakehouse that cut reporting latency from 6 hours to under 45 minutes.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 100k+ USD |
| Job categories | Data Engineer, Data Analyst, ETL Developer |
| Skills | Data Engineering, Cloud Data Platforms, Lakehouse Architecture, Medallion Architecture, Databricks, Snowflake, Apache Spark, PySpark, SQL, Python, Delta Lake, DBT, Airflow, Azure Data Factory, Kafka |

## About

```text
At PNC Bank, I designed batch and near-real-time pipelines for banking data in Azure Databricks. I built a Delta Lake Medallion Architecture that reduced reporting latency from 6 hours to under 45 minutes.

I also developed Kafka and Spark Structured Streaming pipelines for banking transactions and operational events. Across the lakehouse, I orchestrated workflows with Databricks, Azure Data Factory, and Apache Airflow, and developed dbt models for banking metrics.

At Wipro Technologies, I migrated a legacy SQL Server data warehouse to Snowflake on AWS for a healthcare client, processing 5TB+ daily at 99.6% SLA compliance. I rebuilt legacy logic in dbt and PySpark and implemented HIPAA controls for protected health information.

Earlier, at Dataone Solutions, I developed Hadoop and PySpark workflows for telecom usage data; at Accenture, I built SSIS packages and banking datasets in SQL Server. I hold Microsoft Certified Fabric Data Engineer Associate and Fabric Analytics Engineer Associate certifications.
```

## Experience

### Senior Data Engineer (current)

[PNC Bank](https://himalayas.app/companies/pnc). Apr 2025 - Present

```text
Designed and implemented batch and near-real-time pipelines in Azure Databricks using PySpark, Python, and SQL, integrating data from 12+ upstream banking systems into an ADLS Gen2 lakehouse. Built a Medallion Architecture on Delta Lake, reducing reporting latency from 6 hours to under 45 minutes for 150+ users.
```

Skills: Azure-Databricks, PySpark, Python, SQL, ADLS-Gen2, Delta-Lake, Azure-Data-Factory, Airflow, Kafka, Spark-Structured-Streaming, DBT, Unity-Catalog, Power-BI, SOX, PCI-DSS, CCAR, Basel-III, OCC

### Senior Data Engineer

[Wipro Technologies](https://himalayas.app/companies/wipro-limited). Dec 2022 - Aug 2024

```text
Migrated a legacy on-premises SQL Server data warehouse to a cloud-native Snowflake platform on AWS, processing 5TB+ daily at 99.6% SLA compliance. Designed a multi-layer Snowflake architecture with Snowpipe auto-ingest and implemented change data capture with Streams and Tasks.
```

Skills: Snowflake, AWS, S3, Snowpipe, Streaming, Task, DBT, PySpark, Airflow, Great-Expectations, HIPAA, RBAC, Data-Masking, Row-Access-Policies, Snowflake-Cortex-AI

### Big Data Engineer

Dataone Solutions. Jun 2019 - Nov 2022

```text
Built Python ingestion scripts to load daily call detail records and network usage files into HDFS on a multi-node Hadoop cluster. Developed PySpark jobs to deduplicate and aggregate data, and loaded results into Amazon Redshift, reducing data preparation time by 50%.
```

Skills: Python, HDFS, Hadoop, Hive, PySpark, Amazon-Redshift, SQL, Stored-Procedures, Scheduling

### ETL Data Engineer

[Accenture](https://himalayas.app/companies/accenture). Jul 2017 - May 2019

```text
Developed SSIS packages to load daily card transaction, authorization, and settlement data into SQL Server across 3 client engagement tracks. Built daily and monthly banking datasets in SQL Server, reducing report preparation time by 30%.
```

Skills: SSIS, SQL-Server, T-SQL, Stored-Procedures, SQL-Server-Agent, Indexing, Query-Optimization, PCI-DSS

## Education

### University of North Texas

Master of Science, Advanced Data Analytics

```text
Master of Science in Advanced Data Analytics from the University of North Texas.
```

### Osmania University

Bachelor of Engineering, Computer Science

```text
Bachelor of Engineering in Computer Science from Osmania University.
```

## Tech stack

- Amazon Redshift
- Snowflake
- Apache Spark
- Google Cloud Platform
- Amazon S3
- GitHub
- GitLab
- Jenkins
- PySpark
- dbt
- PostgreSQL
- Oracle
- Hadoop
- Databricks
- Terraform
- Python
- Kafka
- Git
- Docker
- Airflow
- SQL
- Delta Lake
- Great Expectations
- Microsoft Fabric
- Unity Catalog
- Power BI
- Apache Kafka
- AWS
- Azure
- Azure Data Factory
- SQL Server
- T-SQL

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

## People also viewed

- [Sai Swetha Paspunuri](https://himalayas.app/@saiswethapaspunuri): Senior Data Engineer, HCA Healthcare
- [Sara Wood](https://himalayas.app/@sarawood1): Lead Data Engineer, Databricks
- [Sabina Gurung](https://himalayas.app/@sabinagurung): Senior Data Engineer, Metlife
- [nirjal kharel](https://himalayas.app/@nirjalkharel): Senior Data Engineer, Pfizer
- [UDAY SRIDHAR REDDY BEERAM](https://himalayas.app/@udaysridharreddybeer): Data Engineer, Intuit
- [Vijay Alluri](https://himalayas.app/@vijayalluri): Sr. Data Engineer, U.S. Bank
- [Adarsha Khadka](https://himalayas.app/@adarshakhadka): Senior Data Engineer, Allstate
- [Akriti Luitel](https://himalayas.app/@akritiluitel): Senior Data Engineer, Merck
- [sreya p](https://himalayas.app/@sreyap): Senior Data Engineer, Tenet Healthcare
- [Sravya User](https://himalayas.app/@sravyauser3): Data Engineer, Global One Bank
