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 Solid

ETL/ELT Data Pipelines Strong

Data Modeling & Data Warehousing Concepts Strong

Troubleshooting & Production Support Strong

Stakeholder Management Strong

Good 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+ years of hands-on Snowflake implementation experience.

Proven experience in SAP ECC data extraction and migration projects.

Experience working in global delivery environments with direct customer interaction.

Key Competencies

Strong analytical and problem-solving skills.

Ability to work independently with mínimal supervision.

Excellent communication and stakeholder management skills.

Proactive ownership and accountability.

Strong documentation and knowledge-sharing mindset.

Primary Skill

Snowflake Data Engineering / Snowflake Data Integration

Secondary Skills

SAP SLT, SAP BODS, Datavard Glue, SAP ECC Data Extraction, Data Warehousing

Key Responsibilities

1. To analyze |define and design technical solution for ERP product’s enhancement and work towards continuous improvement during product implementation and production support stages.

2. To coordinate with technical teams for pending RICEFs.

3. To interact with the client and other functional teams for gaining understanding of the requirements.

4. To participate in team meetings.

5. To train others and prepare and deliver presentations for knowledge sharing amongst different teams in the project.

#body.unify div.unify-button-container.unify-apply-now : focus, #body.unify div.unify-button-container.unify-apply-#body.unify div.unify-button-container.unify-apply-now: focus, #body.unify div.unify-button-container.unify-apply

📌 Technical Consultant (Lucknow)
🏢 HCLTech
📍 Lucknow