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

Sterling Consulting Solutions, Inc.

Home-Based Appointment Setter (Entry Level) Job at Sterling Consulting Solutions, Inc.

...Job Title: Home-Based Appointment Setter (Entry Level) Location: Remote Job Responsibilities: Data Entry and Record Management: Maintain accurate records of bookings, payments, and customer interactions using our CRM system. Schedule Appointments : Schedule...

WeConnect International Inc

Accounts Receivable and Budget Manager Job at WeConnect International Inc

...Job Description Job Description Job Title: Accounts Receivable and Budget Manager Department: Operations Location: Washington, DC Metropolitan Area - Hybrid FLSA Status: Exempt Reporting to: Chief Operating Officer ____________________________________...

Tutoring of Nashville

Private Tutor - ACT Test Prep Job at Tutoring of Nashville

...organization and we are fully invested in the success of our students, tutors, and employees. We provide in-home, one-on-one tutoring for... ...:We are looking for an experienced and highly qualified private tutor to assist high school students in their preparation for the...

The Pingry School

Upper School Biology/ Chemistry Teacher Job at The Pingry School

...Teaching 3 sections of Biology and/or Chemistry with lab. Supervise student research lab during morning and afternoon research periods, providing mentorship in conducting research safely and with scientific soundness. Serve as an advisor to a group of students....

Perth Amboy Public Schools

ESL Teacher Job at Perth Amboy Public Schools

Position Type: Elementary School Teaching/ESL Date Posted: 2/9/2024 Location: Dual Language School Description: Must have ESL Certification Attachment(s): ~ Click here for Job Description Perth Amboy Public Schools