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.
