Srinivas Ch

Project Lead

Talent

BengaluruMember since 21 May 2026

SnowflakeETLSnowpipeSnowsightSnowSQLStreams & TasksTime TravelZero-Copy CloningSecure Data SharingExternal TablesViews & Materialized ViewsPerformance TuningQuery OptimizationAWS S3RedshiftGoogle Cloud PlatformAWSDataStage11.3WebSphere11.3TalendMatillionOracle 9iTeradata12DB2TOADTableauControl-MGitHubBitbucketWindows

Hire this person

Send a job offer directly to this candidate

SnowflakeETLSnowpipeSnowsightSnowSQL

About

Having 13+ years of experience in IT industry with strong expertise in Data Warehousing and Cloud Data Platforms. 7+ years in Data Warehousing: Skilled in ETL design, performance optimization, and large‑scale data integration and migration. 6+ years in Snowflake: Advanced proficiency in architecture, query tuning, secure data sharing, and cloud deployment.

Experience with Snowflake Data warehouse, deep understanding of Snowflake architecture and processing. Proficient in understanding business processes/requirements as per user stories and translating into technical requirements. Proven track record in leading end-to-end ETL/ELT lifecycles, migrating complex legacy systems to the cloud, and optimizing high-performance data environments.

Experienced with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading data into snowflake tables. Used COPY/INSERT, PUT, GET commands for loading data into Snowflake tables from internal and external stages. Advanced SQL expertise in writing complex scripts using aggregate and analytical functions to support ETL processes in Snowflake.

Proficient in complex joins, stored procedures, views, materialized views, and cloning techniques. Knowledge on Snowflake functions Time travel, Data Sharing, Data Cloning, Secure views and multi-cluster. Hands-on experience with Snowflake utilities like SnowSQL, SnowPipe, tasks and streams.

Good exposure in Snowflake Cloud Architecture and SNOWPIPE for continuous data ingestion. Expertise in Snowflake advanced concepts like setting up resource monitors, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, tasks.

Experience in integrating DBT and snowflake. Created the SQL models in DBT for data movement in snowflake. Proven track record of leading teams, conducting design reviews, and coordinating offshore projects to deliver scalable, high‑impact solutions.

Strong background in SQL, Python, and cloud services (AWS, Azure, GCP), with a focus on maximizing efficiency and business value through modern data platforms. Proficient in delivering high-quality solutions across the full SDLC, with extensive experience in both Agile/Scrum and Waterfall methodologies. Ability to work independently and as a team with a sense of responsibility, dedication, commitment and with an urge to learn new technologies.

Excellent

Client interaction skills and proven experience in working independently as well as in a team.

Experience

Project Lead - Capgemini

(2011-03)

Project Lead - Aetna Insurance, US - US

(2023-02)

Worked on the Insurance Data Modernization project aimed at migrating on-premises insurance policy and claims data into the Snowflake Cloud Data Warehouse for advanced analytics and regulatory reporting. The system serves as a centralized repository for policy, claims, customer, and agent data, integrating information from multiple legacy systems and third-party sources. The Snowflake platform enabled faster data access, real-time insights, and seamless data sharing with downstream actuarial, underwriting, and compliance systems.

Designed, developed, and maintained Snowflake data warehouse objects including databases, schemas, tables, views, materialized views, and role-based security.
Built end-to-end ETL/ELT pipelines using Snowflake, Snowpipe, Streams, Tasks for insurance policy and claims data.
Developed and optimized SQL scripts and User Defined Functions (UDFs) for complex business rules and data transformations.
Implemented Slowly Changing Dimensions (SCD Type 1 & Type 2) to manage historical insurance policy and customer data accurately.
Worked with external stages (AWS S3 and Azure Blob Storage) and created external tables and Iceberg tables to load and process structured and semi-structured files (CSV, JSON).
Performed query optimization and performance tuning for large-scale Snowflake tables, warehouses, and materialized views to improve reporting and analytics efficiency.
Leveraged Time Travel and Zero-Copy Cloning for data recovery, testing, and environment replication.
Collaborated with Agile teams, tracked tasks and Jira stories, and participated in sprint planning, stand-ups, and retrospectives.
Coordinated with business analysts, QA, and downstream teams to ensure data quality, integrity, and completeness across insurance data marts and reporting systems.
Designed and developed a highly scalable Snowflake data warehouse to consolidate enterprise data from multiple regions and business domains.
Built data ingestion frameworks using Snowpipe and AWS S3 for near real-time data loading from transactional systems, APIs, and third-party feeds.
Created partitioned and clustered tables to optimize performance and reduce query costs.
Implemented materialized views and result set caching to accelerate BI dashboards.
Developed Streams & Tasks for CDC (Change Data Capture) pipelines, ensuring near real-time synchronization across systems.
Configured multi-cluster virtual warehouses to support concurrent workloads without performance degradation.
Leveraged Time Travel & Zero-Copy Cloning for disaster recovery, audit, and Dev/Test environments.
Designed and implemented data ingestion using Snowpipe, Streams, and Tasks for near real-time data processing.
Worked on COPY/INSERT, PUT and GET commands for loading data into snowflake tables from internal/external stages.
Designed and implemented Snowflake Data Warehouse architecture including databases, schemas, warehouses, roles, and RBAC policies.
Developed and maintained data ingestion pipelines using Snowpipe, Streams, and Tasks for real-time and batch processing.
Created external stages in AWS S3 and Azure Blob Storage and developed external tables and Iceberg tables for data ingestion and analysis.
Developed Stored Procedures, User Defined Functions (UDFs), and SQL scripts for complex business logic and reusable transformations.

Project Lead - Genworth, US - US

(2020-08 - 2023-01)

IWH is a data migration project for database migration using Snowflake. Proposed project is to migrate the on-premise database Oracle, SQL-Server to Snowflake and improve the throughput of the data processing. As a part of data migration more than five hundred tables are migrated to AWS cloud. Once data is available in Snowflake, downstream visualize it using Tableau as a reporting tool.

Understand the business requirement and architecture that represents for data lineage.
Experience with snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system.
Experience in building SnowPipe.
Worked on AWS data pipeline to configure data loads from S3 data.
In-depth knowledge of Data Sharing in Snowflake.
Exposure on using Snowflake Database, Schema and Table structures.
Experience in using Snowflake Clone and Time Travel.
Writing advanced SQL scripts as per the business plan to transform the data.
Used Time Travel and Fail Safe for data recovery.
Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, snowflake stream to implement SCD.
Performing Unit testing, Integration testing.

Project Lead - Auto Club Group

(2018-08 - 2020-07)

RPA is an ODS for AKU, FF, Property, Casualty and Legacy Casualty Insurance data of various places across the Japan. Data is generated from various sources systems as files in CSV, Pipe delimited format. Data is placed in AWS S3 bucket and it is consumed using snowflake and populated into ODS. Once ODS is loaded, downstream systems consume the data and published.