Snowflake Developer
Location : Jaipur, India
Experience : 12 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Srinivasula – 12 Years - Snowflake Developer
Experience Summary:
Having 12 years of IT experience on end-to-end Data warehousing using ETL tools and reporting tools.
4+ years of experience on Snowflake Cloud Data Warehouse.
Very good knowledge on Data warehousing concepts and using ETL tools.
Hands on experience in writing SQL queries.
Good knowledge on agile implementation and sprinting.
In depth knowledge on Snowflake on AWS cloud.
Good Knowledge on Data Vault modeling.
Experienced in using ETL tools to load and extract data from Snowflake.
Experienced in handling structured and semi-structured (JSON) data in Snowflake.
Good understanding on Snowflake pricing and performance optimization.
Good understanding of snowflake Micro Partitioning and Clustering.
In depth knowledge on building Tasks and Streams for CDC.
Good knowledge on Snowflake clones and time travel.
Good knowledge on Data sharing and Dynamic data masking in Snowflake.
Experienced in creating views and materialized views.
Very good knowledge on Role based access control in Snowflake.
Experienced in configuring Bulk loading using external stage and internal stages.
Experienced in configuring Continuous loading using Snowpipes.
Good knowledge on version controlling tools like Github.
Good knowledge on DBT Cloud.
Implemented SCD2 Type changes in dbt.
Experience designing and developing data pipelines in dbt.
Good knowledge in developing models using dbt.
Good knowledge in Code deployment and Production support activities.
Good Analytical and Communication Skills and Problem-Solving Skills.
Willingness to learn new concepts and implement them.
Technical skills:
Cloud Snowflake, AWS,DBT,HCM
ETL Tool AWS Glue, Informatica, Alteryx
Reporting Tool Tableau, Power BI, Quick Sight, SAP BO,OTBI,BIP
Languages Python, SQL,PL/SQL,YML
Databases Oracle, Aurora, Snowflake
Schedular Tools ESP, Control-M, Autosys
Version Controlling Github, BitBucket
Operating systems Linux, Windows
Project Details:
Project #1:
Project: Compensation Management
Period: From May 2022 – May 2023
Role: Snowflake Developer
Responsibilities:
Analyzed the existing process and prepared high level design documents.
Worked closely with the source teams to ensure the source data is properly migrated.
Created external stages to load the data from AWS S3 buckets to snowflake.
Created tasks and streams to implement change data captures.
Handled structured and semi structured data loads to snowflake.
Used snow pipes to do continuous data ingestion from AWS.
Used time travel, data sharing and data cloning features when required.
Looking into all possible cost optimization options in snowflake.
Implemented SCD2 Type changes in dbt.
Experience designing and developing data pipelines in dbt.
Good knowledge in developing models using dbt.
Created reader accounts for data sharing to the report end users.
Created views and materialized views based on requirements.
Performed data validations through information schema.
Attended regular meetings with end users to understand requirements.
Attending daily scrum meetings to discuss on work progress.
Project #2:
Project: Snowflake ICM
Period: From Jul 20019 – Apr 2022
Role: Snowflake Developer
Project Overview: Truecomp ICM (Integrated Cloud Migration) is a data migration project which aims at
providing the cloud solutions for migrating the entire data warehouse related to payroll and compensation
from the existing on premises warehouse built on Oracle to leverage the benefits of Snowflake cloud
warehouse and Amazon web services.
Responsibilities:
Analyzed the existing process and prepared high level design documents.
Worked closely with the source teams to ensure the source data is properly migrated.
Created external stages to load the data from AWS S3 buckets to snowflake.
Created tasks and streams to implement change data captures.
Handled structured and semi structured data loads to snowflake.
Used snow pipes to do continuous data ingestion from AWS.
Used time travel, data sharing and data cloning features when required.
Looking into all possible cost optimization options in snowflake.
Created reader accounts for data sharing to the report end users.
Created views and materialized views based on requirements.
Performed data validations through information schema.
Attended regular meet
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
