Employment Opportunity

Job Title: DATABASE DEVELOPER/ARCHITECT

Job Code: GW-10162310395441

Salary Range: $120K

Job Location:

City: New York State: NY

Job Description:

Minimum Qualifications
Demonstrate expertise in Snowflake data modelling and ELT using Snowflake SQL, implementing 
complex stored procedures and best practices with data warehouse and ETL concepts designing, 
implementing and testing cloud computing solutions using Snowflake technology
Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, 
virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand 
how to use these features
Experience with data security and data access controls and design creating, monitoring and 
optimization of ETL/ELT processes (Talend, Informatica) migrating solutions from on-premises to 
public cloud platform
Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and 
troubleshoot
Strong development experience in Snowflake.
Working experience on Data Warehousing and Business Intelligence projects and having very good 
understanding on Data Modeling and Methodologies (Enterprise Transactional Data Model (OLTP) 
and Dimensional modeling. Well versed with principles, techniques and best practices of data 
modeling).
Advanced proficiency with SQL for generation and extraction of data for use in analytics and 
reporting
Experience in closely working with application teams and managing all the DB related activities 
such as DB modeling, design, development, maintenance and support
Strong Skills in Relational Databases including database design, writing complex queries and 
stored procedures, performance tuning
Experience in integration of various data sources like DB2, Sybase, SQL Server, MemSQL, 
Snowflake.
Minimum of a Bachelor’s degree from an accredited higher learning institution in data science, 
computer science, information technology, engineering, or mathematics
Preferred Qualifications/ Skills
Knowledge about DevOps implementation in Data space
Financial Services experience will be a strong plus
Ability to learn quickly and pick up new techniques and/or technologies
Excellent interpersonal skills and professional approach
Strong analytical and problem-solving skills