Participate in gathering requirements from business users
Work with the Client’s Architecture team to understand the existing Architecture and suggest improvement and solutions to modernize the data platform
Provide support to define data architecture
Define target data models for Snowflake
Develop scripts to load data to AWS S3 staging area and Snowflake DW
Develop the required EMR/Lamda scripts for data loading
Support integration of data from multiple source systems and loading them into Snowflake DB
Good knowledge on Star Schema, Snowflake Schema, Fact and Dimension tables
Good experience in AWS cloud services like S3, EMR, Glue, Athena and Redshift