Job Description

Job Profile :

Snowflake Database Administrator

Job Location :

Bangalore

Experience Required :

9-10 yrs

:

- Design and implement scalable Data Warehouse solutions using Snowflake as the core platform.


- Understand the difference between Snowflake and traditional data warehouse system


- Develop and optimize complex SQL queries for analytical workloads, reporting, and data transformation.


- Build and maintain ELT/ETL pipelines using Snowflake-native features and external orchestration tools.


- Apply dimensional modeling techniques (Star/Snowflake schemas) to support BI and analytics use cases.


- Perform query profiling, performance tuning, and cost optimization in Snowflake.


- Implement and manage Snowflake objects including tables, views, materialized views, streams, tasks, UDFs and Stored procedures.


- Ensure data quality, lineage, and governance across the data lifecycle.


- Collaborate with cross-functional teams to understand data requirements and translate them into efficient data models and pipelines.


- Troubleshoot and resolve issues related to data ingestion, transformation, and query performance.


- Stay current with Snowflake features such as Time Travel, Zero Copy Cloning, Search Optimization, and Streams/Tasks.