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.
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.