Dear Customers,
Role: Snowflake Architect & Lead Location: New York, NY (day 1 onsite) Hands on Snowflake architect and lead. 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.
|
Comments
Post a Comment
Thanks