Snowflake Architect & Lead @ NYC NY - Onsite - Hybrid

Greetings,

 

We have the below requirement with our Client. Kindly go through the JD below and let me know your interest.

 

 

Position: Snowflake Architect & Lead

Location: NYC NY – Onsite – Hybrid

Client: Genpact

 

Must have 12+ years of IT experience.

 

No OPT / CPT / H1-T / GC EAD

 

Passport Number (for H1/H4/L2) & Active LinkedIn Must for Submission

 

LinkedIn created after 2017 will not FLY.

 

 

Job Description:

Role & location

Hands on Snowflake architect and lead, who can act as a lead for a Offshore team as well, based out of NY.

 

Responsibilities

• Enhance an existing implementation in Snowflake to ingest and publish additional datasets to consumers.
• Design and implement schema – tables, views – across each of the Snowflake layers and any SQL based transformation that meets performance requirements for accessing data.
• Design and implement Snowflake entitlements to secure the data, through Snowflake policies and data models within the schema (row and column-based entitlements, dynamic masking of columns for a specific period within the database), ensuring performance requirements are met.
• Write Snowflake stored procedures and Snowflake SQLs
• Lead an offshore team, assisting them as well as required.
• Coordinate with other stakeholders like product owners and data source system owners to understand the requirements and the data.
• Write SQL to test data transformation and migration.

 

Having experience of

• Snowflake data architecture composed of four layers – Raw, Staging, Core and Consumer
• Extract, Load, transform implementation using Snowflake data architecture.
• Implementing Data Quality framework for Snowflake
• Row and Column level security in Snowflake for currently available data
• Implementing with CI/CD pipelines
• Nice to have – ETL Experience in sourcing data from REST APIs to Snowflake
• Nice to have – ETL Experience in sourcing data from databases to Snowflake.
• Nice to have – Human resource data sets experience.

 

 

 

Thanks & Regards

Srujan Burra

Email: srujan@sourcemantra.com

Source Mantra Inc | www.sourcemantra.com

295 Durham Ave, Suite # 201, South Plainfield, NJ 07080