Snowflake Developer

We are looking for a Senior Snowflake Engineer to lead the design, build and delivery of our client's Teradata-to-Snowflake migration. You will own end-to-end pipeline architecture using IDMC, optimise performance and cost at scale, and ensure data quality, security and governance across the programme. This is a high-impact, client-facing role within a fast-paced, cross-functional delivery team operating in the BFSI domain., · Lead the Teradata * Snowflake migration lifecycle: assessment, planning, execution and cutover readiness.

· Design Snowflake data models and objects; architect and build ETL/ELT pipelines using IDMC (preferred).

· Optimise performance and cost: warehouse sizing, clustering/partitioning and query tuning.

· Implement Snowflake capabilities including Snowpipe, Streams/Tasks and Time Travel.

· Manage secure access: RBAC, encryption, storage integrations and external stages.

· Rewrite and optimise Teradata SQL; convert Teradata-specific functions to Snowflake equivalents.

· Automate operational tasks using Python and/or Shell scripting.

· Perform source-to-target data reconciliation and validate transformation logic.

· Document solutions, data flows and design decisions; communicate progress to stakeholders.

· Strong Snowflake architecture expertise and hands-on SQL skills (performance tuning and optimisation).

· Proven Teradata SQL knowledge including utilities, functions and migration/conversion experience.

· Solid background in data warehousing and ETL/ELT design; hands-on IDMC experience preferred.

· Deep knowledge of Snowflake features: Snowpipe, Streams/Tasks, Time Travel/Cloning, micro-partitions, stages, file formats and RBAC.

· Cloud platform experience: Azure, AWS or GCP.

· Scripting proficiency in Python and/or Shell for automation and pipeline support.

· CI/CD and DevOps practices applied to data pipelines.

Nice to have:

· BFSI domain experience.

· Informatica PowerCenter background.

· SnowPro certification.