y
yerra_avinash

Yerra A

@yerra_avinash

Business Technology Solutions Associate Consultant

India
English, Hindi, Telugu
About me
I am a Business Technology Solutions Associate Consultant with extensive experience in data engineering and architecting enterprise-scale platforms. I specialize in building Airflow-orchestrated ELT pipelines, Snowflake data modeling, and optimizing cloud infrastructure using AWS and Azure. I have a proven track record of delivering high-performance data solutions and reducing operational costs.... Read more

Skills

y
yerra_avinash
Yerra A
Offline • 
Average response time: 1 hour

See my services

Consultation
I will build python etl, data cleaning and data transformation pipelines
From$20 / projectMore details

Portfolio

Work experience

ZS

ZS

Full-time • 2 yrs 7 mos

Senior Data Engineer

Jun 2026 - Present • 2 mos

Leading the development of an enterprise-scale Payer Master Data Platform on Snowflake, integrating 6 commercial data sources into a unified customer spine processing ~25M records. Architecting Airflow-orchestrated ELT pipelines using Python, SQL, AWS S3, and Snowflake to automate ingestion, incremental processing, and workflow orchestration. Designed Customer Master, Crosswalk, and Hierarchy models to standardize customer identities across 6 commercial data sources. Developed reusable Snowflake Stored Procedures for data ingestion, validation, transformation, and execution logging. Building the customer mastering foundation supporting enterprise Data Hub initiatives and downstream applications including Contract Decision Support and Biosimilar Opportunity Modeling.

Data Engineer

Jun 2024 - Jun 2026 • 2 yrs

● Developed an enterprise healthcare data platform by building and maintaining 20+ Airflow-orchestrated Python ETL pipelines that ingested 100+ datasets from AWS S3 into Snowflake, sustaining 90% SLA compliance and delivering data for downstream analytics. Built a centralized commercial data mart by integrating 7+ fact tables using dimensional data modeling, creating curated analytical datasets that powered 3 business dashboards and 2 enterprise data products, while reducing data retrieval time by 35%. Optimized Snowpark transformation workflows processing ~2TB of data daily through SQL execution tuning and Snowflake warehouse optimization, improving batch execution performance by 50% while reducing Snowflake compute costs by 65%. Developed a reusable data quality framework with grain, duplicate, null, and integrity validations across 20+ production pipelines, reducing reporting defects by 95%+ and improving the reliability of business-critical datasets. Improved platform reliability and operational efficiency by implementing SLA monitoring, automated failure recovery, Git-based CI/CD deployment practices, and operational alerting across 20+ Apache Airflow workflows, reducing operational failures by 30%.

Data Engineer Intern

Jan 2024 - Jun 2024 • 5 mos

Developed a commercial healthcare data platform by building and orchestrating 3 Python ETL pipelines in Apache Airflow, ingesting 10M+ records monthly into Snowflake and reducing end-to-end processing time by 40%. Automated data ingestion and transformation workflows using Python, SQL, AWS S3, and Snowflake, reducing manual operational effort by 80% while improving data availability for downstream analytics. Designed two Snowflake data marts across 5 dimensional and fact tables, creating curated analytical datasets that powered 4 client-facing reporting modules.