Purple Drive Technologies LLC
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr