Snowflake Data Engineer (W2 Only) Job at InvestM Technology LLC, Fremont, CA

QW81NTZja2RBQVZid0Vjckg0Nm9GWlFiUUE9PQ==
  • InvestM Technology LLC
  • Fremont, CA

Job Description

We are seeking a Senior Snowflake Developer. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.

Location: Hybrid

  • Sacramento, CA (3 days in office)

Visa Status:

  • USC/GC/GC-EAD/H4-EAD accepted
  • W2 only (No visa sponsorship available)
  • No 3rd party or C2C candidates

Responsibilities:

  • Design and implement features for identity and access management.
  • Implement novel query optimization, major security competencies with encryption.
  • Solve performance issues and scalability issues in the system.
  • Create, test, and implement enterprise-level apps with Snowflake.
  • Data warehousing concepts, data modeling, metadata management

Mandatory Qualifications:

  • 10 years of experience in database development
  • 5 years of experience in Snowflake development and administration
  • Bachelors degree or 7 yrs hands-on experience

Preferred Qualifications:

  • Knowledge of SQL language and cloud-based technologies
  • Profound knowledge and hands-on experience in Snowflake Platform Architecture.
  • Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.
  • Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake.
  • Extensive experience in T-SQL stored procedures and complex query development.
  • Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans.
  • Experience with productionized data ingestion and processing pipelines using Snow SQL
  • Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns.
  • Strong ability in documenting design solutions effectively.
  • Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway.
  • Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.
  • Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is a plus.

Job Tags

Similar Jobs

Lensa

Research Study Assistant III - 40 hrs/wk - Variable Shift - Novi Job at Lensa

 ...with a minimum of four (4) years research and/or healthcare experience. OR Bachelor's degree in a scientific field, Psychology, Sociology, Anthropology or related field. Additional Information Organization: Henry Ford Medical Group Department: Sleep Medicine... 

Addison Kenway.

Aesthetics Nurse Practitioner or Physician Assistant Job at Addison Kenway.

 ...Aesthetics NursePractitioner or Physician Assistant - Paramus, New JerseyJob#16718346 Our client has a wonderful opportunity for an experienced NP or PA in aesthetics. You will be offered a great compensation package including many benefits. Experience as an aesthetics... 

Fusion Medical Staffing

Travel Medical Laboratory Scientist (MT) Job at Fusion Medical Staffing

Travel Medical Laboratory Technician (MLT) - Generalist Company: Fusion Medical Staffing Location: Facility in Arlington, TX Job Details Fusion Medical Staffing is seeking a skilled Medical Laboratory Technician for a 13 week travel assignment in Arlington, TX. As a member... 

Allied Universal®

Security Guard Job at Allied Universal®

 ...Job Description Allied Universal, North Americas leading security and facility services company, offers rewarding careers that provide you a sense of purpose. While working in a dynamic, welcoming, and collaborative workplace, you will be part of a team that contributes... 

Med-Trans Corporation

VFR Helicopter Pilot Med-Trans EG Job at Med-Trans Corporation

 ...your passion is flying and you want to work in an environment where every second counts, contact us today!Were hiring a Helicopter Pilot to provide medical air transportation services to Med-Trans customers. Safety isa key pillar of ourservices! This posting is...