Overview
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
Collaboration
Data Structure
Data Extraction
Amazon Web Services
Amazon S3
Amazon Neptune
ELT
Snow Flake Schema
Job Details
AWS Neptune Expert
Identify and select the data sources, Tables, Relationships between different entities in Snowflake.
Establish a secure connection between Snowflake and AWS Neptune via AWS service stack by securing extracted data storing in S3 for transformation before loading into AWS Neptune.
Collaborate with current platform team to understanding data structure to implement data extraction processes from Snowflake.
Load the extracted data into AWS S3 for graph model transformation.
Analyze the data, relationships, entities mappings to determine the necessary graph schema.
Design nodes, edges, and properties for the graph schema using entities definitions.
Implement the graph schema in AWS Neptune.
Creating indexes to improve query performance
Review and refine schema based on query patterns and performance based on mutually agreed design
Define the transformation logic using DBT.
Develop DBT models for data transformation.
Schedule and automate the ELT pipeline using DBT and Snowflake.
Identify and select the data sources, Tables, Relationships between different entities in Snowflake.
Establish a secure connection between Snowflake and AWS Neptune via AWS service stack by securing extracted data storing in S3 for transformation before loading into AWS Neptune.
Collaborate with current platform team to understanding data structure to implement data extraction processes from Snowflake.
Load the extracted data into AWS S3 for graph model transformation.
Analyze the data, relationships, entities mappings to determine the necessary graph schema.
Design nodes, edges, and properties for the graph schema using entities definitions.
Implement the graph schema in AWS Neptune.
Creating indexes to improve query performance
Review and refine schema based on query patterns and performance based on mutually agreed design
Define the transformation logic using DBT.
Develop DBT models for data transformation.
Schedule and automate the ELT pipeline using DBT and Snowflake.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.