ETL Tech lead

Coforge; Windsor (CT); On-site; USD 110,208 - 117,096; Full time

Job summary

A leading consulting firm is looking for an experienced ETL Architect to design and implement ETL/ELT architecture using Snowflake. The ideal candidate will have over 10 years in ETL/ELT development, strong expertise in Snowflake, and proficiency in tools like Informatica and AWS Glue. This is an on-site position located in Windsor, CT, requiring strong data integration skills and leadership potential.

Qualifications

• 10+ years in ETL/ELT architecture and development.
• Strong expertise in Snowflake including warehouses and data sharing.
• Proficiency in multiple ETL/ELT tools.

Responsibilities

• Design and implement ETL/ELT architecture with Snowflake.
• Integrate data from diverse sources into Snowflake.
• Lead and mentor ETL/ELT developers.

Skills

ETL/ELT Architecture

Snowflake

SQL

Informatica

AWS Glue

Tools

Talend

Matillion

SSIS

DBT

Fivetran

Job description

This range is provided by Coforge. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$80.00/hr - $85.00/hr

Direct message the job poster from Coforge

Senior Talent Acquisition Specialist @ Coforge || Digital Engineer & Leadership Hiring || Strategic Hiring || Stakeholder Management ||

Job Title / Role: ETL Architect (Snowflake & AWS)

Experience: 12+

Location: Windsor CT, (Day 1 On-site)

Shift: General

Mode: On-Site

We at Coforge are seeking ETL Architect (Snowflake & AWS) with the following skill-set:

Key Responsibilities

• Design and implement ETL/ELT architecture with Snowflake as the enterprise data warehouse.
• Integrate data from diverse sources (RDBMS, APIs, SaaS apps, flat files, streaming platforms & cloud services) into Snowflake.
• Define data integration best practices, including reusability, scalability & cost optimization.
• Lead and mentor ETL/ELT developers in building robust pipelines.
• Optimize Snowflake performance (virtual warehouses, clustering & query tuning).
• Collaborate with data architects, BI developers, and business stakeholders for end-to-end data delivery.
• Evaluate and implement ETL/ELT tools and automation frameworks suited for multiple source systems.
• Troubleshoot integration issues and define long-term solutions.
• Keep up to date with Snowflake features and emerging data integration technologies.

Required Skills & Qualifications

• 10+ years in ETL/ELT architecture and development.
• Strong expertise in Snowflake (warehouses, streams, tasks, snowpipe, data sharing).
• Proficiency in multiple ETL/ELT tools: Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran.
• Strong SQL and performance optimization skills.