What are the responsibilities and job description for the Talend Snowflake Developer position at Drunix Solution Inc?
🚨 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.