Snowflake Designer/Lead

Job description

Role & responsibilities Snowflake Designer/Lead Desired Competencies (Technical/ Behavioral Competency) Must-Have\\\\ (Ideally should not be more than 3-5) Snowflake Designing, Data Analysis/Modeling/Designing, Data Warehouse, ETL concepts Good-to-Have AWS, Terraform, Python SN Responsibility of / Expectations from the Role 1 Design, develop, and optimize PL/SQL code and complex SQL for high/volume databases 2 Ensure database performance, data integrity, and security through tuning and best practices 3 Perform requirement and data anlaysis and perform Data Designing/modeling 4 Support batch jobs, and integrations using database centric solutions 5 Manage AWS environment, set up resources using Terraform 5 Follow SDLC processes, including design, development, testing, deployment, and documentation 6 Use JIRA for task tracking, defect management, and Agile collaboration 7 8 9 10 11 Details For Candidate Briefing\\\\ (It should NOT contain any confidential information or references) About Client: (Please highlight domain, any ranking indicating size of /recognition for the client. It helps sell the role to prospective candidates) Sony Pictures Entertainment Inc. is an American entertainment company that produces, acquires, and distributes filmed entertainment through multiple platforms. Through an intermediate holding company called Sony Film Holding Inc., it is operated as a subsidiary of Sony Entertainment Inc., which is itself a subsidiary of the multinational technology and media conglomerate Sony Corporation. Based at the Sony Pictures Studios lot in Culver City, California, it encompasses Sony's motion picture, television production and distribution units. USP of the Role and Project: (Why a candidate would be keen to apply for this role in this project what there for me?”. Please highlight the USP of the role in terms of nature of the project, technology involved, growth prospect, onsite opportunity, opportunity for learning and certifications etc. It helps sell the role to prospective candidates) This is an important project within the customer’s Production and Studio Support portfolio where Production Finance team will be consuming operational and analytical reports out of Snowflake. Preferred candidate profile Snowflake, Data Warehouse, Data Analysis & Data Modeling concepts, ETL concepts, AWS, Terraform, Python Desired Competencies (Technical/ Behavioral Competency) Must-Have\\\\ (Ideally should not be more than 3-5) Snowflake Designing, Data Analysis/Modeling/Designing, Data Warehouse, ETL concepts Good-to-Have AWS, Terraform, Python SN Responsibility of / Expectations from the Role 1 Design, develop, and optimize PL/SQL code and complex SQL for high/volume databases 2 Ensure database performance, data integrity, and security through tuning and best practices 3 Perform requirement and data anlaysis and perform Data Designing/modeling 4 Support batch jobs, and integrations using database centric solutions 5 Manage AWS environment, set up resources using Terraform 5 Follow SDLC processes, including design, development, testing, deployment, and documentation 6 Use JIRA for task tracking, defect management, and Agile collaboration Details For Candidate Briefing\\\\ (It should NOT contain any confidential information or references) About Client: (Please highlight domain, any ranking indicating size of /recognition for the client. It helps sell the role to prospective candidates) Sony Pictures Entertainment Inc. is an American entertainment company that produces, acquires, and distributes filmed entertainment through multiple platforms. Through an intermediate holding company called Sony Film Holding Inc., it is operated as a subsidiary of Sony Entertainment Inc., which is itself a subsidiary of the multinational technology and media conglomerate Sony Corporation. Based at the Sony Pictures Studios lot in Culver City, California, it encompasses Sony's motion picture, television production and distribution units. USP of the Role and Project: (Why a candidate would be keen to apply for this role in this project – “what there for me?”. Please highlight the USP of the role in terms of nature of the project, technology involved, growth prospect, onsite opportunity, opportunity for learning and certifications etc. It helps sell the role to prospective candidates) This is an important project within the customer’s Production and Studio Support portfolio where Production Finance team will be consuming operational and analytical reports out of Snowflake.