AWS Engineer with Snowflake job at GATE Insight, Inc. Franklin, TN, US

Job Description

Position : AWS Engineer with Snowflake Location :- Franklin TN (Day 1 onsite) Duration : Long Term Overall 10yrs experience Key skills :- Strong AWS with some snowflake Exp Responsibilities:

Design, implement, and manage Snowpipe to automate and streamline the ingestion of data files from Amazon S3 into Snowflake.
Ensure the reliability and timeliness of data ingestion processes, and monitor their performance.
Utilize Snowflake Streams to capture and manage changes in data.
Write and maintain stored procedures to process, transform, and move data between different layers within Snowflake.
Optimize Snowflake performance through query tuning and managing storage costs.
Collaborate with data architects, data analysts, and other team members to understand data requirements and align with project goals.
Coordinate with stakeholders to identify and resolve data-related issues or improvements.
Diagnose and resolve issues related to data ingestion, transformation, and Snowflake operations.
Provide support for ongoing maintenance and enhancement of Snowflake data solutions.
Develop and maintain comprehensive documentation for Snowflake architecture, data pipelines, transformation processes, and best practices.

Required Skills:

Minimum of 10+ years of experience in IT, including at least 4 years of hands-on experience with Snowflake.
Proven experience with Snowflake's Snowpipe for data ingestion, Snowflake Streams for change data capture, and stored procedures for data processing and transformation.
In-depth knowledge of Snowflake's architecture, features, and best practices.
Strong understanding of integrating Snowflake with Amazon S3 for data ingestion and management.
Advanced SQL skills, including the ability to write complex queries, perform data manipulation, and optimize query performance.
Comprehensive knowledge of data warehousing concepts, data modeling, ETL processes, and data governance.
Strong analytical skills for troubleshooting and resolving complex data issues and performance problems.
Excellent communication skills to convey technical information clearly to non-technical stakeholders.
Ability to work collaboratively with team members and stakeholders across different departments.
Basic experience with AWS services, including fundamental understanding and use of services such as Amazon S3.

Preferred Skills:

Snowflake certification(s) is a plus.
Experience with programming languages such as Python or JavaScript GATE Insight, Inc.

Job Tags

Similar Jobs

Technetics Group

Manufacturing Engineer Job at Technetics Group

...COMPANY OVERVIEW: Technetics Group is a leading designer and manufacturer of custom engineered mechanical seals for rotating shafts and precision components for aerospace and specialized industrial applications. Technetics Group is a division of is one of six operating...

4th Day Trucking

Hig Pay Opputunity, CDL A, Home Weekly Job at 4th Day Trucking

...Job Title: Family Dollar Dedicated CDL-A Truck Driver - $1000 SOB Bonus Industry-Leading Pay Package Home Weekly! Key Requirements: CDL-A License Minimum 3 months driving experience Clean MVR & SAP Able to pass hair follicle test What You'll Earn...

Genuine Parts Company

Business Development Manager Autocare & Major Accounts Job at Genuine Parts Company

Business Development Manager, Major Accounts & Auto Care Job Summary The Business Development Manager, Major Accounts focuses on growing our Major Account and Auto Care sales. This role is responsible for communicating and executing strategic initiatives, program adoption...

Pacvue

VP, Sales - Global HoldCos Job at Pacvue

Pacvue is the leading software suite for eCommerce advertising, sales, and intelligence. We help some of the worlds largest brands grow their business on Amazon, Walmart, Instacart, and other marketplaces and work with sellers and agencies of all sizes to help them compete...

The Brothers That Just Do Gutters

Gutter Repair Maintenance and Cleaning technician Job at The Brothers That Just Do Gutters

...Job Description:We are seeking a skilled and detail-oriented individual to join our team as a Gutter Repair, Maintenance & Cleaning Technician. In this role, you will be responsible for inspecting, repairing, and maintaining gutters to ensure they function properly...