Aws snowflake architect

JD -

a. Participate in gathering requirements from business users

b. Work with the Client’s Architecture team to understand the existing Architecture and suggest improvement and solutions to modernize the data platform

c. Provide support to define data architecture

d. Define target data models for Snowflake

e. Develop scripts to load data to AWS S3 staging area and Snowflake DW

f. Develop the required EMR/Lamda scripts for data loading

g. Support integration of data from multiple source systems and loading them into Snowflake DB

h. Good knowledge on Star Schema, Snowflake Schema, Fact and Dimension table

Good experience in AWS cloud services like S3, EMR, Glue, Athena and Redshift