Visagan Manoharan

Results-driven Snowflake Data Engineer with 8 years of IT experience and 5+ years of expertise in Snowflake, cloud data warehousing, and ELT pipeline development. Strong experience in building scalable data architectures, developing dbt transformation models, orchestrating workflows using Apache Airflow, and implementing secure data access controls. Proficient in performance tuning, data migration, and implementing automated, analytics-ready data solutions within Healthcare domains.

Snowflake Data Engineer at Access Healthcare (2023-09 – Present)

DOMAIN: Insurance | CLIENT: Devoted

• Worked on Snowflake object creation and management, including databases, schemas, warehouses, tables, views, stages, pipes, roles, and scaling policies.
• Automated data workflows and dependency handling using Apache Airflow, reducing manual effort and improving reliability.
• Developed Snowflake stored procedures, functions, and user-defined table functions (UDTFs) to support complex transformations.
• Implemented Snow-pipe to continuously load data from AWS S3 into Snowflake, enabling near real-time data ingestion.
• Created external tables to query data directly from files in AWS S3 when direct file access was restricted
• Developed and maintained DBT models (staging, intermediate, mart layers) on Snowflake
• Designed and orchestrated end-to-end data pipelines using Apache Airflow to load and transform data in Snowflake
• Automated batch and incremental workflows using Airflow scheduling and task dependencies.

Snowflake Data Engineer at Ilink Digital (2018-07 – 2023-09)

DOMAIN: Insurance | CLIENT: Greenway

• Designed and developed ETL/ELT pipelines using IICS and Snowflake for insurance data processing.
• Built IICS mappings, mapping tasks, taskflows, and parameterized workflows to load data into Snowflake.
• Migrated and transformed insurance data from Oracle and flat file sources into Snowflake cloud data warehouse.
• Created and maintained Snowflake databases, schemas, tables, views, stages, file formats, streams, tasks, stored procedures, and secure views.
• Worked on insurance datasets including claims, members, providers, eligibility, enrollment, policy, billing, and payments.
• Implemented incremental loading, CDC logic, data validation, data reconciliation, and exception handling.
• Optimized Snowflake queries using warehouse sizing, query profile, clustering keys, partition pruning, and SQL tuning.
• Implemented RBAC, secure views, data governance, and access control for sensitive insurance data.

B.com in Computer Application – Hindustan College of Arts and science