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?
Salary Range: $180,000 - $220,000 a year
