Experience- 8+ Years
JD:
Summary
ThoughtFocus is looking for a senior snowflake developer for our NYC and London based financial services client operating in Public/Private Loans, CLOs, and Long/Short Credit.
You will play a pivotal role in accomplishing the successful delivery of our strategic initiatives. You will be responsible for developing solutions using technologies like Snowflake, Coalesce Fivetran.
Location: Bengaluru, India
Requirements:
IT experience of 8+ years with a minimum of 3+ years of experience as a Snowflake Developer.
Design, develop, and optimize Snowflake objects such as databases, schemas, tables, views, and store procedures.
Expertise in Snowflake utilities such as Snow SQL, Snow Pipe, Stages, Tables, Zero Copy Clone, Streams and Tasks, Time travel, data sharing, data governance, and row access policy.
Experience in migrating data from Azure Cloud to Snowflake, ensuring data integrity, performance optimization, and minimal disruption to business operations.
Experience in Snow pipe for continuous loading and unloading data into Snowflake tables.
Experience in using the COPY, PUT, LIST, GET, and REMOVE commands.
Experience in Azure integration and data loading (Batch and Bulk loading).
Experience in creating the System Roles Custom Roles and Role Hierarchy in Snowflake.
Expertise in masking policy and network policy in Snowflake.
Responsible for designing and maintaining ETL tools (Coalesce Fivetran) that include extracting the data from the MS-SQL Server database and transforming the data as per Business requirements.
Extensive experience in writing complex SQL Queries, Stored Procedures, Views, Functions, Triggers, Indexes, and Exception Handling using MS-SQL Server (TSQL).
Effective communication skills and interpersonal skills.
Ability to influence and collaborate effectively with cross-functional teams.
Exceptional problem-solving abilities.
Experience in working in an agile development environment.
Experience working in a fast-paced, dynamic environment.
Good to have some prior experience or high-level understanding of hedge funds, private debt, and private equity.
Whats on offer
Competitive and above market salary.
Hybrid work schedule.
Opportunity to get exposure and technology experience in global financial markets.
Education
Bachelors degree in Computer Science / IT / Finance / Economics or equivalent.
