Logo
Excellerate Consulting

ETL Architect

Excellerate Consulting, Windsor, Connecticut, us, 06006

Save Job

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) into Snowflake. Define data integration best practices, including reusability, scalability, and cost optimization. Lead and mentor ETL/ELT developers in building robust pipelines. Optimize Snowflake performance (virtual warehouses, clustering, query tuning). Establish data quality, governance, and 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. Qualifications

15+ 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

#J-18808-Ljbffr