Data Engineer (ETL to Snowflake)
Job Description
Job Description Summary
• Job Title: Data Engineer (ETL to Snowflake)
• Experience Required: 5+ Years
• Number of Positions: 3
• Employment Type: Contract
• Location: Remote
• Notice Period / Joining Period: Immediate
• Shift Timings: General Shift + EST Overlap
Job Overview
We are seeking experienced Data Engineers (5+ years) to join our team on a contract basis. The ideal candidates will be responsible for building, optimizing, and maintaining robust ETL/ELT pipelines for migrating and transforming data into Snowflake. You will leverage Azure Data Factory (ADF), ADLS, dbt, Python, and SQL to deliver high-performance data architecture solutions.
Key Responsibilities
• ETL/ELT Pipeline Development: Design, build, and maintain scalable data pipelines to ingest and transform data from multiple sources into Snowflake using ADF and dbt.
• Data Transformation & Modeling: Write clean, modular, and reusable data transformations using dbt and advanced SQL.
• Data Lake Management: Architect and manage structured, semi-structured, and unstructured data stored in Azure Data Lake Storage (ADLS).
• Custom Automation: Develop scripts and data ingestion routines using Python.
• Snowflake Performance Tuning: Optimize virtual warehouses, clustering strategies, queries, and cost management in Snowflake.
• Collaboration & Quality Assurance: Implement automated data validation checks and work collaboratively during overlapping EST business hours.
Mandatory Skills & Qualifications
• Snowflake: Deep expertise in Snowflake architecture, tasks, streams, Snowpipe, and query performance tuning.
• dbt (Data Build Tool): Proven hands-on experience structuring models, macros, testing, and documentation using dbt.
• Azure Data Factory (ADF): Strong skills in pipeline orchestration, data flows, dynamic parameterization, and integration triggers.
• ADLS: Experience managing and querying data stored within Azure Data Lake Storage Gen2.
• Python & SQL: Strong proficiency in Python scripting for data engineering and mastery of complex SQL (CTEs, window functions, analytics functions).
• Experience Level: 5+ years of core Data Engineering / ETL experience.
Pay: ₹80,000.00 - ₹120,000.00 per month
Work Location: Remote
Report this listing
