Title - ETL Lead (SME)Location- SFO, CADuration - 12+ MonthsPay Rate - Open Strong knowledge of systems data related to Pharma Life Sciences Sales, Sales Operations, Marketing, Market Access groups (e.g. Retail Non-Retail Sales, Competitor Sales, Ex-Factory Shipments, Distribution Channels, CRM, Sale RepsMSL Calls Interactions, Sales Roster ZTT, Incentive Program, HCP-HCO Affiliations, Speaker Program, Patient Claims etc.) Strong knowledge of applications related to the Commercial organization (e.g. IMS, SPP, SD, 3PLICS, Veeva, SHA Symphony etc.). Extensive Business andor technical background in the areas of Data modeling, EDW, Data Mart, Master Data Management, Metadata management, Data Quality, Data Governance, Data integration (ETL) and Data Security Knowledge of Managed Services Support Operations processes, including Tickets, SLAs, RCA, Run book, Knowledgebase, Job calendar etc 7+ years of progressive software development experience in ETL development., with tools like SSIS, Informatica etc. Expertise in writing and tuning complex SQL Expertise in using partitioning, transformations, incremental caching in ETL toolset. Expert understanding of slowly changing dimensions (SCD's). Expert understanding of join logic and query optimization Experience with stored procedures, Triggers, PLSQL in SQL Server or Oracle. Expert in writing efficient Analytic and windowing functions in SQL Server or Oracle.