Snowflake Architect

Ascendion·Bengaluru

Pay not stated8–12 yrsFull-time

Apply on Ascendion's site Track your applications and see your fit: start free

Read from the company's own careers page; you apply on their site.

How well do you fit this job?

Upload your resume to see each requirement checked against your profile, in under a minute.

Check my fit

Hard to read?

About the role

You will own end-to-end solutioning for client engagements that involve migrating legacy data warehouses (Teradata, Oracle Exadata, Netezza, SQL Server, Hadoop) and ETL platforms (Informatica, DataStage, Ab Initio, SSIS) onto Snowflake, and modernizing transformations using ELT tooling such as dbt. This is a hands-on, client-facing role.

What you'll do

Own end-to-end target-state Snowflake architecture for enterprise migration and modernization engagements, including landing zone, RBAC, data sharing
Lead current-state assessments of legacy Teradata, Oracle, Netezza, SQL Server, and Hadoop estates; build workload heat maps and migration wave plans
Define migration patterns (lift-and-shift, re-platform, re-engineer) and decide the right approach per workload based on TCO, risk, and business value
Architect ELT pipelines on Snowflake using dbt or comparable transformation tooling — establish project structure, model layering (staging, intermediate, marts)
Design ingestion and transformation frameworks using Snowpark, Streams & Tasks, Dynamic Tables, and Snowpipe for batch, micro-batch, and streaming sources