Snowflake Architect
Bengaluru, Pune, Chennai, HyderabadFull-time8–12 yrsPosted 4 weeks ago
Leadership data science role at Ascendion in Bengaluru, Pune and 2 more cities. Needs 8–12 years and Class 12.
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
What you need
- Snowflake
- SQL
- Python
- Informatica
- Hadoop
- AWS
Good to have
- LLMs
- Kafka
- VBA
- Airflow
- SQL Server
- ETL