VIGNESH PRADHAPAN
Chennai
Summary
Accomplished Snowflake Developer with extensive experience in designing and managing Snowflake objects, developing and optimising ETL/ELT pipelines, and implementing CDC and near real-time processing. Proven track record in leading large-scale Oracle-to-Snowflake migrations, building end-to-end data integration solutions, and enhancing database performance through SQL tuning and best practices. Adept at using tools such as dbt, Informatica IICS, Jenkins, GitHub, Jira, and Redmine to support scalable data models and workflows. Career goal: to leverage expertise in Snowflake SQL and AWS S3 to drive innovative data solutions within a forward-thinking organisation.
Overview
5
5
years of professional experience
Work History
Snowflake Developer
Rapid Data Technologies
Chennai
10.2024 - Current
- Designed and managed Snowflake objects (tables, views, stages, streams, pipes, UDFs, procedures) and built scalable, high-performance data models for analytics.
- Developed and optimized ETL/ELT pipelines from Oracle, AWS S3, and other sources into Snowflake, improving performance, cost efficiency, and data consistency.
- Automated incremental loads, backups, and workflows using Snowflake task trees and DML-triggered processes, increasing reliability and operational efficiency.
- Implemented CDC and near real-time processing with Snowflake Streams, enabling low-latency data consumption and auditing.
- Improved query and warehouse performance through clustering, workload isolation, query tuning, and reusable metadata-driven transformations (dynamic SQL, UDFs, table functions), while leveraging Time Travel and Fail-safe for recovery and compliance.
Snowflake Developer
TCS (Teamware Solutions)
Chennai
06.2022 - 06.2024
- Led large-scale Oracle-to-Snowflake migrations using flat files as part of application modernization and cloud initiatives, executing structured data loads via STAGE objects and COPY INTO with strong accuracy and fault tolerance.
- Designed and implemented Snowpipe to enable continuous, near–real-time ingestion from AWS S3 and Oracle sources, supporting reliable and automated data integration.
- Processed structured and semi-structured data using Snowflake VARIANT, FLATTEN, and file-based ingestion patterns to support flexible transformation and loading strategies.
- Built end-to-end ETL/ELT pipelines using Snowflake native features and third-party tools, including scalable SQL-based transformations with dbt for modular, testable, and well-documented workflows.
- Implemented SCD Type 2 logic using MERGE, Streams, Tasks, and Time Travel to enable historical tracking, auditability, and robust dimensional data modeling.
Snowflake Developer
AMIDC Automation Technologies
Bangalore
11.2020 - 04.2022
- Designed and developed reusable Oracle PL/SQL components (packages, procedures, collections) to implement scalable business logic and high-performance data validation, transformation, and migration across large datasets.
- Translated business requirements into optimized SQL and PL/SQL solutions using complex joins and analytical functions, ensuring accuracy and efficiency.
- Improved database performance through SQL tuning, indexing, partitioning, and execution plan analysis to enhance query speed and system scalability.
- Enforced database standards, documentation, and best practices while providing production support and collaborating cross-functionally to resolve issues, maintain compliance, and support audits.
Education
B.Sc. - Computer Science
Sir Theagaraya Arts & Science College
01.2017
Skills
- Snowflake SQL
- AWS S3
- ETL/ELT Concepts
- Oracle SQL
- PL/SQL
Custom Section
Data Engineer
Disclaimer
I hereby declare that the information provided above is true to the best of my knowledge.
Tools
- DBT
- Informatica IICS
- SQL Developer
- Jenkins
- GitHub
- Jira
- Redmine
Timeline
Snowflake Developer
Rapid Data Technologies
10.2024 - Current
Snowflake Developer
TCS (Teamware Solutions)
06.2022 - 06.2024
Snowflake Developer
AMIDC Automation Technologies
11.2020 - 04.2022
B.Sc. - Computer Science
Sir Theagaraya Arts & Science College