Lead Snowflake Developer
- Country: United States
- Region: Texas
Position: Lead Snowflake Developer
Location: Texas City, TX (Remote Till Covid)
Type: Contract
Job Description:
· Total IT industry experience of 8+ years.
· Experience in building resilient data engineering pipelines within
Snowflake.
· Demonstrate expertise in snowflake data modeling and ETL using
snowflake SQL implementing complex stored procedures.
· Strong understanding of best practices in data warehousing and ETL
concepts.
· Demonstrate expertise on programming using snowflake concepts like
orchestration of jobs ? moving files from FTP to S3 bucket.
· Demonstrate good RestAPI knowledge.
· Strong PL/SQL knowledge and experience.
· Programming using snowflake with language as SQL (having JAVA
experience is an added advantage).
· Have a good understanding of any ETL/ELT tool which brings in data
to Snowflake like DBT/Matillion/Hevodata/Fivetran/etc.
· Should be able to create CTEs, Complex nested views, tasks,
streams, different kinds of tables, etc within Snowflake.
· Experience with data loads from AWS-S3 to Snowflake using various
options such as bulk loading/Snowpipe/etc.
· Should be familiar with AWS services like S3, SNS, SQS, File
transfer protocols, storage integrations, etc.
· API familiarity within AWS is an advantage.
· Should be able to demonstrate skills of processing semi-structured
data sets and have used flattening functions within Snowflake.
· Ability to do performance tuning within Snowflake.
· Ability to perform code reviews and guide the engineering team on
Snowflake best practices.
Reference : Lead Snowflake Developer jobs