Data Engineer - Cloud ETL, Snowflake, Airflow Expert

Srikanth Ilaveni Data Engineer

TX, USA +1-210-***-**** **************@*****.*** LinkedIn

SUMMARY

Data Engineer with 5+ years of experience developing cloud-based ETL pipelines and dimensional data models across insurance and healthcare domains. Strong expertise in Python, SQL, PySpark, Airflow, AWS, and Snowflake. Delivered measurable improvements in data latency, reporting accuracy, warehouse performance, and compliance readiness. Experienced in HIPAA-aligned processing, data quality validation, production monitoring, and supporting underwriting, actuarial, and clinical analytics initiatives. TECHNICAL SKILLS

Programming & Querying: Python, SQL (CTEs, Window Functions, Query Optimization), PySpark, Pandas Data Engineering & Architecture: ETL / ELT Development, Data Modeling (Star Schema, Fact & Dimension Design), Change Data Capture (CDC), Data Quality Validation, Data Reconciliation, Batch Processing Cloud & Data Platforms: AWS (S3, EMR, IAM), Snowflake, SQL Server Orchestration & Workflow Management: Apache Airflow, Workflow Scheduling, Dependency Management DevOps & Version Control: Git, CI/CD Pipelines, Production Deployment Performance Optimization: Query Tuning, Warehouse Scaling, Clustering Strategies, Partitioning Compliance & Governance: HIPAA, PHI Masking, Role-Based Access Control (RBAC), Encryption at Rest Reporting & Analytics: Power BI, Data Visualization PROFESSIONAL EXPERIENCE

Data Engineer Arbella Insurance Group

Jan 2025 - Current USA

Built Python and SQL-based ETL pipelines processing 40M+ insurance policy and claims records monthly, reducing reporting turnaround time by 55% and enabling faster underwriting analysis.

Designed dimensional data models supporting loss forecasting and regulatory reporting, reducing manual reconciliation effort by 38% and improving metric consistency across finance and risk teams.

Improved Snowflake performance by 60% through warehouse tuning, query optimization, and workload balancing, lowering compute costs while enhancing dashboard responsiveness.

Implemented automated data validation and reconciliation checks across ingestion and transformation layers, decreasing reporting discrepancies by 42% and strengthening data integrity controls.

Deployed version-controlled data workflows using Git and CI/CD pipelines, reducing release defects and improving stability across development and production environments.

Prepared analytics-ready datasets supporting risk scoring models, shortening model preparation time and improving pricing analysis accuracy.

Diagnosed and resolved pipeline failures using log analysis and monitoring tools, maintaining SLA compliance for business-critical reporting systems.

Associate Data Engineer HCL Tech

Oct 2021 - Dec 2023 India

Migrated 25+ SQL Server reporting pipelines to AWS S3 and Snowflake, reducing infrastructure maintenance costs by 33% and improving scalability for healthcare analytics workloads.

Developed PySpark transformations on EMR processing 30M+ electronic health records and claims datasets, improving structured data availability for compliance and research reporting.

Built Airflow DAGs to manage ingestion workflows and dependencies, reducing recurring job failures by 28% and improving data delivery reliability.

Implemented change data capture processes reducing full dataset reload time by 47% while preserving historical accuracy required for audit compliance.

Applied encryption, PHI masking, and role-based access controls to ensure HIPAA-compliant handling of sensitive healthcare data.

Optimized transformation logic and storage configurations to reduce batch processing delays and improve reporting timeliness. Data Analyst / Junior Data Engineer HCL Tech

Sep 2019 - Jun 2021

Analyzed 20M+ healthcare records using advanced SQL queries, reducing manual reporting cycles by 40% and improving operational insight accuracy.

Developed Python transformation scripts to standardize inconsistent source data, decreasing reporting discrepancies by 32%.

Assisted in building ETL workflows ingesting EHR data into centralized reporting systems, reducing load failures by 25% and improving refresh reliability.

Created Power BI dashboards tracking patient throughput and quality metrics, replacing spreadsheet-based reporting and improving leadership visibility.

Conducted root cause analysis on recurring data inconsistencies, strengthening governance practices and improving confidence in compliance reporting outputs.

EDUCATION

MS in Information Technology & Management Webster University, MO, USA Jan 2024 - Dec 2025 Bachelor of Commerce in Computer Applications Osmania University, Hyderabad, India Jun 2015 - Mar 2018 MBA Finance Osmania University, Hyderabad, India Jun 2018 - Oct 2020

Contact this candidate