Data Engineer Job at Lorven Technologies, Boston, MA

Zm5mVVc4d2k4REdUN2VDQlhHSzRseEZuWFE9PQ==
  • Lorven Technologies
  • Boston, MA

Job Description

Our client seeks an Data Engineer for a long-term project in Boston, MA . Below is the detailed requirement Title: Data Engineer Location : Boston, MA (Remote) Contract : 12 Months Job Description: Bachelor's degree preferably in Computer Science, Information technology, Computer Engineering, or related IT discipline or equivalent experience with 12+ Minimum Experience Skills Needed: Snowflake cloud data warehouse and AWS S3. Strong hands-on SQL skills/ Stored procedures / writing complex queries Good knowledge of Data warehousing and all related concepts. Hands on experience in Data Ingestion from different sources Candidate must be strong in SQL Must have 4 years of Relevant experience in working with Snowflake cloud data warehouse and exposure to AWS S3. Implementing SCD Techniques like slowly changing dimensions (type1, type2 and type3). Experience in working with AWS S3 and Snowflake cloud data warehouse. Good exposure in Snowflake Cloud Architecture and SnowSQL and SNOWPIPE for continuous data ingestion. Handling large and complex data sets like JSON, ORC, PARQUET, CSV files from various sources like AWS S3. Hands-on experience in bulk loading and unloading data into Snowflake tables. Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical functions to support ETL in snowflake cloud data warehouse. Experience with performance tuning of SnowFlake data warehouse with Query Profiler, Caching and Virtual data warehouse scaling Knowledge on redshift (Good to have) Knowledge on AWS EC2, lambda Good to have python Lorven Technologies

Job Tags

Contract work,

Similar Jobs

Get It - Professional Services

Project Manager Architect - Healthcare - Remote Job at Get It - Professional Services

Are you a highly motivated and results-oriented Project Manager with a passion for healthcare architecture? Do you thrive in a collaborative environment and enjoy leading projects from concept to completion? If so, this is the perfect opportunity for you! We are seeking... 

US Foods, Inc.

Delivery Driver Job at US Foods, Inc.

 ...Delivery Driver at US Foods, Inc. summary: As a Delivery Driver for US Foods, you play a vital role in ensuring timely delivery of a wide range of food products to customers. Your responsibilities include building trust with clients while adhering to scheduled delivery... 

Hillcrest Hospital South

Phlebotomist Job at Hillcrest Hospital South

 ...setting. Consistent performance has helped the hospital be nationally recognized for patient safety. Responsibilities The Phlebotomist functions as a laboratory professional who performs specimen collection techniques or specimen collection instructions that... 

Sharp Nursing Medical Staffing

Travel Physical Therapy Assistant Job at Sharp Nursing Medical Staffing

 ...Nursing Medical Staffing is seeking a travel Physical Therapy Assistant for a travel job in Bedford, New Hampshire. Job...  ...staffing agency for Nursing, Cath Lab, Electrophysiology, Interventional Radiology, Rehab Therapy and Allied Health. We also specialize... 

Tadhana

Assistant Server Job at Tadhana

 ...Tadhana, a Michelin Guide-recognized contemporary Filipino tasting menu restaurant in NYC, is looking for experienced Assistant Servers to join our team. We are seeking hospitality-driven professionals with a minimum of 1-3 years of experience in upscale or high...