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
We are seeking a highly skilled Snowflake Data Integration Consultant with strong expertise in designing, developing, and supporting enterprise data platforms. The ideal candidate should have extensive experience in extracting SAP ECC data using SLT, BODS, and Datavard Glue and integrating it into Snowflake-based analytical solutions.
The candidate must be capable of independently handling end-to-end data integration activities, performance optimization, troubleshooting complex data issues, and collaborating with business and technical stakeholders.
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
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 minimal 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
This JD should help attract candidates capable of replacing Pallavi's Snowflake and SAP-to-Snowflake integration responsibilities while ensuring minimal transition risk.
Key Responsibilities
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.