AWS Neptune Developer

$95,000 - $120,000/Yr

TATA Consulting Services - Dallas, TX

Full-time - Senior

Dallas, TX

Professional, Scientific, and Technical Services

About the position

We are seeking an experienced AWS Neptune Developer with over 8 years of relevant experience to join our team. The ideal candidate will have a strong background in AWS Neptune, Neo4j, S3, Snowflake, and graph databases. This role involves working closely with our platform team to design and implement data extraction processes and graph schemas that meet our business needs.

Responsibilities

• 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 understand 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.
• Create 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.

Requirements

• 8+ years of experience in AWS Neptune and graph databases.
• Proficiency in Snowflake and data transformation processes.
• Experience with DBT for data modeling and transformation.
• Strong understanding of data structures and relationships in graph databases.