Talend Snowflake Lead

Infinite Computer Solutions; Atlanta (GA); On-site; USD 120,000 - 160,000; Full time

Job summary

Infinite Computer Solutions seeks a senior Data Engineer with 8+ years of ETL and Data Warehouse experience to deliver enterprise-scale data solutions. You will drive Talend-based ETL development, optimize Snowflake DWs, and lead data modeling efforts in an Agile setup.

Responsibilities include implementing CDC/incremental loads, ensuring data quality and governance, and collaborating with business users to meet analytics needs.

Qualifications

• 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, EDW, and Data Integration methodologies.
• Expertise in Dimensional Data Modeling, including Star/Snowflake schemas, F&T tables, and SCD Type 1/2/3 implementations.
• Strong proficiency in SQL, Stored Procedures, Query Optimization, Performance Tuning, and Data Analysis.
• Experience implementing CDC, incremental loads, and data reconciliation solutions.
• Hands-on experience with AWS Cloud services and cloud-based data platforms.
• Experience in Data Validation, Reconciliation, Quality, and Governance frameworks.
• Ability to create and maintain STTM documents and technical specs.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong communication and client-facing skills with stakeholders.

Responsibilities

• Design and implement end-to-end ETL pipelines.
• Develop and optimize Snowflake data warehouses.
• Create dimensional models (star/snowflake schemas).
• Implement CDC, incremental loads, and data reconciliation.
• Ensure data quality, validation, and governance across platforms.
• Collaborate with business users in Agile delivery environments.

Skills

ETL/Data Engineering

Snowflake

Talend

SQL

Data Modeling

Data Quality

Cloud (AWS)

Data Governance

Agile/Scrum

Python

Tools

Talend

Snowflake

Informatica

Unix/Linux

Python

SAS

AWS

Azure

Job description

Job Description: 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 Required Skills

Snowflake, Talend, Cloud (AWS/Azure), API

• Medallion architecture. ETL pipelines (Talend, Informatica)
• Snowflake, Talend, , SQL, Unix/Linux Scripts, Python automation, SAS (code analysis & conversion to Snowflake), Cloud (AWS/Azure)