Chanda – 6+ Years – Snowflake Developer

CAREER ABSTRACT
A dynamic professional with 6+ years of IT experience in heading teams for driving Data warehousing applications in Design, Development and maintenance. Implemented solutions using snowflake.

Good experience in design data pipeline solutions using Azure, Snowflake.
Having 3+ years of Professional Experience in working with Snowflake cloud data warehouse, azure blob and AWS S3.
Experience with Snowflake Multi-Cluster Warehouses and Migrating Oracle objects into

Snowflake environment.
Experience with Snowflake Virtual Warehouses, building Snow pipe and Extensive experience on Data Sharing.
In-depth knowledge on Snowflake Database, Schema and Table structures.
Experience in using Snowflake Clone and Time Travel and Worked with Streams & Tasks.

Strong understanding of the principles of Data Warehousing using fact tables and dimension
tables.
Knowledge in Data Loading (Full, Initial, Delta Upload), Scheduling and Monitoring.

Directly responsible for Extraction, Cleansing, Transformation and Loading of data from
multiple feeds and sources into Data Warehouse.
Extensive experience in all the Data warehouse/data mart testing phases – Unit testing,
Integration testing, System Testing, UAT, Stress testing, break-the-box testing and creating
corresponding documents – Unit test plans, test cases, test scripts and test schedules.
Excellent knowledge and experience in configuring connections to various sources and creating
source to target mapping, edit rules and validation, transformations, and business rules and
ensures adherence to locally defined standards for all developed components
In-depth knowledge on Snowflake performance activities and loading of structured and Semi-
structured files into snowflake.
Experience in working on Snowflake SQL all DDL, DML commands, Joins and aggregate &
analytical functions.
Experience in working different areas of RDBMS, Data loading through Sql loader.
Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical
functions to support ETL in snowflake cloud data warehouse.
Handling large and complex data setskills JSON, ORC, PARQUET CSV files from various sources
like AWS S3.
Hands-on experience in bulk loading and unloading data into Snowflake tables using COPY
command.
Proficient in SQL Performance tuning. Worked on databases like Oracle.


Good experience in ETL informatica mappings, sessions, workflows.
Knowledge on Power BI.
Involved in performance tuning for the complex SQL by following various handling process like
collecting stats, by creating temporary tables, Indexes
Created Views as per the Business recommendations with all the filters to help
downstream applications to capture data and generate reports.
Have Experience in Onsite Client Interaction, having good understanding of onsite and offshore
model.
Experience in leading and managing teams. Handled multiple roles – Tech Lead and Developer.
Good Analytical, Strong interpersonal and excellent communication and managerial skills.
Extensive experience with analysis, design, development, customizations, and implementation
of software applications.

Professional Experience

Working since July 2016 to till date

Educational Details

B.Sc. - 2010

Databases : SNOWFLAKE, SNOWFLAKE ADMIN Oracle.
ETL Tools : Informatica
OS : Ms Windows 2011, Window 2010, and Windows NT 4.0, UNIX


CAREER CONTOUR

Project #1
Project Title : Humana - Insurance
Client : Humana
Environment : Snowflake, Snowflake Admin, azure Blob, Oracle
database Role : Snowflake Developer.
Duration : From Apr 2022 to till date

Responsibilities:

 Involved in Requirement Analysis & preparation of Functional Design documents.
 Table DDLs creation in snowflake development database.
 Have used COPY statements to ingest data from stage to Tables.
 Implemented snow pipe for real-time data ingestion.
 Cloned Production data for code modifications and testing.
 Work with multiple data sources.
 Created data sharing out of snowflake with testing team.
 Worked with streams for change data capture and implemented SCD.
 Implemented solutions using snowflake’s data sharing, cloning and time travel.
 Involved in unit testing and Integration Testing.
 Establish and ensure adoption of best practices and development standards.
 Co