Westhouse is a leading recruitment company that operates globally in the field of personnel selection, placement and project management.

For our client we are currently looking for a

Snowflake Architect (m/f/d) - Munich + Orlando (US), Lisbon (PT) and India

General information

Reference:
125265
Start:
03.08.2020
Duration:
until 28.02.2021 + Option
Location:
Munich + Orlando (US), Lisbon (PT) and India
Volume:
full-time (100%)
Languages:
English (must), German (nice to have)

Your Tasks

  • Migration of a US on premises Oracle 12C database with the dependent ETL processes, to an AWS cloud-based data lake solution enhanced by a SNOWFLAKE database. Replication of the data structures of the current solution, Orc12c db, 1:1 to the SNOWFLAKE database (except staging layer) Migration of the data from the current ORACLE database 1:1 to the SNOWFLAKE database (except staging layer)
  • Replication of the data structures of the current solution, Orc12c db, 1:1 to the SNOWFLAKE database (except staging layer)
  • Migration of the data from the current ORACLE database 1:1 to the SNOWFLAKE database (except staging layer)
  • The database and the ETL/ELT component are planned to be migrated to an AWS cloud, with SNOWFLAKE as the database and we have identified GLUE/Spark as the preferred ELT service.

Your Skills

  • Design and implement effective Analytics solutions and models with Snowflake on AWS
  • Must have experience: end to end implementation of Snowflake cloud data warehouse and end to end data warehouse implementations on-premise preferably on Oracle
  • Expertise in Snowflake – data modeling, ELT using Snowflake SQL, implementing stored procedures and standard DWH+ETL concepts
  • Examine and identify Datawarehouse structural necessities by evaluating business requirements
  • Experience with AWS data storage and management technologies such as S3
  • professional certification preferred in AWS, Oracle, SNOWFLAKE

Interested

We look forward to receiving your application documents in electronic form.