Gantec Corporation
Website:
gantecusa.com
Job details:
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
- Dynamic 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
Click on Apply to know more.