Hiring,
Greetings from Modern Agile Technologies.
Positon: Talend Snowflake Lead Consultant
Location – Atlanta / Charlotte / Raleigh (No Remote)
Type: Contract (W2 Only)
Job Description:
Required Skills:
Talend development Linux/UnixPython
Medallion architecture. ETL pipelines (Talend, Informatica)
Snowflake, Talend, , SQL, Unix/Linux Scripts, Python automation, SAS (code analysis & conversion to Snowflake), Cloud (AWS/Azure)
Ø 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
