Talend Snowflake Lead

Role- Talend Snowflake Lead
Location – Atlanta, GA / Charlotte, NC / Raleigh, NC (No Remote)
Employment Type: Contract
Duration: Long Term (12+ months)

Snowflake, Talend, Cloud (AWS/Azure), API
Medallion architecture. ETL pipelines (Talend, Informatica)

• 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 Data Warehouse development, administration, and performance optimization.
• Strong knowledge of Data Warehousing Concepts, Data Marts, Enterprise Data Warehouse (EDW), and Data Integration methodologies.
• Expertise in Dimensional Data Modeling, including Star Schema, Snowflake Schema, Fact & Dimension tables, and SCD Type 1/2/3 implementations.
• Strong proficiency in SQL, Stored Procedures, Query Optimization, Performance Tuning, and Data Analysis.
• Experience implementing CDC (Change Data Capture), incremental load processes, and data reconciliation solutions.
• Hands-on experience with AWS Cloud services and cloud-based data platforms.
• Experience in Data Validation, Data Reconciliation, Data Quality, and Data Governance frameworks.
• Ability to create and maintain Source-to-Target Mapping (STTM) documents and technical specifications.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong communication and client-facing skills with the ability to work directly with business users and stakeholders.
• Experience working in Agile/Scrum delivery environments

• Own domain data definitions, business rules, and semantic accuracy across Gold layer assets.
• Serve as the authoritative voice between business stakeholders and engineering teams on data meaning and usage.
• Define and maintain data contracts, SLAs, and certified dataset criteria.
• Drive Medallion layer promotion standards, including qualification criteria for Gold and Platinum layers.
• Partner with the Catalog team (Alation) on business glossary and lineage documentation.
• Lead C-level discussions on data product strategy, business value, and platform direction.
• Create and deliver executive-ready presentations independently, without delegating to support staff.