Experience: 4-5 Years (Hands-on, Production Experience Required)

Location: Chennai We are looking for a true, hands-on Data Warehousing Engineer who has built and operated real production-grade data platforms — not just experimented with AI-assisted tools or prompt-based workflows. This role is for professionals who understand data engineering fundamentals, cloud warehousing, modeling, governance, and performance tuning — and who take full ownership of systems used daily by business teams. You will work closely with U.S.-based customers and stakeholders, providing high-quality delivery, operational support, and continuous improvement.

Key Responsibilities: Data Warehouse & Modeling

Data Ingestion & Pipelines

Data Transformation & Quality

Performance & Cost Optimization

Governance, Security & Compliance

Operations, Support & Stakeholder Engagement Required Technical Expertise: ❄️ Snowflake Platform Strong working knowledge of:

Virtual Warehouses & Micro-partitions

Time Travel & Zero-Copy Cloning

Streams, Tasks, and Snowpipe

Secure Data Sharing & Resource Monitors

Agile Tables

Data Engineering & Modeling

Advanced SQL, query optimization, and execution plan analysis

Experience with incremental loading patterns

Dimensional modeling, SCDs, and Data Vault concepts

Canonical and conformed data design

Security & Governance

RBAC and access control architecture

Secure views and policy-driven security

PII protection best practices

Preferred Snowflake Certifications





Snowflake certifications are strongly preferred and will be considered an advantage Preferred Certifications Include:

SnowPro Core

SnowPro Advanced (Data Engineer / Architect / Administrator)

Other Snowflake-affiliated certifications Please specify in your application:

Number of Snowflake certifications held

Date (Month/Year) of your most recent certification

Active or recently renewed certifications will be given preference Preferred Tooling Experience:

Transformation: dbt (preferred)

Orchestration: Airflow, Azure Data Factory, Dagster, Matillion

Ingestion: Fivetran, Informatica, Kafka, API pipelines (Python)

DevOps: Git, CI/CD, Infrastructure as Code (Terraform)

BI Tools: Power BI, Tableau, Looker Key Deliverables:

You will be expected to deliver:

Production-ready Snowflake architecture and environment standards

Enterprise data models, data dictionaries, and lineage documentation

Robust ELT pipelines with monitoring and observability

Automated data quality and reconciliation framework

Performance and cost optimization playbooks Who Should Apply

This role is ideal if you:

✅ Have 4–5 years of real-world data engineering experience

✅ Have supported live analytics platforms used by business teams

✅ Have worked with international / U.S.-based stakeholders

✅ Are comfortable owning systems end-to-end

✅ Prefer engineering depth over “tool-only” or “prompt-only” roles

This role is not suitable if your primary experience is limited to:

❌ AI prompt engineering

❌ Low-code AI wrappers

❌ Experimental or non-production projects

📌 Snowflake Engineer (Chennai)
🏢 Gantec
📍 Chennai