Sr. Snowflake Developer

Staffxpert Llc
New York, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 146K

Job location

New York, United States of America

Tech stack

Artificial Intelligence
Unit Testing
Big Data
Cloud Database
Computer Programming
Databases
Information Engineering
Data Integration
ETL
Data Migration
Data Warehousing
Relational Databases
Web Development
Dimensional Modeling
Amazon DynamoDB
Python
PostgreSQL
Microsoft SQL Server
MongoDB
MySQL
NoSQL
Oracle Applications
Performance Tuning
Query Optimization
SQL Databases
Snowflake
Spark
Integration Tests
Cassandra
Star Schema
Data Pipelines

Job description

  • Spark.
  • Spark job optimization.
  • Big Data technologies.

Data Modeling

  • Star Schema.
  • Snowflake Schema.
  • Dimensional Modeling.
  • Relational Database Design.
  • NoSQL Databases.

Databases

  • Strong experience with Relational Databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.).
  • Experience with NoSQL databases (MongoDB, Cassandra, DynamoDB, etc.).

Architecture

  • Data Warehouse Architecture.
  • Solution Design.
  • Technical Architecture.
  • Technical Documentation.
  • Functional Specifications.

Testing & Support

  • Unit Testing.
  • Integration Testing.
  • Troubleshooting production issues.
  • Performance tuning.
  • Root Cause Analysis., Web development professionals apply their technical skills to enhance AI research projects focused on understanding real-world professional tasks and language. This role offers the…
  • 1 day ago, As a Junior Python Game Developer specializing in Panda3D, you will play a crucial role in shaping the training of next-generation AI systems. Your contributions will directly impa…
  • 6 days ago

Requirements

  • 6 10+ years of Data Engineering / ETL / Data Warehouse experience.
  • Minimum 3+ years of hands-on experience with Snowflake Data Warehouse., * 6+ years of Data Engineering/ETL experience.
  • 3+ years of hands-on Snowflake (SnowSQL, SnowPipe, Architecture).
  • Strong Python and SQL.
  • ETL/Data Integration & Data Warehousing.
  • Star/Snowflake Schema & Dimensional Modeling.
  • Spark performance tuning.
  • Relational & NoSQL databases.
  • Cloud data pipelines.
  • Performance tuning & troubleshooting.
  • Good communication and client-facing skills.

Mandatory Skills (Must Have) Snowflake

  • 2+ years of hands-on experience with Snowflake Data Warehouse.
  • Strong experience in Snowflake architecture and solution design.
  • SnowSQL.
  • SnowPipe.
  • Snowflake security, roles, warehouses, stages, tasks, streams.
  • Snowflake performance tuning and query optimization.
  • Snowflake integration with external systems.

Programming

  • Python (mandatory).
  • Advanced SQL.

Data Engineering

  • Data Integration.
  • ETL/ELT Development.
  • Data Pipeline development and automation.
  • Cloud-based data pipelines.
  • Data migration into Snowflake.

Apply for this position