Must Have Technical/Functional Skills
Minimum two end-to-end Snowflake cloud data warehouse implementations.
Expertise in data modeling, Snowflake ELT, complex stored procedures, and standard data warehouse and ETL concepts.
Experience migrating data from relational databases to a cloud data warehouse.
Advanced Snowflake expertise including resource monitors, role-based access control, virtual warehouse sizing, query performance tuning, zero-copy cloning, and Time Travel.
Experience with Snowflake Cortex AI capabilities for building and integrating AI-powered data and analytics solutions.
Experience in Data Product design and semantic model creation to enable governed, reusable, and business-aligned data consumption.
Working knowledge of Apache Iceberg and open table formats, including their use with modern cloud data platforms.
Experience with Snowflake data masking and security capabilities.
Experience handling structured and semi-structured data, including JSON and XML.
Experience with AWS or Azure storage and data management technologies, including Amazon S3 and Azure Data Lake Storage.
Experience working in Agile development methodologies.
Strong written and verbal communication skills, with the ability to communicate effectively and persuasively.
Roles & Responsibilities
Assess the current-state environment and lead target-state planning with TCS and customer stakeholders.
Define the Snowflake solution architecture and detailed design, and lead architecture and design reviews.
Design processes supporting data transformation, data structures, metadata, dependencies, and workload management.
Guide and support implementation of the approved Snowflake architecture.
Resolve a broad range of data pipeline issues proactively and as they arise.
Work closely with development and customer teams throughout the project lifecycle.
Represent the architecture function in customer meetings, steering committees, architecture boards, and technical reviews.
Coordinate with the offshore team during project execution.
Generic Managerial Skills, If any
Strong stakeholder coordination and customer-facing communication.
Ability to represent the solution confidently in governance forums and technical reviews.
Effective coordination with onsite, customer, development, and offshore delivery teams.
Key Words to search in Resume
Snowflake; Cloud Data Warehouse; Technical architect , Data Architect; Data Modeling; ELT; ETL; Stored Procedures; Data Migration; RBAC; Data Masking; Data Security; Virtual Warehouse Sizing; Query Performance Tuning; Zero-Copy Clone; Time Travel; JSON; XML; Amazon S3; Azure Data Lake Storage; Data Pipelines; Agile; TOGAF
Pre-Screening Questionnaire
In what capacity have you worked with Snowflake, and for how long?
How many end-to-end Snowflake projects have you executed?
Why would you use Snowflake for a cloud data warehouse solution?
Are you Snowflake certified?
Please explain Snowflake architecture.
What is Snowflake Time Travel, and how have you used it?
How is data security managed in Snowflake?
Have you worked as an architect with any other technology, and do you hold architecture certifications?