I will do snowflake database development

"Please Contact Me Before Placing An Order"

I am one of the Professional Programmer of MySQL database and Snowflake cloud database.

What I am offering?

Involved in Migrating Objects from MySQL to Snowflake.

Created Snowpipe for continuous data load.

Used COPY to bulk load the data.

Created internal and external stage and transformed data during load.

Used FLATTEN table function to produce lateral view of VARIENT, OBECT and ARRAY column.

Worked with both Maximized and Auto-scale functionality.

Used Temporary and Transient tables on diff datasets.

Cloned Production data for code modifications and testing.

Shared sample data using grant access to customer for UAT.

Scheduled different Snowflake jobs

Coding for Stored Procedures/ Triggers. 

Develop SQL queries SnowSQL

Develop transformation logic using snowpipeline.

Optimize and fine tune queries

Migrate data from one data source to another.

1. Data Ingestion

2. Data Migration

3. Data Cleansing

4. Data Pipeline Building

5. Query and Store Proc 

6. Table and Query Optimization

7. Building you databases

8. Data Modelling designs

9. ETL designs and process

10.Identifying business rules/requirements

11.Writting Simple and Complex Queries