Job Description

:
Job Title: Snowflake Developer AI/ML Enablement
Role Summary :
We are seeking a highly skilled Snowflake Developer AI/ML Enablement with strong data engineering expertise and hands-on experience in building AI-ready data platforms. The role focuses on designing, developing, and optimizing scalable Snowflake-based data solutions, supporting batch, near-real-time, and streaming workloads, and enabling advanced analytics and AI/ML use cases.
Mandatory Domain Requirement: Strong Retail domain knowledge, with hands-on understanding of Merchandising and Planning data, processes, and KPIs.
Key Responsibilities :
Snowflake Development Data Modeling :

• Design, develop, and maintain Snowflake data models to meet business and analytics requirements.
• Implement dimensional models Star, Snowflake and advanced patterns such as Data Vault where applicable.
• Collaborate with data architects to ensure scalable, efficient, and cost-optimized database structures.
• Apply best practices for data loading, clustering, partitioning, and indexing.

ETL/ELT Data Pipelines

• Develop and maintain ELT pipelines to ingest, transform, and curate data in Snowflake.
• Leverage Snowflake-native capabilities such as Snowpipe, Streams, Tasks, and Dynamic Tables.
• Build pipelines supporting both batch and near-real-time processing.
• Ensure data quality, reconciliation, and accuracy through validation and automated checks.

SQL Development Performance Optimization :

• Write, test, and optimize complex SQL queries for data retrieval, transformation, and analytics.
• Perform performance tuning of queries, warehouses, and workloads to improve efficiency and reduce cost.
• Conduct root cause analysis for performance bottlenecks and data issues.

Workflow Orchestration Apache Airflow :

• Design, develop, and maintain Apache Airflow DAGs for batch and hybrid pipelines.
• Implement dependency management, retries, alerting, SLA monitoring, and failure recovery.
• Orchestrate Snowflake jobs, ML workflows, and downstream analytics processes.

Streaming Event-Driven (Data Kafka) :

• Design and support Kafka-based ingestion pipelines into Snowflake.
• Handle event ordering, late-arriving data, reprocessing, and replay scenarios.
• Manage schema evolution and data contracts for streaming use cases.
• Integrate Kafka with Snowflake using Snowpipe Streaming or Kafka connectors.

AI/ ML Enablement on Snowflake:

• Prepare, curate, and manage datasets for machine learning and advanced analytics. Implement ML workflows using Snowpark Python and Snowflake ML.
• Support feature engineering, model training, inference, and evaluation.
• Enable AI-driven retail use cases such as demand forecasting, assortment optimization, anomaly detection, and recommendations.

Integration, Automation DevOps:

• Integrate Snowflake with APIs, cloud storage, BI tools, and streaming platforms.
• Implement CICD pipelines for SQL, Python, and Airflow deployments.
• Support automated testing, version control, and release management.

Security, Governance Reliability:

• Implement RBAC, masking policies, rowcolumn-level security, and secure data sharing.
• Ensure compliance with data governance, privacy, and audit requirements.
• Monitor pipelines, manage failures, and support data reprocessing.
• Maintain technical documentation and operational runbooks.

Agile Delivery:

• Actively participate in AgileScrum ceremonies including sprint planning, stand-ups, reviews, and retrospectives.
• Collaborate closely with business stakeholders, product owners, and cross-functional teams.

Required Skills & Experience:

• Bachelors Degree in Computer Science, Information Technology, or a related field.
• 3-10+ years of experience in data engineering or analytics engineering.
• Proven hands-on experience as a Snowflake Developer or similar role.
• Advanced SQL skills and strong understanding of relational database concepts.
• Experience with Snowflake features: Snowpipe, Streams, Tasks, Dynamic Tables
• Strong experience with Apache Airflow DAG design, monitoring, troubleshooting
• Experience with Kafka or event-drivenstreaming architectures.
• Proficiency in Snowpark Python.
• Solid understanding of data warehousing principles and best practices.
• Working knowledge of AIML fundamentals feature engineering, training, inference. Mandatory Retail domain expertise, especially in Merchandising and Planning Excellent problem-solving, analytical, and communication skills.

Good-to-Have Skills:

• Snowflake Certification
• Experience with Snowflake ML, Cortex, or AI functions
• Knowledge of Python ML libraries pandas, numpy, scikit-learn
• Experience with BI tools Power BI, Tableau, Looker
• Exposure to real-time analytics or streaming-heavy platforms.
• Knowledge of cloud platforms AWS, Azure, or GCP
• Understanding of data security, encryption, and governance in Snowflake.
• Exposure to MLOps practices.

About Us:
ITC Infotech is a global technology solution and services leader providing business-friendly solutions, that enable future-readiness for clients. We seamlessly bring together digital expertise, strong industry-specific alliances, and deep domain expertise from ITC Group businesses. Our solutions and services are focused on Banking and financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality.
ITC Infotech is a wholly-owned subsidiary of ITC Ltd, one of India's most admired companies.
ITC Infotech is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. ITC infotech is committed to providing veteran employment opportunities to our service men and women.
Department:
Lateral
Skills Required:
Technical | App Development | Database | SQL
Years Of Exp:
8 to 15 Years
Education/Qualification:
BE/BTECH/MCA

Skills Required