Job Description :
Title: Data warehouse Analyst
Location: North Chicago, IL
Duration: 12 Months+

Job Description:

Technical Skill Set:
*Must have expertise in Informatica Power Center
*Must have expertise Oracle SQL and PLSQL
*Must have knowledge of Oracle Life Science Data Hub and clinical technologies such as Medidata Rave and Oracle Clinical

Key Responsibilities Include:

*Design, Build and test database mapping using Informatica power center and Oracle Life Science Data Hub
*Performs integration of clinical data from desperate data sources, for clinical trials, using Extract Transform and Load (ETL) tools.
*Supports the execution of all Data and Statistical Sciences (DSS) processes involved in the locking of the clinical trial.
*Changes data models/mappings in support of post-production change activities.
*Actively collaborates with other DSS functions. Liaises with the Data Analysts, Testing Specialists, Statistical Programmers, and Statisticians. Effectively communicates progress of database definition and development.
*Identifies needed updates to design specifications, clinical trial application interfaces, data models and data structures.