Senior ETL/ELT Developer - Snowflake & AWS

Robotics Prcocess Automation, LLC; Stamford (CT); On-site; USD 100,000 - 130,000; Full time

Job summary

A premier data solutions provider is seeking an experienced ETL/ELT Developer to design and maintain ETL processes in Snowflake. The ideal candidate will have a strong background with various ETL tools and exceptional SQL skills. Responsibilities include integrating data from diverse sources, optimizing performance, and collaborating with teams to ensure data accuracy. This position offers a chance to contribute to cutting-edge data solutions in a dynamic environment.

Qualifications

• 7–10 years of experience in ETL/ELT development.
• Strong hands-on experience with ETL tools.
• Expertise in Snowflake including query tuning and data loading techniques.
• Strong proficiency in SQL and relational database concepts.
• Experience with varied data sources.
• Solid understanding of data warehousing concepts.
• Hands-on experience with at least one cloud platform.
• Good communication and problem-solving skills.

Responsibilities

• Design, develop, and maintain ETL/ELT processes for Snowflake.
• Integrate data from multiple sources.
• Write and optimize SQL queries and transformations.
• Monitor and troubleshoot ETL workflows.
• Collaborate with data architects and BI developers.
• Participate in performance tuning and optimization.

Skills

ETL/ELT development

ETL tools (Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran)

Snowflake expertise

SQL proficiency

Data sources (Oracle, SQL Server, SAP, Salesforce, REST APIs, flat files)

Data warehousing concepts

Cloud platform experience (AWS/Azure/GCP)

Communication and problem-solving skills

Tools

Snowflake

Informatica

Talend

Matillion

SSIS

AWS Glue

DBT

Fivetran

Job description

A premier data solutions provider is seeking an experienced ETL/ELT Developer to design and maintain ETL processes in Snowflake. The ideal candidate will have a strong background with various ETL tools and exceptional SQL skills. Responsibilities include integrating data from diverse sources, optimizing performance, and collaborating with teams to ensure data accuracy. This position offers a chance to contribute to cutting-edge data solutions in a dynamic environment.