Zortech Solutions
Location
Ontario, CA | United States
Job description
Required Skills:
8+ years of experience implementing data management solutions (Required).
Management consulting experience (Highly Desired).
Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero copy clone, time travel and automating them.
Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
Experience in re-clustering of the data in Snowflake with good understanding on Micro-Partitions.
Experience in Migration processes to Snowflake from on-premises database environment.
Experience in designing and building manual or auto ingestion data pipeline using Snow pipe.
Experience in Cloud technologies such as AWS? S3, SQS, EC2, Lambda, Redshift, RDS Design and Develop automated monitoring processes on Snowflake using combination of Python, PySpark, Bash with Snow SQL
Experience in developing stored Procedures writing Queries to analyze and transform data. Certified Snowflake cloud data warehouse Architect (Desirable).
Job tags
Salary
