01 Aug
Data Architect - snowflake
Arizona, Scottsdale , 85250 Scottsdale USA

Vacancy expired!

Job DescriptionRole: Snowflake ArchitectRequired Skills: Must have total 10+ yrs. in IT and 2+ years' experience working as a snowflake Data Architectand 5+ years in Data warehouse, ETL, BI projects. Must have experience at least two end to end implementation of Snowflake cloud datawarehouse. Expertise in Snowflake data modeling, ELT using Snowflake SQL, implementing complexstored Procedures and standard DWH and ETL concepts Expertise in DBT, Matillion, FiveTran Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls,virtual warehouse sizing, query performance tuning, Zero copy clone, time travel andunderstand how to use these features Expertise in deploying Snowflake features such as data sharing, events, and lake-housepatterns Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe Experience in Data Migration from RDBMS ( Redshift preferrable) to Snowflake cloud datawarehouse Deep understanding of relational as well as NoSQL data stores, methods and approaches(star and snowflake, dimensional modeling) Experience with data security and data access controls and design Experience with AWS or Azure data storage and management technologies such as S3 andADLS Build processes supporting data transformation, data structures, data governance, metadata,dependency and workload management Strong Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performancetuning and troubleshooting Provide resolution to an extensive range of complicated data pipeline-related problems,proactively and as issues surface Must have expertise in AWS or Azure Platform as a Service (PAAS). Certified Snowflake cloud data warehouse Architect (Desirable).Should be able to troubleshoot problems across infrastructure, platform and application domains.Experience of Agile development methodologiesStrong written communication skills. Is effective and persuasive in both written and oral communication

Vacancy expired!


Related jobs

Report job