Snowflake Architect

• 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.10 + Years • 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.