Sravya Botu

Data Engineer with 4+ years of experience designing and operating scalable ETL/ELT pipelines, cloud data warehouses, and data models that power analytics and reporting in the financial services and pharmaceutical domains. Strong in Python, SQL, PySpark, and Apache Airflow on AWS, with hands-on work across ingestion, transformation, orchestration, and data quality. Builds reliable, cost-efficient data infrastructure and partners with analytics, engineering, and compliance teams to deliver production-grade data in regulated environments.

Data Engineer - First Republic Bank - USA

(2024-02)

• Designed and maintained ETL/ELT pipelines in Apache Airflow and AWS Glue to ingest and transform banking transaction, account, and customer data into a Snowflake warehouse, improving pipeline reliability and cutting daily load failures by ~40%.
• Built PySpark and SQL transformations on AWS EMR and Redshift to process millions of daily records, converting raw source data into curated, analytics-ready layers using dimensional (star-schema) models.
• Orchestrated and monitored scheduled workflows, embedding data validation, reconciliation, and lineage checks to ensure accuracy for audit and SOX-related reporting.
• Tuned warehouse models and SQL queries to reduce cloud compute cost and shorten downstream dashboard refresh times.
• Automated regulatory and management data feeds that previously ran as manual spreadsheet processes, cutting preparation time from days to hours.
• Collaborated in an Agile team using Git and CI/CD to version, test, and deploy transformation code and data models.

Junior Software Engineer - EPAM Systems - Hyderabad, India

(2020-04 - 2022-07)

• Developed and maintained Python and SQL data-processing routines for client applications, writing clean, tested code to clean, validate, and load production and batch-quality data.
• Consolidated manufacturing, quality, and supply-chain data from multiple source systems into a centralized SQL Server warehouse, standardizing schemas for consistent reporting.
• Implemented and documented source-to-target mappings and data definitions, improving data consistency and speeding onboarding for new team members.
• Built operational Power BI dashboards on top of the warehouse to track production yield, cycle times, and quality KPIs.
• Supported code reviews, bug fixes, and release activities within an Agile team, using Git for version control.

Master of Science - Data Science - New Jersey Institute of Technology (2023)

Bachelor of Technology - Electronics and Communication Engineering - CMR Institute of Technology (2021)