Purple Drive LLC
AWS Neptune Expert
Identify and select the data sources, tables, and relationships between different entities in Snowflake.
Establish a secure connection between Snowflake and AWS Neptune via the AWS service stack, securing extracted data stored in S3 for transformation before loading into AWS Neptune.
Collaborate with the current platform team to understand data structure and implement data extraction processes from Snowflake.
Load the extracted data into AWS S3 for graph model transformation.
Analyze the data, relationships, and entity mappings to determine the necessary graph schema.
Design nodes, edges, and properties for the graph schema using entity definitions.
Implement the graph schema in AWS Neptune.
Create indexes to improve query performance.
Review and refine the 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.
Dice Id: 91018020
Position Id: PDT - 10104-11239-1767907803
Posted 1 day ago
About Purple Drive Technologies LLC Founded in 2007, Purple Drive started as a tech solutions firm and has grown into a full-service consulting and talent partner. We help businesses navigate complex technology challenges while connecting top professionals with career-defining opportunities. We believe in transforming businesses through smart IT solutions and empowering technologists to grow their expertise through challenging projects and meaningful partnerships. Built on over 20 years of trusted relationships, we create success stories for both our clients and the talented professionals who drive innovation forward.
#J-18808-Ljbffr
Identify and select the data sources, tables, and relationships between different entities in Snowflake.
Establish a secure connection between Snowflake and AWS Neptune via the AWS service stack, securing extracted data stored in S3 for transformation before loading into AWS Neptune.
Collaborate with the current platform team to understand data structure and implement data extraction processes from Snowflake.
Load the extracted data into AWS S3 for graph model transformation.
Analyze the data, relationships, and entity mappings to determine the necessary graph schema.
Design nodes, edges, and properties for the graph schema using entity definitions.
Implement the graph schema in AWS Neptune.
Create indexes to improve query performance.
Review and refine the 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.
Dice Id: 91018020
Position Id: PDT - 10104-11239-1767907803
Posted 1 day ago
About Purple Drive Technologies LLC Founded in 2007, Purple Drive started as a tech solutions firm and has grown into a full-service consulting and talent partner. We help businesses navigate complex technology challenges while connecting top professionals with career-defining opportunities. We believe in transforming businesses through smart IT solutions and empowering technologists to grow their expertise through challenging projects and meaningful partnerships. Built on over 20 years of trusted relationships, we create success stories for both our clients and the talented professionals who drive innovation forward.
#J-18808-Ljbffr