Pharma domain experience is a must
8-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, PL/SQL in Oracle.
Expert in writing efficient Analytic and windowing functions in Oracle.
Extensive Business and/or 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
Strong knowledge of processes & data related to Sales, Sales Operations, Marketing, Market Access etc. (e.g. Direct Sales, Self-Dispensing Pharmacy, Competitor Sales, Prescription, Shipment, Distribution Channel, CRM, Incentive Program, Physician Affiliations, Pricing decisions, Payer contracts, Speaker Program, etc.
Strong knowledge of applications related to the Commercial organization (e.g.
IMS, Symphony, SPP, SD, Direct Sales, Self-Dispensing Pharmacy, Shipment, Veeva, Speaker Program, SAS, etc.).
ETL Informatica Developer (With Pharma Commercial Domain Experience)
12 + months
Infotech Spectrum Inc