ETL Data Engineer

Job description

Experience: 2 to 4 Years

Location: Coimbatore- Work from Office

Employment Type: Full-time

Availability: Immediate Joiner Preferred

Job Summary

We are looking for a motivated ETL Data Engineer with 2–3 years of experience in building and maintaining data pipelines. The ideal candidate should have hands-on experience with Snowflake and strong expertise in ETL/ELT processes, data warehousing, and SQL. You will play a key role in transforming raw data into reliable, scalable, and high-quality datasets for analytics and business intelligence.

Key Responsibilities

•⁠ ⁠Design, develop, and maintain ETL/ELT pipelines using Snowflake

•⁠ ⁠Design, develop, and maintain modular dbt models (SQL & Python) using best practices like DRY (Don’t Repeat Yourself) and version control.

•⁠ ⁠Extract data from multiple sources (databases, APIs, flat files, cloud systems)

•⁠ ⁠Transform and load data into Snowflake data warehouse efficiently

•⁠ ⁠Write optimized SQL queries for data processing and transformation

•⁠ ⁠Develop and maintain data models (star schema, snowflake schema)

•⁠ ⁠Ensure data quality, integrity, and consistency across pipelines

•⁠ ⁠Monitor, troubleshoot, and optimize ETL workflows and job performance

•⁠ ⁠Collaborate with data analysts, BI developers, and business stakeholders

•⁠ ⁠Implement data validation, error handling, and logging mechanisms

•⁠ ⁠Maintain documentation for data pipelines, workflows, and architecture

Required Skills & Qualifications

•⁠ ⁠2–3 years of experience in ETL/Data Engineering

•⁠ Hands-on experience with dbt (Core or Cloud), including macros, packages, and hooks.

•⁠ ⁠Hands-on experience with Snowflake (tables, stages, warehouses, data loading)

•⁠ ⁠Strong proficiency in SQL (joins, window functions, CTEs, performance tuning)

•⁠ ⁠Experience in ETL/ELT tools (e.g., Azure Data Factory, Informatica, Talend, etc.)

•⁠ ⁠Good understanding of data warehousing concepts

•⁠ ⁠Knowledge of data modeling techniques (dimensional modeling)

•⁠ ⁠Familiarity with file formats (CSV, JSON, Parquet)

•⁠ ⁠Experience handling large datasets and optimizing performance

•⁠ ⁠Basic scripting knowledge (Python or Shell scripting is a plus)

•⁠ ⁠Strong analytical and problem-solving skills

Preferred Skills

•⁠ ⁠Experience with cloud platforms (Azure/AWS/GCP)

•⁠ ⁠Knowledge of Snowflake features like Time Travel, Cloning, and Data Sharing

•⁠ ⁠Familiarity with orchestration tools (Airflow, Prefect, etc.)

•⁠ ⁠Experience with dbt (Data Build Tool)

•⁠ ⁠Exposure to CI/CD pipelines and version control (Git)

•⁠ ⁠Understanding of Agile methodologies (Scrum/Kanban)

Education

•⁠ ⁠Bachelor’s degree in Computer Science, Information Technology, or related field

Nice to Have

• ⁠Snowflake certification (SnowPro Core or equivalent)