Monalisa Patra
Data Engineer
Trivandrum
Summary
Skilled in Data Engineering with expertise in Python, PySpark, Azure Tools, AWS Tools and SQL, focusing on building, optimizing, and managing data pipelines for integration and transformation.
Knowledgeable Data Engineer with robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making.
Overview
2
2
Certifications
2
2
years of professional experience
Work History
Project:-Sydney Provider
Client: Elevance Health Inc
10.2025 - Current
- Worked on data engineering and ETL enhancement activities using Scala, AWS, Snowflake, and EMR within enterprise healthcare data platforms.
- Modified and maintained legacy Scala-based ETL scripts to implement new business logic, bug fixes, and data processing enhancements.
- Executed and monitored AWS EMR and AWS Glue jobs for large-scale data processing and pipeline execution.
- Utilized Snowflake for validating data transformations, testing script changes, and performing data verification activities.
- Monitored application execution, analyzed job failures, and reviewed logs using AWS services and cloud monitoring tools.
- Performed data migration activities between MongoDB collections and Snowflake databases based on project and business requirements.
- Worked on data extraction, transformation, and loading (ETL) processes to support data integration and analytics workflows.
- Collaborated with cross-functional teams to troubleshoot production issues, validate data quality, and ensure successful job execution.
- Improved ETL pipeline efficiency by approximately 15% through enhancements to legacy Scala scripts and optimized job execution in AWS EMR.
- Reduced troubleshooting time by 20% by analyzing AWS job logs and resolving execution-related issues efficiently.
- Gained hands-on experience with cloud-based data engineering tools including AWS Glue, EMR, Snowflake, Scala, and MongoDB.
Project- Sydney Findcare
Client: Elevance Health Inc
06.2025 - 08.2025
- Developed and enhanced Oracle RDS procedures from existing SQL Server procedures for ETL workflows, improving data processing efficiency by approximately 15%.
- Implemented staging, truncation, and archival processes for ETL pipelines, helping streamline database operations and improve data management.
- Performed unit testing and validation of ETL procedures to ensure accurate data processing and reduce deployment defects.
- Identified dependencies across RDS tables and integrated them into new workflows, improving workflow consistency and reducing processing issues.
- Created SQL scripts for parity testing and data validation, helping improve data accuracy and reduce manual verification effort by nearly 20%.
- Collaborated with team members on ETL development and database enhancement activities within cloud-based data environments.
- Supported database optimization and ETL maintenance activities, contributing to improved pipeline stability and operational reliability.
- Assisted in troubleshooting ETL and database-related issues, helping reduce issue resolution time and improve deployment efficiency.
EDP Broker & Billing
Client: Elevance Health Inc
10.2024 - 05.2025
- Created and loaded tables in the SIT region as part of new database enhancements in EDP, supporting successful environment setup and testing activities.
- Performed DQ report validations by analyzing data differences between source (EHUB) and target (EDP), improving data accuracy and reducing validation issues by approximately 15%.
- Executed and monitored AWS Glue jobs to automate ETL workflows, contributing to improved pipeline reliability and reducing manual monitoring efforts by 20%.
- Optimized ETL data processing and database operations, helping improve workflow efficiency and execution performance by nearly 15%.
- Collaborated on ETL development and validation activities, ensuring data integrity and stable pipeline execution across PROD and PERF environments.
- Enhanced data quality through data cleaning, transformation, and validation processes, reducing inconsistencies and improving reporting accuracy.
- Automated repetitive operational tasks using Python scripts, reducing manual effort by approximately 25% and improving team productivity.
- Supported defect validation and testing activities in production and performance environments, helping reduce issue resolution time and improve deployment stability.
Education
Bachelor of Technology - Computer Science Engineering
Biju Pattnaik University of Technology
Odisha08-2022
Skills
Programming Languages: PySpark ,SQL,Python ,Scala
Cloud Platform : AWS, Microsoft Azure
AWS Services :AWS Glue, Amazon S3,AWS Lambda, Amazon EC2
Azure Services: Azure Databricks,Azure Data Factory,Azure Synapse analytics, Azure Blob Storage, Azure SQL Database
Data Engineering: ETL Pipelines,Data Warehousing, Data migration, Data Transformation,Data Processing
Database : SQL Server, MySQL, PostgreSQL, Snowflake, MongoDB
Workflow and Orchestration : Apache Airflow, Scheduling, Batch Processing
Big Data Technologies : Apache Spark ,PySpark, Hadoop, Hive
Data Processing & Analysis: NumPy, Pandas
Visualization : Matplotlib
Version Control & Tools: Git,GitHub,Jira,Bitbucket,Servicenow
Concepts : Data Modelling,Performance optimization,SDLC,Agile Methodology
Certification
Microsoft Certified: Azure Data Fundamentals (DP – 900)
Timeline
Project:-Sydney Provider
Client: Elevance Health Inc
10.2025 - Current
Project- Sydney Findcare
Client: Elevance Health Inc
06.2025 - 08.2025
EDP Broker & Billing
Client: Elevance Health Inc
10.2024 - 05.2025
Bachelor of Technology - Computer Science Engineering
Biju Pattnaik University of Technology