Lucknow, Uttar Pradesh

Job Summary

Job Description - Snowflake Data Integration Consultant

Band: E2 (depending on experience)
Location: India (Hybrid/Remote as per project requirement)
Experience: 6-10 Years

Role Summary

Key Responsibilities

Design, develop, and support enterprise-scale data solutions on the Snowflake Data Cloud platform.

Implement and maintain data extraction and replication processes from SAP ECC using:
SAP SLT (Landscape Transformation)

SAP BODS (BusinessObjects Data Services)

Datavard Glue

Develop scalable ETL/ELT pipelines for structured and semi-structured data.

Optimize Snowflake performance, warehouse sizing, clustering, partitioning, and query execution.

Troubleshoot data integration, transformation, and loading issues across source and target systems.

Ensure data quality, consistency, governance, and security standards are adhered to.

Work closely with business users, architects, and functional teams to gather requirements and translate them into technical solutions.

Support production deployments, incident resolution, root cause analysis,



and continuous improvements.

Participate in design reviews, architecture discussions, and solution recommendations.

Mandatory Skills

Skill ProficiencySnowflake Data Warehouse Expert

SAP ECC Data Extraction Expert

SAP SLT Strong

SAP BODS Strong

Datavard Glue Strong

SQL & Performance Tuning Strong

ETL/ELT Data Pipelines Strong

Data Modeling & Data Warehousing Concepts Strong

Troubleshooting & Production Support Strong

Stakeholder Management Strong

Positive to Have Skills

Snowflake Streams, Tasks, Dynamic Tables

Python or Shell Scripting

Azure Data Factory (ADF)

SAP BW/BW4HANA integration exposure

Data Governance and Metadata Management tools

Agile/Scrum delivery experience

Educational Qualification

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.

Preferred Experience

6+ years of experience in Data Warehousing and Analytics.

3+

📌 Technical Consultant (Lucknow)
🏢 HCLTech
📍 Lucknow