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.
What's on offer
- Competitive and above market salary.
- Hybrid work schedule.
- Opportunity to get exposure and technology experience in global financial markets.
Education
- Bachelor's degree in Computer Science / IT / Finance / Economics or equivalent.
Read Full Description