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

xAI

AI Tutor Bilingual Job at xAI

...About xAI As an AI Tutor specializing in one or more of Korean, Vietnamese, Chinese, German, Russian, Italian, French, Arabic, Indonesian, Turkish, Hindi, Persian, Spanish, or Portuguese languages, your primary role will be to generate high-quality, accurately labeled...

Headway

Licensed Mental Health Counselor Job at Headway

...clients you see through Headway, so that you can set the hours that work for you. Grow your caseload by providing marketing support and... ...patients in-person or remotely via telehealth while working from home. We accept the following licenses on a state by state basis:...

JWC Commercial

Construction Superintendent Job at JWC Commercial

...Commercial of Fresno, CA is seeking to hire a full-time Construction Superintendent to oversee our commercial construction projects. The... ...software ~ Ability to pass a drug screening ~ Willing to travel A bachelor's degree in construction management is preferred...

Owens Corning

Roofing Sales Development Program Job at Owens Corning

...and maximize the potential of a global workplace. The Inside Sales Professional role is a part of our Owens Corning Sales... ...through a structured 18-24-month sales development opportunity in the Roofing business. Throughout the program, SDPs will be members of the Inside...

Poseidon Distribution Inc.

Regional Amazon Truck Driver Class A CDL Job at Poseidon Distribution Inc.

Our CDL Drivers Pay and Benefits 40hrs a week. $24/hr Drop and Hook /No touch freight Weekly payroll with direct deposit Home Every Day assignments Health, dental, vision insurance Paid time off 401(K) plan Qualifications Have a valid Commercial...