Beschreibung
Role: Snowflake Architect - Migration of legacy DWH to SnowflakeLocation: Bonn, Cologne
4 months
Telecom
Language: German
Required & nice to have Skills:
Must Haves:
• Must have strong experience working as a snowflake Data Architect.
• Must have experience at in migration of legacy data warehouse to Snowflake cloud data warehouse
• Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Experience in Data Migration from Oracle to Snowflake cloud data warehouse
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Must have expertise in any cloud platform AWS or Azure.
• Must have experience of Agile development methodologies
• Fluent in English and German (min B2)
Nice to Have/ Your chance to grow
• Certified Snowflake cloud data warehouse Architect (Desirable).
• Live and breathe the agile mindset.
• High learnability to learn and master several open-source and in-house built tools
• Use a data mindset with a love for data, curiosity, and strong analytical capabilities.
• You feel comfortable working in a very dynamic environment in which changes are the only constant