Snowflake Data Engineer

Location: PAN India

ROLE SUMMARY

Snowflake Data Engineer to design, build and optimise cloud data warehousing and ELT solutions on the Snowflake Data Cloud for BFSI clients. The role focuses on scalable data pipelines, dimensional/data-vault modelling, migration from legacy warehouses (Teradata/Oracle/Exadata/GreenPlum) and cost-optimised, well-governed platforms enabling analytics, data sharing and monetisation.

KEY RESPONSIBILITIES

Strong Experience and understanding of Data warehouse, Data Lake platforms architecture and design aspects

Design and build scalable ELT pipelines and data models on Snowflake using SQL, DBT and Python.

Develop data warehousing solutions (star schema, SCD, Data Vault) supporting enterprise analytics and reporting.

Implement Snowflake-native features Snowpipe, Streams & Tasks, Time Travel, Data Sharing and Cortex AI functions.

Lead / support migrations from legacy platforms (Teradata, Oracle, Exadata, GreenPlum, Hadoop) to Snowflake.

Optimise workloads through warehouse sizing, query tuning, clustering and cost-management best practices.

Implement data security and governance dynamic masking, RBAC, row/column-level security and secure data sharing.

Build CI/CD and automation for Snowflake deployments using DBT, Liquibase and Git-based pipelines.

Integrate Snowflake with ETL tools (Informatica, DataStage, Matillion) and BI tools (Power BI, Tableau).

TECHNICAL SKILLS

Core / Must-Have

Snowflake Data Cloud (multi-cloud: AWS/Azure/GCP)

SQL, PL/SQL, Python; DBT for transformations

ELT pipeline design & data modelling (Star, SCD, Data Vault)

Snowpipe, Streams & Tasks, Time Travel, Data Sharing

Warehouse sizing, query tuning & cost optimisation

Data security & governance (masking, RBAC)

Complementary / Good-to-Have

Migration from Teradata / Oracle / Exadata / GreenPlum

ETL tools – Informatica, IBM DataStage, Matillion

CI/CD – DBT, Liquibase, Git-based deployments

BI & visualisation – Power BI, Tableau, Streamlit

Cloud services – AWS S3, Azure, Snowpark

Snowflake Cortex AI / GenAI for data