FiveTran Snowflake Engineer Woodbridge NJ

  • Posted 1 day ago | Updated 1 day ago

Overview

Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6+ Month(s)

Skills

Extract
Transform
Load
Identity Management
Performance Tuning
Optimization
Backup Administration
Warehouse
Replication
Scripting
SQL
Transact-SQL
Writing
Python
Performance Analysis
Workflow
RDBMS
Database
Value Engineering
Oracle
Pipeline Management
IBM AIX
IBM DB2
Backup
Microsoft SQL Server
Cloud Computing
Snow Flake Schema
Amazon Web Services
Remote Desktop Services
Amazon RDS
DMS
Amazon S3
Amazon DynamoDB
Redis

Job Details

About the Role
We're seeking a hands-on Snowflake Engineer with FiveTran experiene

Must-Have Technical Skills
Snowflake Administration (Not ETL)
End-to-end ownership of schema creation, table setup, user management, and performance tuning
Experience with configuration, warehouse scaling, optimization, backups, troubleshooting, and monitoring disk/query performance
Comfortable with checking thresholds, analyzing warehouse blocking, and remediating query slowness
Replication Tools (FiveTran or HVR)
Must have solid experience with creating locations and channels. replication flow, agent monitoring, latency analysis

Scripting & Querying - must have some language to connect db with Snowflake
Strong SQL skills (T-SQL preferred) for writing and troubleshooting complex queries or ask if they have worked with Python for automation, performance analysis, and orchestrating workflows
Nice to have - RDBMS Platform Experience
Please be clear on which database platform(s) you've worked with, as this will determine your interview path.
Oracle: User and schema setup, pipeline management
DB2 (On-Prem): AIX/DB2 utilities like backup, reorg, runstats, rebind
SQL Server: Familiarity with general usage and indexing strategies
Nice to have - AWS Cloud Exposure
Snowflake environment managed within AWS
Familiarity with services such as:
o RDS, DMS, S3, Glue, DocumentDB, DynamoDB, Redis

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.