Snowflake Architect
Share
Job Location:
Sunnyvale, CA - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Position: Snowflake Architect
Location: Sunnyvale CA 94085 ( 3 Days Onsite)
Duration: 06 Months
Job Description:
Has good knowledge on Snowflake Architecture.
Understanding Virtual Warehouses - multi-cluster warehouse autoscaling
Metadata and system objects - query history grants to users grants to roles users
Micro-partitions
Table Clustering Auto Reclustering
Materialized Views and benefits
Data Protection with Time Travel in Snowflake - extremely imp
Analyzing Queries Using Query Profile - extremely important (Explain plan)
Cache architecture
Virtual Warehouse(VW)
Named Stages
Direct Loading
SnowPipe Data SharingStreams JavaScript Procedures & Tasks
Strong ability to design and develop workflows in Snowflake in at least one cloud technology (preferably AWS)
Apply Snowflake programming and ETL experience to write Snowflake SQL and maintain complex internally developed Reporting system.
Preferable knowledge in ETL Activities like data processing from multiple source systems.
Extensive Knowledge on Query Performance tuning.
Apply knowledge of BI tools.
Manage time effectively. Accurately estimate effort for tasks and meet agreed-upon deadlines. Effectively juggle ad-hoc requests and longer-term projects.
Location: Sunnyvale CA 94085 ( 3 Days Onsite)
Duration: 06 Months
Job Description:
Has good knowledge on Snowflake Architecture.
Understanding Virtual Warehouses - multi-cluster warehouse autoscaling
Metadata and system objects - query history grants to users grants to roles users
Micro-partitions
Table Clustering Auto Reclustering
Materialized Views and benefits
Data Protection with Time Travel in Snowflake - extremely imp
Analyzing Queries Using Query Profile - extremely important (Explain plan)
Cache architecture
Virtual Warehouse(VW)
Named Stages
Direct Loading
SnowPipe Data SharingStreams JavaScript Procedures & Tasks
Strong ability to design and develop workflows in Snowflake in at least one cloud technology (preferably AWS)
Apply Snowflake programming and ETL experience to write Snowflake SQL and maintain complex internally developed Reporting system.
Preferable knowledge in ETL Activities like data processing from multiple source systems.
Extensive Knowledge on Query Performance tuning.
Apply knowledge of BI tools.
Manage time effectively. Accurately estimate effort for tasks and meet agreed-upon deadlines. Effectively juggle ad-hoc requests and longer-term projects.
Key Skills
- APIs
- Pegasystems
- Spring
- SOAP
- .NET
- Hybris
- Solution Architecture
- Service-Oriented Architecture
- Adobe Experience Manager
- J2EE
- Java
- Oracle
