Snowflake Architect

JD:

Relevant Experience


(in Yrs) Must have total 10+ yrs of experience in IT and 5+ years' experience working as a Data Architect


Must Have Technical/Functional Skills
• Must have experience at least two end to end implementation of Snowflake cloud data warehouse.
• Expertise in Data modelling, ELT using snowflake, implementing complex stored Procedures and standard DWH and ETL concepts.
• Experience in Data Migration from RDBMS to cloud data warehouse
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and understanding how to use these features.
• Experience in Data Masking & Security features of snowflake
• Experience in handling Structured & semi-structured data (JSON, XML)
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Must have experience of Agile development methodologies.
• Strong written communication skills. Is effective and persuasive in both written and oral communication.
• Exposure or expertise working in health care domain will be added advantage.

Experience Required 10 + Years


Roles & Responsibilities
• Study as and TO planning along with TCS and customer stake holders
• Build solution architecture, design , reviews
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Implementation of this architecture
• Provide resolution to an extensive range of data pipeline related problems, proactively and as issues surface.
• Working with development team, customer teams during entire execution.
• Representations as architect to customer on various forums during lifecycle of project.
• Co-ordination with offshore team during project execution.


Generic Managerial Skills Co-ordination with stake holders


Representations to customer - meetings, steering committee, architecture board, technical reviews