Snowflake Technical Architect

Tata Consultancy Services; Bengaluru; On-site; INR 3,000,000 - 5,400,000; Full time

Job summary

Tata Consultancy Services Bengaluru is seeking an experienced Snowflake Technical Architect to design and lead enterprise-scale data platform implementations. You will focus on Snowflake Data Warehouse, data migration projects, and Oracle to Snowflake modernization to ensure scalability, security, and performance.

The role requires hands-on expertise in Snowflake architecture, SQL/PLSQL, data modeling, and ETL/ELT tooling, with a track record of guiding cross-functional teams and delivering

Qualifications

• Experience designing scalable Snowflake data warehouses.
• Proven Oracle DB to Snowflake migration experience.
• Strong SQL/PLSQL/SnowSQL and performance tuning.
• Familiarity with ETL/ELT tools and data modeling.
• Ability to lead enterprise-scale data modernization projects.

Responsibilities

• Design and implement scalable data warehouse solutions using Snowflake.
• Lead Oracle Database to Snowflake migration initiatives, including assessment, strategy, and execution.
• Define data architecture, data modeling, ETL/ELT frameworks, and best practices.
• Develop and optimize Snowflake objects such as databases, schemas, tables, views, tasks, streams, and stored procedures.
• Collaborate with business stakeholders, data engineers, and application teams to define data solutions.
• Implement performance tuning, cost optimization, security, governance, and access control mechanisms.
• Design and manage data integration pipelines using ETL/ELT tools.
• Provide technical leadership, architecture guidance, and mentoring to development teams.
• Ensure data quality, reliability, and compliance with enterprise standards.

Skills

Snowflake Architecture

Oracle Migration

SQL/PLSQL/SnowSQL

Data Modeling

Cloud Platforms

Data Governance/Security

Stakeholder Management

Tools

Informatica

Matillion

Talend

Job description

We are seeking an experienced Snowflake Technical Architect with strong expertise in Snowflake Data Warehouse, Data Migration, and Oracle to Snowflake modernization projects. The ideal candidate will be responsible for architecting, designing, and leading enterprise-scale data platform implementations while ensuring scalability, security, and performance optimization.

Key Responsibilities

• Design and implement scalable data warehouse solutions using Snowflake.
• Lead Oracle Database to Snowflake migration initiatives, including assessment, strategy, and execution.
• Define data architecture, data modeling, ETL/ELT frameworks, and best practices.
• Develop and optimize Snowflake objects such as databases, schemas, tables, views, tasks, streams, and stored procedures.
• Collaborate with business stakeholders, data engineers, and application teams to define data solutions.
• Implement performance tuning, cost optimization, security, governance, and access control mechanisms.
• Design and manage data integration pipelines using ETL/ELT tools.
• Provide technical leadership, architecture guidance, and mentoring to development teams.
• Ensure data quality, reliability, and compliance with enterprise standards.

Required Skills

• Strong experience in Snowflake Architecture and Development.
• Proven experience in Oracle Database to Snowflake Migration projects.
• Expertise in SQL, PL/SQL, SnowSQL, and database performance tuning.
• Experience with Data Modeling (Dimensional & Data Vault concepts).
• Knowledge of ETL/ELT tools such as Informatica, Matillion, Talend, or equivalent.
• Experience with cloud platforms such as Azure, AWS, or GCP.
• Understanding of data governance, security, and access management.
• Strong analytical, problem-solving, and stakeholder management skills.

Preferred Skills

• Snowflake Certifications.
• Experience with Python, Spark, or Data Engineering frameworks.
• Knowledge of CI/CD, DevOps, and Agile methodologies.
• Experience in large-scale enterprise data modernization programs.