Summary
Overview
Work History
Education
Skills
Personal Information
Education and Training
Tools
Timeline
Generic

Ponmuhil Nallaiyan

Thanjavur

Summary

  • Over three years of experience in data warehousing, cloud data engineering, and PL/SQL development.
  • Skilled in Snowflake Data Cloud, including loading, transforming, and managing structured and semi-structured data from AWS S3.
  • Designed and implemented efficient data pipelines using Snowflake’s native capabilities, like Streams, Tasks, and Time Travel, for incremental and historical data management.
  • Hands-on experience with ETL tools like Informatica for orchestrating data flows into Snowflake from diverse sources.
  • Optimized query performance using clustering keys, result caching, materialized views, and Query Profile analysis to reduce credit consumption, and latency.
  • Strong understanding of data governance, including data masking, role-based access control (RBAC), and metadata management.
  • Participated in iterative development cycles, enhancing data workflows and processes while adhering to Agile methodologies.

Overview

3
3
years of professional experience

Work History

SNOWFLAKE DEVELOPER

Accenture Solutions Limited
Chennai
09.2024 - 05.2025
  • Developed scalable data ingestion pipelines to load terabytes of structured and semi-structured data (JSON/CSV) from AWS S3 into Snowflake, using automated jobs.
  • Built and managed internal and external stages, file formats, and used metadata functions for auditing.
  • Implemented data masking policies for PII data to ensure GDPR and HIPAA compliance.
  • Created dynamic stored procedures and user-defined functions (UDFs) to handle complex business logic in transformation layers.
  • Used zero-copy cloning to create test environments and enable parallel development.
  • Performed SCD Type 1 and 2 implementation using Streams, Merge statements, and history tables.
  • Integrated Informatica PowerCenter to orchestrate multi-layered ETL processes, feeding Snowflake tables.
  • Worked with Query Profile and Warehouse monitoring to tune performance and reduce credit consumption.
  • Enabled time travel and fail-safe features to restore and analyze historical data snapshots.
  • Documented the entire pipeline architecture using Confluence, and presented technical designs to stakeholders.

Data Analyst

Tata capital limited
Chennai
06.2022 - 08.2024
  • Migrated on-premises financial data to the Snowflake Cloud Data Platform, reducing data latency by 60%.
  • Designed and implemented multi-stage ETL pipelines to extract raw credit card and loan data from AWS S3, using external stage, and COPY INTO commands.
  • Created transient and temporary tables for staging and intermediate transformations.
  • Built star schema models with fact and dimension tables for risk analysis dashboards.
  • Developed SQL-based data quality validations to monitor anomalies and null values across 50+ attributes.
  • Leveraged Snowflake Streams and Tasks to implement incremental data loads (CDC).
  • I wrote stored procedures with error handling for automated data transformation routines.
  • Tuned queries using clustering keys and result caching, improving dashboard load time by 40%.

Education

Bachelor of Engineering - Civil Engineering

University College of Engineering Tindivanam
04-2020

Skills

  • Snowflake DB
  • AWS S3
  • ETL concept
  • Oracle SQL
  • pl/sql
  • Data structures

Personal Information

Education and Training

other

Tools

  • Jenkins
  • IICS
  • Sql developer
  • JIRA
  • GitHub Desktop

Timeline

SNOWFLAKE DEVELOPER

Accenture Solutions Limited
09.2024 - 05.2025

Data Analyst

Tata capital limited
06.2022 - 08.2024

Bachelor of Engineering - Civil Engineering

University College of Engineering Tindivanam

Similar Profiles

CREATE PROFILE
Ponmuhil Nallaiyan