Sr. Data Warehouse (ETL) DeveloperClient of Maven Companies Inc. • Fairfield, CA, United States

No longer accepting applications

Sr. Data Warehouse (ETL) Developer

Client of Maven Companies Inc. • Fairfield, CA, United States

13 hours ago

Job type

Full-time

Job description

Top Requirements

(Must haves)

Senior Level – 8-10 years of experience
Healthcare background

Does NOT want to see :

Informatica

DataStage

BI Developers

DOES want to see :

10+ years of Experience

Has Built a Data Warehouse from scratch using SSIS and Advanced SQL

SSIS

Advanced SQL (T-SQL) :

Complex Joins

Performance Tuning and Debugging

Sub Queries

Common Table Expressions

How to use different types of Indexes

Understanding differences with Key types

How to use different Operators within Data Tables

Data Warehousing

How to use different Dimension Tables

How to use different Fact Tables

Snowflake

Data Modeling

STAR Schema

Kimball Architecture

Technical Requirements : -

SQL :

Strong understanding of complex joins

Performance tuning and debugging skills

Sub queries

Common table expression

ETL / ELT :

Experience with SSIS

End-to-end data loading and extraction in data warehousing

How do build a data warehouse from scratch (including data modeling techniques) how do we design table how do we come up with ETL

Data Architecture :

Familiarity with STAR schema and Snowflake

Understanding of Kimball methodology

Experience with different fact and dimension tables

Performance tuning strategies for large datasets

Data storage strategies for large-scale data

Data Modeling :

Experience in data modeling and ELT architecture

Understanding of subject areas created

Tools & Languages :

Qlik Compose (willing to train)

.NET or Python (preferred)

Create a job alert for this search

Etl Developer • Fairfield, CA, United States

Related jobs

RN Informatics Analyst II - Epic (Beacon - Oncology) - Informatics Clinical and Business Training - Full Time - 8 Hour - Days

John Muir Health • Walnut Creek, CA, United States

Full-time

The RN Informatics Analyst II - Epic (Beacon) supports assigned application user group(s) to help users leverage information technology to improve operational efficiency. He / She develops, delivers, ...Show more

Last updated: 23 days ago • Promoted

Sr Data Center Engineer (Only w2 locals to California required) (Fairfield)

Tek Leaders Inc • Fairfield, CA, United States

Temporary

Job Title : Sr Data Center Engineer.Duration : 3 month contract possibility to extend.Note : on-prem data center expertise required. These are core, non-negotiable technical capabilities required to p...Show more

Last updated: 1 day ago • Promoted

Data Engineer

Perfict Global, Inc. • Concord, CA, United States

Full-time

Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professi...Show more

Last updated: 30+ days ago • Promoted

Business System Analyst

Atika Technologies • Walnut Creek, CA, United States

Full-time

Please share profiles for below C2H.Job Title : Business Systems Analyst.Location : Sacramento, CA or Walnut Creek, CA (Hybrid) Only Local. Duration : (3 to 6 Months CTH Role).Experience : Minimum of 3 ...Show more

Last updated: 30+ days ago • Promoted

Sr Java Developer

Pi-Square Technologies LLC • Walnut Creek, CA, United States

Full-time +1

Quick Apply

Job Description : Java / J2EE technologies, Cloud-native development on AWS Hands-on experience building serverless applications (...Show more

Last updated: 2 days ago

Tech Lead, Android Core Product - Vacaville, USA

Speechify • Vacaville, CA, United States

Full-time

The mission of Speechify is to make sure that reading is never a barrier to learning.Over 50 million people use Speechify's text-to-speech products to turn whatever they're reading - PDFs, books, G...Show more

Last updated: 25 days ago • Promoted

Data Center Engineer

MatchPoint • Walnut Creek, California, United States

Full-time

Data Center Engineer – Infrastructure, Virtualization & Automation.Location : Phoenix, AZ / Walnut Creek, CA (Relocation required prior to full-time conversion. other locations may be considered dur...Show more

Last updated: 1 day ago • Promoted

Core MySQL Developer

Syntricate Technologies • Walnut Creek, CA, United States

Full-time

Hybrid - 2 days in office required.Walnut Creek / Folsom, CA - only local.MYSQL, Oracle, Database Migration and maintenance. Its oracle to MySql migration project.Strong understanding of both Oracle...Show more

Last updated: 30+ days ago • Promoted

Lead Programmer Analyst

Partnership HealthPlan of California • Fairfield, CA, United States

Full-time

To lead and participate in the development of complex software systems and programs at.Collaborates with the IT Director in the analysis, design, programming utilizing. Works with IT Director and te...Show more

Last updated: 25 days ago • Promoted

Engineer

Sunrise Systems • Vacaville, California, United States

Full-time

Quick Apply

These positions will be half in Vacaville, CA and half in Rocklin, CA.Months (Possible Extension or Conversion).LOCAL CANDIDATES ONLY • • Hybrid role. The roles will be onsite once per week and the re...Show more

Last updated: 30+ days ago

Head of Data Analytics (Walnut Creek)

Confidential • Walnut Creek, CA, United States

Full-time

Innovative provider of change order communication tools for the construction industry.The Company is seeking a Data Analytics Lead to play a pivotal role in the company's growth and success.The suc...Show more

Last updated: 1 day ago • Promoted

Sr. Salesforce Developer

United IT Solutions • Concord, CA, United States

Full-time

Design, develop, test, and deploy customized Salesforce solutions, leveraging.Apex, Visualforce, LWC (Lightning Web Components), and JavaScript. Sales Cloud, Service Cloud, and Marketing Cloud.Imple...Show more

Last updated: 22 days ago • Promoted

Senior Storage Engineer : Enterprise SAN / NAS & Cloud

Largeton Group • Walnut Creek, CA, United States

Full-time

A leading information services provider is looking for a Senior Storage Engineer in Walnut Creek, CA.This role involves managing and optimizing enterprise storage solutions, with a strong focus on ...Show more

Last updated: 3 days ago • Promoted

Warehouse Laborer

Essel • Fairfield, CA, US

Full-time

Quick Apply

Join the Essel team as a Warehouse Laborer and be part of a dynamic and growing company.As a Warehouse Laborer, you will be responsible for performing various tasks in a warehouse setting to suppor...Show more

Last updated: 30+ days ago

Senior Business Systems Analyst

Pet Food Express • Concord, CA, United States

Full-time

We are seeking a Senior Business Systems Analyst who thrives at the intersection of business process, data, and technology. This role bridges the gap between business partners and technical teams—he...Show more

Last updated: 25 days ago • Promoted

Travel Nurse RN - Labor and Delivery - $3,337 per week

Stability Healthcare • Vacaville, CA, United States

Full-time

Stability Healthcare is seeking a travel nurse RN Labor and Delivery for a travel nursing job in Vacaville, California.Job Description & Requirements. Stability Healthcare is looking for a L&D RN co...Show more

Last updated: 30+ days ago • Promoted

Business Intelligence Data Engineer

Pacific Service Credit Union • Concord, CA, United States

Full-time

Working for Pacific Service Credit Union.That includes our members, our employees and the communities we serve.We hire energetic and enthusiastic people who want to work as part of our team.Health ...Show more

Last updated: 25 days ago • Promoted

Medical Director

National Veterinary Associates • Vacaville, CA, US

Full-time

Medical Director – Vacaville Animal Care Center.Compensation : Base salary up to $150,00-$180,000 with production bonuses | Generous sign-. Negotiable based on experience.Vacaville Animal Care ...Show more

Last updated: 30+ days ago • Promoted