Vinoth Kumar J S

Over 8 years of IT experience with 3 years focused on Snowflake cloud data warehouse, AWS S3. Expertise in building data pipelines, creating tasks, streams, views, and procedures in Snowflake, and managing large datasets from various sources. Proficient in advanced SQL, including complex joins and statistical functions, to support ETL processes and data transformation. Strong ability to translate business requirements into technical specifications while ensuring efficient data modeling and continuous data ingestion using SNOWPIPE.

Project detail - 2
Project Name: CapitalOne
Team Size: 6 Members
Tools: Snowflake
Position: Tech lead
RESPONSIBILITIES:
· Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale Snowflake cloud data warehouse
· Bulk loading from external stage (AWS S3)
· Loading data into Snowflake tables from internal stage and external stage using COPY command.
· Used COPY, LIST, PUT and GET commands for validating internal and external stage files.
· Used import and export from internal stage (Snowflake) vs external stage (S3 Bucket).
· Responsible for task distribution among the team.
· Perform troubleshooting analysis and resolution of critical issues.
· Involved in data analysis and handling ad-hoc requests by interacting with business analysts, clients and resolve the issues as part of production support.
· Used performance technics like clustering key, autoscaling for faster way of loading, increase query execution.
· Performed data validations for source and target using load history and copy history.
· Developed snowflake queries using various joins like self, left and full outer joins.
· Created views and materialized views and snowflake procedures.
PROJECT DETAIL – 2
Project Name: Medidata
Team Size: 16 Members
Platform: MS SQL Server, SSIS
Contribution: ETL Developer
RESPONSIBILITIES:
· Involved in requirement gathering for the development of SSIS package.
· Designing and creating SSIS packages to meet the requirements.
· Created Store procedures, Functions and Views to support various needs from SSIS.
· Configured and deployed the project in the Production server.
· Involved Database admin activities including regular backup, restore, database optimization, etc.
· Scheduled Jobs in the Production server.
· KT sessions to team members for database.
· Load monitoring and investigate failures for ETL Jobs.