HamburgerMenu
hirist

State Street - Data Engineer - Snowflake DB

hirist.tech
Bangalore
5 - 9 Years

Posted on: 19/11/2025

Job Description

Note : If shortlisted, you will be invited for initial rounds on 6th December'25 (Saturday) in Bangalore


Role Summary & Role Description :


- We are seeking a talented Senior Software Engineer to join our agile team.


- The successful candidate will play a crucial role in ensuring the quality and reliability of our software products, with a focus on developing Azure-based applications, data warehouse and ETL backend systems.


- Proficiency in Data Warehousing and Snowflake is essential for this role.


- Candidate must have minimum of 8 years of relevant experience in Data Warehousing and Database application development.


- Candidate must have hands on experience in Snowflake and Azure.


- Analyze, Design and Code snowflake objects and views.


- Create Database Views/materialized views, Indexes, Partitions.


- Experience in Shell scripting and Autosys/Control-M/Cron scheduling.


- Ability to communicate with Business users, understand and Analyze requirements and Use Cases.


- Experience working in Agile Teams.


- Proven problem solving, communication, interpersonal and analytical skills.


- Ability to work both independently as well as within a team.


Core/Must have skills :


- Good knowledge in Data Warehouse concepts and different schema types like Star and Snowflake


- Strong experience in writing complex queries, performance tuning, query optimization and debugging.


- Minimum 8 years working experience in Snowflake and good knowledge on Snowpipe, DBT


- Experience in working with Snowflake.


- Hands-on experience in bulk loading and unloading data into Snowflake tables using COPY command.


- Handling large and complex data sets like JSON, ORC, PARQUET CSV files from various sources like AWS S3.


- Good exposure in Snowflake Cloud Architecture, SnowSQL and SNOWPIPE for continuous data loading.


- Good communication skills, problem solving skills and ability to analyses quickly and come-up with an efficient industry standard solution for a given problem


Good to have skills :


- Good knowledge on Oracle database and Proficient in SQL Performance tuning.


- Good knowledge on BigData and Spark


- Good knowledge on Databricks


Work Schedule :


- On-premise / Hybrid


Keywords (If any) :


- Snowflake, Data Warehouse, Databricks


info-icon

Did you find something suspicious?