MOURYA S
Hyderabad
Summary
Accomplished Data Engineering Lead with 8+ years of experience delivering scalable cloud data platforms, enterprise data warehouses, and high-performance ETL/ELT solutions. Demonstrated success in building reusable frameworks, automating ingestion lifecycles, and elevating data quality using Snowflake, Matillion, Python, and AWS. Strong track record of modernizing data ecosystems, leading cloud migration initiatives, and designing robust architectures that support analytics and AI workloads. Recognized for partnering effectively with product teams and stakeholders to translate complex requirements into reliable, scalable engineering solutions.
Overview
9
9
years of professional experience
1
1
Certification
Work History
TECHNICAL LEAD – DATA ENGINEERING
Philip Morris International
10.2022 - Current
- Led DI&A initiatives at PMI, delivering multiple AI and Big Data solutions, and modernizing the enterprise data ecosystem used across 20+ global markets.
- Assessed PMI’s DEEP CI/CD platform, identified architectural and process gaps, and delivered an improvement roadmap that increased deployment efficiency by 30% across data engineering teams.
- Designed and implemented enterprise-grade Matillion frameworks—File Validation, ABC (Audit/Balance/Control), and Data Tagging—improving data quality, lineage, and governance, reducing ingestion defects by 40%.
- Built a Test Data Generation Framework in Matillion & Snowflake, enabling synthetic data and production-like masked data provisioning, accelerating QA and lower-environment readiness by 50%.
- Architected and delivered a fully automated CI/CD Data Ingestion Framework using Jenkins, Jira, Matillion, and Snowflake, reducing manual deployment effort by 70% and increasing release reliability.
- Engineered advanced Snowflake solutions—Snowpipes, CDC pipelines, UDFs, micro-partitioning, semi-structured handling—achieving 35–60% improvements in performance across critical workloads.
- Developed scalable ETL pipelines using Matillion, Python, SQL, and PySpark, supporting TB-scale data volumes and reducing transformation runtimes by up to 45%.
- Provided technical leadership through design reviews, mentoring, and stakeholder alignment, improving delivery predictability by 25% and ensuring consistent quality across Agile teams.
SENIOR SOFTWARE ENGINEER – DATA ENGINEERING
Anthem Blue Cross Blue Shield
10.2019 - 10.2022
- Led the migration of the EPDS system from legacy SSIS pipelines to a modern AWS–Snowflake architecture, reducing processing time by 40% and improving system reliability.
- Built and optimized ETL/ELT pipelines using Snowflake, AWS services, Informatica, and SQL, supporting 50+ enterprise data flows across analytics, operations, and reporting.
- Engineered Snowflake ingestion pipelines with Snowpipe, SnowSQL, and S3 integration, improving data freshness SLAs from daily loads to near real-time availability.
- Implemented Snowflake performance enhancements—zero-copy cloning, micro-partition tuning, stored procedures—resulting in 30–50% faster query performance on critical workloads.
- Developed and automated ETL frameworks in AWS (Redshift, Glue, Lambda, Step Functions), achieving 95% automation of orchestration and drastically reducing manual intervention.
- Designed Informatica PowerCenter workflows and optimized SQL queries, reducing ETL runtime and query latency by up to 70%, while delivering actionable insights via Power BI dashboards.
ASSOCIATE CONSULTANT – DATA ENGINEER
Baker Hughes, a GE company
06.2017 - 10.2022
- Performed detailed requirement analysis and successfully migrated legacy ETL processes into optimized, scalable data models, improving system performance and maintainability.
- Designed and developed PL/SQL procedures, functions, and views, and optimized complex SQL pipelines, reducing query runtimes by up to 40%.
- Collaborated closely with business and technical stakeholders to deliver robust, scalable data solutions aligned with evolving analytical and operational needs.
- Enhanced data workflows through performance tuning and process improvements, improving overall pipeline efficiency and reliability.Performed requirement analysis and migrated legacy ETL into optimized data models.
- Built PL/SQL procedures, views, and tuned SQL pipelines.
- Collaborated with business and technical owners to implement scalable solutions.
Education
Bachelor of Technology - CSE
National Institute of Technology Uttarakhand
01.2017
Skills
Data Engineering & ETL
- ETL / ELT Development
- Big Data
- Data Warehousing
- Snowflake
- Databricks
- Matillion
- Python
- PySpark
- Data & Dimension Modeling
- Lakehouse architecture
- Informatica PowerCenter
- SSIS (SQL Server Integration Services)
- Oracle
- SQL, PL/SQL
- Solution Architecture
- Cloud Migration
- Data modeling
Cloud Platforms
- AWS: S3, Glue, Lambda, Step Functions, Redshift,EC2
- Azure: Azure Data Factory (ADF), Synapse
DevOps, CI/CD & Automation
- CI/CD Pipelines
- Git
- Jenkins
- Terraform
- Docker
Business Intelligence & Analytics
- Power BI
- Analytics Dashboards
Professional & Leadership Skills
- Stakeholder Management
- Agile Delivery
- Problem Solving
- Leadership
- Client relationship management
Websites
Certification
- SnowPro Core Certified
- Azure Data Engineer Associate
- Microsoft Azure Fundamentals
- Databricks Lakehouse Fundamentals
- Snowflake Hands-On Essentials
Awards
- Award of Excellence – Coforge
- Rising Star Award – Capgemini
- Project Star Award – Legato
- Multiple Impact Awards – Legato
Timeline
TECHNICAL LEAD – DATA ENGINEERING
Philip Morris International
10.2022 - Current
SENIOR SOFTWARE ENGINEER – DATA ENGINEERING
Anthem Blue Cross Blue Shield
10.2019 - 10.2022
ASSOCIATE CONSULTANT – DATA ENGINEER
Baker Hughes, a GE company
06.2017 - 10.2022
Bachelor of Technology - CSE
National Institute of Technology Uttarakhand