We are looking for a highly experienced Snowflake Migration Architect / Technical Lead / Senior Developer to lead the migration of large-scale on-premises databases and data warehouse platforms to Snowflake Cloud Data Platform . The ideal candidate must have strong hands-on Snowflake expertise, experience designing and executing complex database/data warehouse migrations, and prior experience working within the Healthcare domain . This is a senior hands-on role requiring the candidate to participate in architecture, design, development, migration planning, performance optimization, testing, cutover, and post-production stabilization.
Требования: Lead end-to-end migration of on-premises databases/data warehouses to Snowflake . Assess the existing on-prem environment, database objects, schemas, ETL processes, dependencies, data volumes, interfaces, and workloads. Define the Snowflake target architecture and migration strategy , including migration waves, cutover approach, rollback strategy, and production stabilization.
Design scalable Snowflake architecture including databases, schemas, warehouses, storage, compute, roles, security, and access controls . Perform hands-on development using Snowflake SQL, SnowSQL, Stored Procedures, Streams, Tasks, Dynamic Tables, Snowpipe, and related Snowflake capabilities . Migrate large volumes of historical and incremental data from legacy/on-prem databases into Snowflake.
Re-engineer or modernize existing ETL/ELT pipelines for the Snowfla