Snowflake Designer/lead/Snowflake Data Architect

Tata Consultancy Services; Chennai District, Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services is seeking a skilled database and data engineering professional to design, develop, and optimize PL/SQL and SQL for high-volume databases. You will ensure performance, integrity, and security through tuning and best practices, while performing data analysis and modeling.

You will support batch jobs and integrations using database-centric solutions and manage AWS resources with Terraform, all within a structured SDLC and Agile framework using JIRA for tracking.

Qualifications

• Experience with PL/SQL and SQL on high-volume databases.
• Strong data analysis and data modeling capabilities.
• Knowledge of performance tuning and database security best practices.
• Familiarity with SDLC and Agile practices.

Responsibilities

• Design, develop, and optimize PL/SQL code and complex SQL for high/volume databases.
• Ensure database performance, data integrity, and security through tuning and best practices.
• Perform requirement and data analysis and perform Data Designing/modeling.
• Support batch jobs, and integrations using database centric solutions.
• Manage AWS environment, set up resources using Terraform.
• Follow SDLC processes, including design, development, testing, deployment, and documentation.
• Use JIRA for task tracking, defect management, and Agile collaboration.

Skills

PL/SQL

SQL

Data modeling

Data analysis

Performance tuning

SDLC

Agile

Tools

AWS

Terraform

JIRA

Job description

Role & responsibilities

Design, develop, and optimize PL/SQL code and complex SQL for high/volume databases

Ensure database performance, data integrity, and security through tuning and best practices

Perform requirement and data anlaysis and perform Data Designing/modeling

Support batch jobs, and integrations using database centric solutions

Manage AWS environment, set up resources using Terraform

Follow SDLC processes, including design, development, testing, deployment, and documentation

Use JIRA for task tracking, defect management, and Agile collaboration

Preferred candidate profile