Sr. Data Warehouse ETL Developer Remote When converted, hybrid onsite 1-2 days Fairfield, CA so need local only w2 • Senior Level – 8-10 years of experience • Healthcare background 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