Hello Associates,
City: Thousand Oaks, CA Rate: $47/hr MAX ****Locals Preferred or who can go for the in person Interview*** * *Job Description:* The scope of the project is focused on the Product Complaints Management workstream. Specifically, the work described in this SOW is to provide Data Warehouse Technical Lead support for Product Complaints Metrics and Trending. This project will require (but not be limited to) the following activities: • Data Modeling o Design Dimensional Data model based on requirements o Conduct data model review with rest of project team to include BI/BA and Reporting Development team. • Data Specifications Development o *Develop Data* *specification using Amgen template* which specifies technical business rules used to load the data mart o Perform or confirm source system data analysis to prove data specification business rules. • *Data Warehouse Design and Construction* o Lead data warehouse design and construction based on *Amgen* design standards and existing design patterns. o Document high level design per *Amgen design specification template* o Develop and unit test DW programs to include *Informatica* *ETL* mappings, data base scripts. o Develop and unit test production workflows o *Develop Incident Resolution Guide and Application Operational Guide per Amgen provided template. *• Testing/ Defect fixes o Assist testing team with test scripts questions o Documenting test defect resolution using Project Team methodology for defect tracking o Perform root cause analysis of different issues raised by the testing team, BA team or end-users • Technical Team Management o Allocate work to members of the technical development team and track progress o Provide status on progress and issue to project management o Perform Code Review on the items delivered by the technical development team The deliverables include (but are not limited to): • Dimensional *Data model using ER/Studio*. o Shall include Business Data Definition • Data specification *o Using Amgen template* • Data Warehouse Design and Construction Deliverables o *DDL Scripts* for data model o Informatica *ETL* Mappings o *Installation Migration Document per Amgen* Standard as specified by EBI Team o High level design per *Amgen design specification template *o Unit Test Scripts and Results o Production workflows o Completed Data Warehouse implementation design checklist signed off by member of EBI Team. o Incident Resolution Guide per *Amgen* provided template. o Application *Operational Guide per Amgen* provided template. • Testing/ Defect fixes o Assist testing team with o Perform root cause analysis of different issues raised by the testing team, BA team or end-users • Technical Team Management o Allocate work to members of the technical development team and track progress o Provide status on progress and issue to project management Required Skills: **ETL* *BI Thanks & Regards, Fazal Mahmood I Technical Recruiter Kolansoft, INC (:201-484-0340 Fax 7:201-656-6696 *: [email protected] Yahoo IMJ : fazal_kolansoft Website: http://www.kolansoft.net *************************************************************************************************************************************** If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. I am sorry for the inconvenience caused to you. *************************************************************************************************************************************** --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "java-core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.co.in/group/java-core?hl=en-GB -~----------~----~----~----~------~----~------~--~---
