Informatica Lead - LS

Employment Type

: Full-Time


: Information Technology

Pharmaceutical Commercial and Sales Operations group, including insights around Sales (Demand vs Forecast, Normalized Units), Channel Performance, Inventory (Days on Hand, Channel vs Warehouse), Calls (Reach, Frequency, Adherence) Processes data related to Sales, Sales Operations, Marketing, Market Access etc. (e. Direct Sales, Self-Dispensing Pharmacy, Competitor Sales, Prescription, Shipment, Distribution Channel, CRM, Incentive Program, Physician Affiliations, Pricing decisions, Payer contracts, Speaker Program, etc.). Knowledge of applications related to Commercial organization (e.g. IMS, SPP, SD, Direct Sales, Self-Dispensing Pharmacy, Shipment, Veeva, Speaker Program, SAS, etc.). Strong ETL (Informatica) development with Pharma under Commercial Sales Ops domain. 5-10 years of progressive software development experience in ETL development. Expertise in writing and tuning complex SQL Expertise in using partitioning, transformations, incremental caching in Informatica toolset. Expert understanding of slowly changing dimensions (SCD's) in Informatica. Expert understanding of join logic and query optimization in Informatica Experience with stored procedures, Triggers, PLSQL in Oracle.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...