RAJA NANDINI BHAVANAM
Jersey City,NJ
Summary
Data Engineer with 5+ years of experience building ETL/ELT pipelines that turn data from databases, recurring files, APIs, and cloud platforms into reliable datasets for reporting and analytics. Writes complex SQL — joins, CTEs, window functions, MERGE/upsert logic — to enforce schema rules and prepare data for downstream BI applications. Experienced in third-party API integration, production pipeline troubleshooting, and translating stakeholder reporting needs into practical, maintainable data solutions
Overview
1
1
Certification
5
5
years of professional experience
Work History
Data Engineer
PamTen
06.2025 - Current
- Led an AWS-to-Snowflake migration PoC using AWS AppFlow and PySpark-based Glue jobs, reducing transformation overhead by ~30%.
- Reworked SQL and PySpark ETL pipelines to standardize data from multiple source systems, improving processing times across production workloads.
- Built reusable AWS CDK components (Glue, Lambda, Step Functions, S3, IAM), reducing repeated setup work for new data workflows.
- Designed federated querying across DynamoDB, MySQL, Athena, and Redshift Spectrum, giving analysts a consistent layer to access data from multiple systems.
- Curated SQL views feeding stakeholder-facing Power BI dashboards, resolving discrepancies between source-system and dashboard totals.
- Added retry handling and recovery steps to Glue and Step Functions workflows, minimizing manual intervention during pipeline failures.
Data Engineer
HCA
09.2023 - 05.2025
- Built and maintained 6 ETL pipelines using Python and SQL, consolidating claims, patient, provider, and operational data from multiple source systems into a unified reporting dataset.
- Automated daily incremental loads and implemented 15+ data-quality checks (nulls, duplicates, invalid dates), enforcing schema integrity before data reached downstream reports.
- Built a repeatable Python/SQL process to validate a recurring CSV export from the operations team — standardizing inconsistent columns/date formats, removing duplicates, and flagging incomplete records.
- Designed a SQL-based pipeline-monitoring table (record counts, success/failure status, error messages, timestamps) feeding a Power BI dashboard for daily pipeline visibility.
- Containerized a Python ETL pipeline with Docker to eliminate environment-dependent inconsistencies across local testing and scheduled deployment.
- Partnered with analysts and business stakeholders to translate reporting requirements into validated, structured datasets.
Software Engineer
LearnEdze Networks Pvt Ltd
04.2021 - 08.2023
- Built a hybrid data platform (Redshift, DynamoDB, S3) to centralize application data for reporting and analytics.
- Designed ETL workflows extracting data from application databases and files, applying validation/transformation rules before loading into relational tables.
- Developed REST API integrations with internal and third-party services, adding authentication, retry handling, and structured logging for reliability.
- Tuned SQL queries and ETL workflows to reduce processing times and speed up data availability for downstream teams.
Education
Bachelor of Science - Electronics And Communications Engineering
CMR Institute of Technology
Bangalore, India05.2021
Skills
- Data Engineering: ETL/ELT Pipeline Design, Recurring File Ingestion (CSV/Excel), Data Cleansing & Standardization, Schema Validation & Enforcement, De-duplication, Incremental Loading, Historical Versioning, Data-Quality Checks, Source-to-Target Reconciliation
- Programming & Querying: Python, SQL, PySpark, PostgreSQL, Spark SQL, Complex Joins, CTEs, Window Functions, Stored Procedures, MERGE/Upsert Logic
- Cloud & Databases: AWS (Glue, Lambda, S3, Athena, Step Functions, API Gateway, CloudWatch, AppFlow, CDK, CloudFormation), Amazon Redshift, Snowflake, PostgreSQL, MySQL, DynamoDB
- Integration & BI: REST APIs, Third-Party Vendor API Integration, JSON Validation, Power BI, Amazon QuickSight, Ad Hoc Analysis
- Dev Tools: Git, GitHub, Docker, CI/CD
Certification
AWS Certified Data Engineer – Associate
Timeline
Data Engineer
PamTen
06.2025 - Current
Data Engineer
HCA
09.2023 - 05.2025
Software Engineer
LearnEdze Networks Pvt Ltd
04.2021 - 08.2023
Bachelor of Science - Electronics And Communications Engineering
CMR Institute of Technology