ETL Developer with Snowflake and 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

Responsibilities

• Design, develop, and maintain ETL/ELT processes to load data into Snowflake.
• Integrate data from multiple sources (databases, APIs, SaaS platforms, flat files, cloud services).
• Write and optimize SQL queries, stored procedures, and transformations.
• Work closely with the ETL Architect to implement best practices for data integration and performance.
• Conduct data profiling, validation, and quality checks to ensure accuracy and completeness.
• Monitor and troubleshoot ETL workflows, ensuring timely resolution of issues.
• Collaborate with data architects, BI developers, and business stakeholders to deliver reliable datasets.
• Participate in performance tuning, cost optimization, and workload management in Snowflake.
• Contribute to process automation and continuous improvement initiatives.

Required Skills & Qualifications

• 7–10 years of experience in ETL/ELT development.
• Strong hands-on experience with ETL tools (Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran).
• Expertise in Snowflake including query tuning, warehouse optimization, and data loading techniques.
• Strong proficiency in SQL and relational database concepts.
• Experience with varied data sources such as Oracle, SQL Server, SAP, Salesforce, REST APIs, flat files.
• Solid understanding of data warehousing concepts (star schema, snowflake schema, dimensional modeling).
• Hands-on experience with at least one cloud platform (AWS/Azure/GCP).
• Good communication and problem-solving skills.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract