Role: ETL Snowflake Developer
Location: Danbury, CT /New Jersey
JD:
Job Requirements: SSIS, MS SQL Server, Programming Development, Querying SQL Database, SQL Query Script, ETL Pipeline, Design Document
Primary:
Snowflake, data lake and data pond expertise required.
Expert knowledge in Snowflake, data lake, data pond PL SQL and SSIS position supporting database related development ETL development skills Experience in SSIS packages from multiple sou rces and scheduling the jobs
Should have skills on PL SQL Stored Procedures, Views, triggers etc.
Data Warehouse concepts such as Fact Dimensions SQL Stored Procedure performance tuning Develop complex queries and stored procedures using PL SQL Ex perience in SSIS packages SSIS development,
Experience in SSIS packages from multiple sources and scheduling the jobs
Secondary: .
Net knowledge Soft Skills: The Generic skills we use for everyone can be written like: Communication Skills, Interper sonal skills Team Coordination, Client interaction,
Team Player Offshore Work Timing: 10 AM to 7:30PM IST.
Extended hours as needed. Commitment of min 2 years work in the account. Familiar with Agile model Main areas of responsibility:
# Develop complex queries and stored procedures using PL SQL # SSIS Development # Evaluate large and complex data sets # Assist application developers in refining complex queues and performance tuning
# Crea te tables, assign permissions, import data, perform app configurations, etc.
# Write and maintain technical documentation # Manage source code versioning and deployments
# Stay knowledgeable with the latest advances in SQL Se rver and other data technologies
# Perform Code reviews Minimum Qualifications:
# Good development experience with Microsoft SQL Server, stored procedures and complex queries
# Working knowledge of the P&C Insurance domain
# Demonstrate skill and ability in interfacing programmatically with a variety of enterprise systems
# Familiarity with source code management systems.