Talend Snowflake Developer

• 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.

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., * 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.