| Data Architect Data Warehouse ODI and OIC at Remote, Remote, USA |
| Email: [email protected] |
| From: Sanjeev Kumar Singh, Tek Inspirations LLC [email protected] Reply to: [email protected] Job Description - Job Title: Data Architect Data Warehouse ODI and OIC Location: 100% Remote Hiring manager Notes:-Commercial Pharma experience. Recent and a good amount of it.Must have built a Data Warehouse.ODI (Oracle Data Integrator)OIC (Oracle Integration Cloud)IntegrationData MartsVeeva CRM and/or Oracle Fusion ERP Job Function: The Data Architect is a role for a BioPharma client building a Data Warehouse. The Data Architect will be responsible for designing and writing ETL solutions using Oracle's Data Integrator (ODI) and Oracle Integration Cloud (OIC) software tools (and related technologies) (Pharmaceutical, Biotech, Healthcare Medical Device) clients. They will be leading ETL developers to create and test ETL and Integration code. Primary Responsibilities: Design overall Data Warehouse data model and ETL solution. Partner with client Commercial Sales and Marketing, Market Access, Commercial Operations, and other stakeholders to design and build ETL workflows. Create source to target mappings for simple to complex data integration tasks. Integrate enterprise applications such as Veeva CRM and Oracle ERP with other enterprise applications and data feeds. Document Technical Requirements based on Data Requirements Provide estimates and timelines to deliver functionality based on Data Requirements Provide updates and status reports to the Project Manager around progress and any issues or blockers Provide advice and guidance on functionality and implementation strategy for Oracle ODI/OIC Lead ETL developers to ensure they are developing code according to design and team standards. Reviews all code created by ETL developers. Qualifications: Strong knowledge of Oracle Data Integrator for batch application development within a Data Warehouse environment. Experience modeling a data warehouse solution for staging, enterprise data warehouse and DataMart schemas. Strong understanding of Pharma data sources such as Symphony and Veeva OpenData. Significant experience with Oracle Integration Cloud for building data connections between various applications in the client's environment, especially Veeva CRM and Oracle Fusion ERP. ODI and OIC configuration and setup experience Strong understanding of data warehousing and source to target mapping concepts Minimum of 5 years' experience working with ODI, OIC and Data Warehouses Experience working with a Pharmaceutical, Biotech or Medical Device organization. Experience working in an agile delivery environment. Ability to handle multiple priorities and work under pressure. Good functional knowledge of Life Sciences commercialization processes. Experience leading ETL developers. Experience with building ETL frameworks for auditing and logging job progress and completion. Familiarity with the following is a big plus: Experience with Commercial Data (KOL, HCP, HCO, Prescription, Sales Territories etc) Keywords: information technology |
| [email protected] View all |
| Tue Sep 26 23:38:00 UTC 2023 |