About
Snowflake Data Engineer with 5 years of experience in the healthcare domain, building and maintaining cloud data pipelines and warehouse solutions on Snowflake. Experienced in SQL, Python, dbt, Airflow and AWS S3, delivering analytics-ready data for reporting and production support.
Experience
-
Snowflake Data EngineerFirst Source Solutions Ltd · ChennaiJun 2024 – Jul 2026
Client: Cigna. Designed and maintained Snowflake ELT pipelines to ingest healthcare data from AWS S3 using external stages and Snowpipe. Implemented incremental and CDC-based processing using Streams and Tasks, developed dbt transformations, orchestrated workflows in Airflow, tuned queries and warehouse sizing, built validation checks, supported Power BI datasets, applied RBAC, used Time Travel and Zero-Copy Cloning, wrote Python scripts, and supported production incidents and root-cause analysis.
-
Data Engineer / Snowflake DeveloperWNS Global Solutions · ChennaiJun 2021 – Jun 2024
Client: Humana. Developed SQL queries, views, stored procedures and Snowflake objects for healthcare claims and member data processing. Built loading and transformation workflows from AWS S3 into Snowflake, created and maintained data models, automated recurring processes with Python and Snowflake Tasks, performed validation and reconciliation, used Time Travel and Zero-Copy Cloning, collaborated in Agile sprints, optimized queries, and maintained documentation and runbooks.
Education
-
2021
Bachelor of ArtsAlhikma academy2019 – 2021
- 2019
Skills
Tools / apps / platforms
Languages
Projects
-
Claims and Member Data WarehouseSnowflake, SQL, Python, AWS S3, Stored Procedures, Tasks
Developed Snowflake tables, views and stored procedures to process healthcare claims and member data from multiple source systems. Designed fact and dimension models supporting analytics and operational reporting. Automated recurring loads and validations, reducing manual effort and improving turnaround of daily data refreshes.
-
Healthcare Data Platform on SnowflakeSnowflake, AWS S3, Snowpipe, Streams, Tasks, dbt, Airflow, SQL, Python, Power BI
Built an end-to-end pipeline that lands source files in S3, auto-ingests them with Snowpipe and transforms them with dbt into reporting-ready marts. Implemented Streams and Tasks for incremental processing, and Airflow DAGs for scheduling, dependency management and alerting. Added data quality checks and reconciliation steps to improve trust in downstream Power BI reports.