Data Engineer Job at Lorven technologies, Boston, MA

OTFLTjN4dnN5Nzk0OXFQcUtNaWUreEJlK3c9PQ==
  • 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

Job Tags

Hourly pay, Contract work,

Similar Jobs

CompHealth

Physician / Surgery - Orthopedics-Spine / Pennsylvania / Permanent / Orthopedic Spine Surgeon Needed in Pennsylvania Job Job at CompHealth

 ...Wayne Wynter . Open to BE/BC candidates who have completed residency in the United States Must be fellowship trained in ortho spine General orthopedic call of 1:4 Academic affiliation Employed position H-1B visa holders welcome to apply Retirement benefits included in... 

Alter Domus

Fund Accounting Manager (Real Estate Funds) Job at Alter Domus

 ...statements, capital call notices, distribution notices, and other ad-hoc reporting as required;~ Training, reviewing and oversight of Associate Fund Accountant and Fund Accountant and Senior Fund Accountants dedicated to your assigned group of funds;~ Help advise on... 

Vensure Employer Solutions

Marine Systems Engineer - FL - On site Job at Vensure Employer Solutions

 ...Essential Duties and Responsibilities Work within a small company atmosphere with other marine engineers, naval architects, and designers to solve engineering challenges. Projects will span all different types of vessels in the maritime industry, so the role will... 

Ascension

RN- Clinical Lead Job at Ascension

 ...disability, marital status, amnesty, genetic information, carrier status or any other legally protected status or status as a covered veteran in accordance with applicable federal, state and local laws. For further information, view the poster or poster. As a... 

TaskUs

Bilingual Call Center Representative - Critical Safety Job at TaskUs

Job Description About TaskUs: TaskUs is a provider of outsourced digital services and next-generation customer experience to fast-growing technology companies, helping its clients represent, protect and grow their brands. Leveraging a cloud-based infrastructure, TaskUs...