Talend Snowflake Developer

Hiring: Talend Snowflake Lead

Location: Atlanta, GA / Charlotte, NC / Raleigh, NC (onsite)
Experience: 8+ Years

Email:

Role Overview

We are looking for an experienced Talend Snowflake Lead with strong hands-on expertise in Talend ETL development, Snowflake data warehousing, SQL, Linux/Unix scripting, and Python automation.

The ideal candidate will have experience building scalable ETL/ELT pipelines, implementing Medallion Architecture, optimizing Snowflake performance, and supporting data migration and transformation initiatives, including SAS code analysis and conversion to Snowflake.

Key Responsibilities

• Lead and develop ETL/ELT pipelines using Talend and other data integration tools.

• Design, develop, and optimize Snowflake data warehouse solutions.

• Implement Medallion Architecture and scalable data processing workflows.

• Develop SQL queries, stored procedures, and Linux/Unix scripts.

• Use Python for automation, data processing, and operational tasks.

• Analyze existing SAS code and support its conversion to Snowflake-compatible solutions.

• Implement CDC, incremental loads, data reconciliation, and data validation processes.

• Develop and maintain dimensional data models, including Star Schema, Snowflake Schema, and SCD Type 1/2/3.

• Support cloud-based data platforms using AWS and/or Azure.

• Prepare Source-to-Target Mapping (STTM) documents and technical specifications.

• Perform performance tuning, troubleshooting, data quality checks, and optimization.

• Collaborate with business stakeholders and technical teams in Agile/Scrum environments.

Required Skills

• 8+ years of experience in ETL/Data Engineering and Data Warehouse implementations.

• Strong hands-on experience with Talend ETL/ELT development.

• Extensive experience with Snowflake development, administration, and performance optimization.

• Strong proficiency in SQL, stored procedures, query optimization, and performance tuning.

• Experience with Linux/Unix scripting and Python automation.

• Knowledge of Data Warehousing, EDW, Data Marts, and dimensional data modeling.

• Experience with CDC, incremental loading, data reconciliation, and data quality.

• Familiarity with Medallion Architecture and cloud platforms such as AWS/Azure.

• SAS code analysis and conversion experience is highly desirable.

• Excellent analytical, troubleshooting, communication, and client-facing skills.