Snowflake Technical Lead

  • Salary

    $110,000 - $135,000 Per Year

Experience

10 to 15 Years

Posted On

Mar 20, 2024

Company

PB Consulting

Travel Requirements

0%

Job Overview

Required Skills

  • Snowflake
  • SQL Server
  • Oracle
  • Teradata
  • performance tuning
  • troubleshooting
  • data pipeline

Job Type

Full-time

Location

Dallas, TX

Job Description
  • Provide resolution to an extensive range of complicated data pipeline related problems, proactively helping the team and take the ownership for closer.
  • Must have played Technical role as Snowflake Technical Lead.
  • Must have prior experience with end-to-end implementation of Snowflake cloud data migration from on-premises preferably from any RDBMS like SQL Server, Oracle, Teradata etc.
  • Expertise and hands-on experience in Snowflake - data modelling, ELT using Snowflake SQL, Stored Procedure, Snowpark.
  • Should have hands-on experience in AWS Glue/Pyspark Data Frame/DataStage/Matillion/Informatica and AWS data storage and management technologies such as S3.
  • Should have Snowflake advanced concepts like setting up resource monitors, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, Streams and Tasks.
  • Must be proficient in complex SQL, Unix Shell Scripting, performance tuning and troubleshooting.
  • Must have experience of Agile development methodologies.
  • Experience with data security and data access controls and design, RBAC Policies, Dynamic Masking, Secured Views etc.
  • Nice to have hands-on experience in Airflow, Data Unloading from Snowflake and Snowflake utilities.
Qualifications
  • Bachelor's in computer science, IT related or similar
  • Hands-on experience with Snowflake utilities, Copy Command from S3, SnowSQL, SnowPipe.
  • Must be SnowPro Core Certified Professional.
  • Snowflake Advance Architect Certified Professional (Desirable).
  • Should have very good written and verbal communication skills.
  • Should have played Customer facing role.

Job ID: PC240086

  • Posted By

    William Christopher

Designation

Sr. Manager

Company

PB consulting

Last Login

Apr 26, 2024

Posted On

Mar 20, 2024


Related Jobs