Skills

SQL Architecture Databases AWS Snowflake Talend

Job Specifications

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

Key Skills: Snowflake, AWS, APIs, Databases & Flat files

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).
Establish data quality, governance & lineage frameworks.
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.

About the Company

Coforge is a global digital services and solutions provider, that enables its clients to transform at the intersect of domain expertise and emerging technologies to achieve real-world business impact. A focus on very select industries, a detailed understanding of the underlying processes of those industries, and partnerships with leading platforms provides us with a distinct perspective. Coforge leads with its product engineering approach and leverages Cloud, Data, Integration, and Automation technologies to transform client... Know more