Sr. Snowflake Developer

Location: New York/NJ

Overall Experience

• 6 10+ years of Data Engineering / ETL / Data Warehouse experience.
• Minimum 3+ years of hands-on experience with Snowflake Data Warehouse.

Required Skills

• 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.

Big Data

• 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.