Srividya Mandalapu
Plano
Summary
Results-driven Data Engineer with over 6 years of experience designing, building, and optimizing high-volume data pipelines and real-time streaming solutions. Expert in SQL, Python, PySpark, Databricks, and AWS, with a proven ability to improve performance, reliability, and scalability. Adept at partnering with cross-functional teams to deliver data products that enable analytics, audience targeting, and business insights. Experienced in leveraging AI-assisted development tools like GitHub Copilot to accelerate coding, enhance pull request reviews, and improve code quality.
Overview
7
7
years of professional experience
Work History
Software Development Engineer II
Warner Bros & Discovery
Richardson
05.2023 - Current
- Drove ~$800M in annual ad revenue by building WBD's enterprise C360 ID Spine, unifying 1st-party (MAX, D+, CNN, Games, Sports, PRISM) and 3rd-party (Adstra, Inscape) data into a household identity graph.
- Cut data processing times and scaled to tens of millions of daily records by optimizing PySpark jobs, broadcast joins, and Snowflake loads.
- Enabled cross-brand marketing and advanced targeting by implementing deterministic household identity resolution (Email → Device → IP).
- Delivered 99.9% pipeline uptime through automated data quality checks, PagerDuty monitoring, and fault-tolerant ELT workflows.
- Accelerated new partner onboarding with reusable ingestion frameworks, reducing integration effort and time.
- Streamlined ingestion from AWS S3 to Snowflake with Airflow DAGs, Jenkins pipelines, and Databricks workflows, powering downstream segmentation and analytics.
- Ensured privacy and compliance by embedding consent scrubbing, TTL policies, and noise-cancellation logic into identity pipelines.
- Standardized CI/CD deployments with GitHub Actions, improving release velocity and reliability across environments.
- Partnered with marketing, privacy, and analytics teams to align ID Spine with global advertising and compliance requirements.
Data Engineer
AT&T
Plano
04.2021 - 03.2023
- Created real-time features from streaming data using Flink to feed scoring models for fraud risk decisions.
- Worked with Kafka and Hive to support streaming data ingestion and transformation.
- Built Spark-based ETL pipelines in Databricks for structured/semi-structured telemetry data.
- Deployed containerized jobs using Docker and Kubernetes.
- Integrated data pipelines with Hive, HDFS, and cloud storage systems.
Data Engineer
AT&T
Plano
02.2020 - 04.2021
- Built reporting pipelines in Palantir using Contour and Monocle; scheduled jobs and tracked data lineage.
- Developed PySpark workflows with UDFs for data enrichment and cleansing.
- Used Sqoop for incremental data loads; automated scheduling with Autosys and Cron.
- Created report-ready Excel outputs using Python (matplotlib, openpyxl, xlsxwriter).
- Led application flow from requirements gathering to production deployment.
QA Engineer
BBVA BANK
Birmingham
09.2018 - 02.2020
- Developed and maintained automated test cases using Selenium and TestNG for web-based applications.
- Executed manual and automated testing for UI and backend systems to ensure quality releases.
- Created SQL queries for data validation and verification during test cycles.
- Documented test scenarios, reported defects, and collaborated with dev teams for timely resolutions.
Education
Master of Science - Computer Science
Governors State University
Park Forest, IL05.2018
Bachelor of Science - Computer Science
JNT University
INDIA05.2014
Skills
- AWS
- Azure
- Hadoop
- Snowflake
- Databricks
- Airflow
- Kubernetes
- Docker
- Python
- PySpark
- Scala
- SQL
- Spark
- MLlib
- Kafka
- Redis
- Dbt
- Palantir
Timeline
Software Development Engineer II
Warner Bros & Discovery
05.2023 - Current
Data Engineer
AT&T
04.2021 - 03.2023
Data Engineer
AT&T
02.2020 - 04.2021
QA Engineer
BBVA BANK
09.2018 - 02.2020
Master of Science - Computer Science
Governors State University
Bachelor of Science - Computer Science
JNT University