Previous Job
Sr. Data Architect (Oracle)
Ref No.: 18-05375
Location: Marlborough, Massachusetts
Lead the design of a high performing Enterprise Semantic Layer, following Modern and Proven methodologies along with actively participating in enhancing the EDW
Collaborate with the stakeholders and build Semantic Layer augmented by Data Lake that support their reporting, analytics, data exploration and Self Service needs
Build best practice standards around Data Architecture, Metadata, Governance, Data Federation and Data Quality flows
Promote user-centric model to a shared area, for re-usability and governance
Extensive Experience with architecting solutions across platforms and using multiple data layers presented in a federated schematic layer
Sound Knowledge in Pharmaceutical Commercial Sales and Marketing Preferred strongly
Leverage Expert Skills in Handling Big Data (Oracle based) both in terms of Flexible Business friendly Design in form of Views and Performance Tuning/Enhancement
Ability to Build the Semantic Layer with high availability and failover supporting architecture
Lead discussions to document all coding and naming standards and procedures for the definition of reference architecture
Great depth in ETL with Informatica on a Linux platform
Ease in documenting the Technical Requirements and Design Documents on top of preparing Standards set across the platform
Strong knowledge and experience in supporting Reporting Layer in Tableau
Candidate must be Quickly be able to jump start on the projects
Works on code migration, testing defect resolution, and initial data loads and ongoing data loads
Lead Project technical implementation
Build all Systems Testing, Integration Testing and UAT Testing Plans and Test Cases.
Must be a self-learner and a Team Player
Demonstrate Excellence in all the work they perform
Must be able to work in both Agile and SDLC driven approaches of the project
Must be able to Present the Architecture and Strategy to Management and Stake holders and Customers
Must be able to work under tight timelines in complex environments and perform with high quality

Oracle 12c
Informatica Power Center
Unix / LINUX Scripting
Good To Have –AWS (Redshift), Modern Data Lake Architecture, Tableau or similar