Position: AWS Snowflake Architect Location - Day one onsite - Chicago, ILDuration: ContractPlease share self assement email for Snowflake/ AWS EMR/GLUE/REDSHIFT JD -
Participate in gathering requirements from business usersWork with the Client’s Architecture team to understand the existing Architecture and suggest improvement and solutions to modernize the data platformProvide support to define data architectureDefine target data models for SnowflakeDevelop scripts to load data to AWS S3 staging area and Snowflake DWDevelop the required EMR/Lamda scripts for data loadingSupport integration of data from multiple source systems and loading them into Snowflake DBGood knowledge on Star Schema, Snowflake Schema, Fact and Dimension tablesGood experience in AWS cloud services like S3, EMR, Glue, Athena and Redshift