Greetings from TCS!!
TCS is hiring for AWS Neptune
Required experience range : 6 to 10 years
Job location : Hyderabad
Functional Skills : AWS Neptune Database, AWS Neptune Analytics, S3, Snowflake, Graph database, AWS Cloud
Roles & 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 understanding data structure to implement data extraction processes from Snowflake.
- Load the extracted data into AWS S3 for graph model transformation.
- Analyse 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.
Thank you
Bodhisatwa Ray