| Greetings.. Our client is seeking a Snowflake Architect for an Onsite role. Please let me know your interest. Position : Snowflake Architect Location : New York Duration : Contract 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.
If interested, then please share your updated resume. Thanks & Regards, Parth Rastogi US IT Executive VBeyond Corporation +1-908-389-6088 parthr@vbeyond.com
linkedin.com/in/parth-rastogi-770125155 Amwell Commons,, 390 Amwell Road, Hillsborough, New Jersey, USA – 088 44 www.vbeyond.com | 