Pune, Maharashtra

Job Summary

Key Responsibilities

Key Responsibilities

1. Data Pipeline Engineering

Design and develop scalable, high-performance data pipelines using SnowSQL, Snowpark, and Snowflake native capabilities

Build and optimize ELT/ETL frameworks supporting both batch and real-time workloads

Implement robust ingestion pipelines from diverse enterprise systems

2. Metadata-Driven Ingestion

Design and implement metadata-driven ingestion frameworks for scalable onboarding of datasets

Handle ingestion across multiple formats including XML, CSV, JSON, and Parquet

Automate ingestion, validation, and transformation processes

3. AI/GenAI Integration (Cortex AI)

Leverage Snowflake Cortex AI capabilities to enable AI-driven data transformations, enrichment, and insights generation

Collaborate with business and analytics teams to enable AI-powered data consumption use cases

Contribute to building intelligent, automated data pipelines and semantic layers

4. Data Modeling & Transformation

Develop scalable data models supporting analytics and reporting layers





Build transformations using Snowpark, SQL, and Snowflake native features

Optimize query performance and data access patterns

5. Data Delivery & Reporting Enablement

Deliver analytics-ready datasets in predefined formats for reporting tools (Power BI, Tableau, etc.)

Work closely with business stakeholders to ensure data usability and alignment with reporting requirements

6. Performance Optimization & Governance

Implement best practices for performance tuning, clustering, and cost optimization

Ensure data quality, governance, security, and compliance standards

Monitor, troubleshoot, and continuously improve pipelines

7. Stakeholder Engagement & Technical Consulting

Provide technical consultation on data architecture, ingestion strategies, and Snowflake capabilities

Act as a trusted advisor in data engineering and platform decisions

Skill Requirements

Required Skills & Experience

Skill

📌 Data Lead (Pune)
🏢 HCLTech
📍 Pune