What are the responsibilities and job description for the ETL Architect position at Coforge?
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.
Salary : $80 - $85
