Snowflake Developer

Related skill experience: 5+ Years.

*****Emphasis will be on SAP Integration and SQL skills.***

10 months duration ; May extend

Remote role ; Independent Contractor ; 40hrs/ week; 8hrs/ day ; Monthly pay in USD ;

Candidate need to use own computer for work ; B2 and above English communication skills needed ; Need to have short notice period

We are hiring for our client in USA . Candidate need to support CST/EST USA timezone

SUMMARY OF ROLE:

The Engineering & Applications Team is the IT engine that delivers compelling and robust capabilities, products, and solutions to business and IT by focusing on cost savings, business growth, and connecting with partners and customers. As part of this team, the Senior Snowflake Developer will align to one or more enterprise data and supply chain functions, with responsibility for developing and supporting the most complex data integration projects undertaken by the IT organization. This role will focus on delivering scalable and efficient data solutions within the Snowflake environment, enabling advanced analytics and seamless integration with SAP ECC and other enterprise systems.

Scope:

• The developer will be responsible for designing, building, and maintaining data pipelines and integration frameworks between Snowflake and SAP ECC. This includes:

• Extracting, transforming, and loading (ETL) data from SAP ECC using tools such as SAP Data Services, CPI DS, or custom connectors.

• Developing scalable Snowflake data models and optimizing performance.

• Ensuring data quality, consistency, and security across integrated systems.

• Collaborating with SAP functional teams, data architects, and business stakeholders to deliver reliable and timely data solutions.

Key Responsibilities:

• Design and implement data integration solutions between Snowflake and SAP ECC.

• Develop and optimize Snowflake data models, views, and stored procedures.

• Build and maintain ETL/ELT pipelines

• Ensure data governance, lineage, and compliance across platforms.

• Troubleshoot and resolve data integration issues and performance bottlenecks.

• Document technical specifications and maintain best practices

Qualifications:

• Minimum 5 years of hands-on experience in Snowflake

• 3+ years of experience writing SQL or any query language

• Must have at least 2 End to End project implementation experience.

• Design, Build and configure snowflake integration to meet business process and application requirements.

• Should be able to drive discussion with the client and conduct workshops

• Should be able to drive project integration deliverables and liaison with other teams

• Should be able to understand the current landscape and re-design the snowflake integration as per the change in requirements

• Good knowledge on different Snowflake features (Time travel, Fail safe, Data Streams, Tasks, Cloning, Data masking, Data sharing, etc.)

• Good exposure on Snowflake Insert, Update and Merge command.

• Good knowledge on Snowflake Stages (User Stage, Table Stage, Named Stage, External Stage)

• Good exposure on different types of snowflake tables and views.

• Experience in creating External tables Skills

• Integration experience should include building snowflake queries to bring data from SAP ECC and S4 application to a planning system.

• It is ideal to have understanding of the touchpoints with Kinaxis and Kinaxis data model to enable integration between SAP and Kinaxis

• CPI experience will be an added advantage