Title - Informatica/Teradata Developer
Location - Raleigh, NC (Remote till November)
Duration - 6+ Months
Job Description:
· Strong ETL development with Pharma Commercial & Sales Ops domain.
· 8+ years of progressive software development experience in ETL development.
· Minimum 5 years of demonstrated experience using an ETL tool (SSIS/Informatica).
· Expertise in writing and tuning complex SQL and Knowledge of Teradata, TSQL, and basic hands-on
· Expertise in using partitioning, transformations, incremental caching.
· Expert understanding of slowly changing dimensions (SCD's).
· Expert understanding of join logic and query optimization
· Experience with PL/SQL, namely stored procedures, Triggers, functions
· Expert in writing efficient aggregate & Analytic functions in PL/SQL
· Strong knowledge of processes & data related to Pharma Sales Operations
· Strong knowledge of applications related to the Pharma Sales Operations organization (e.g. Veeva, IQVIA/IMS data, HCP & HCO)
· Bachelor Degree in Computer Science or equivalent technical experience
· Experience with Data Implementation methodologies and best practices (e.g. waterfall, agile, other)