Senior DW Consultant for a 6montsh contract in Boston, MA Please revert to ro...@trustek.com
Rate: Open *Experience Required:* At least 5 years of specialized experience in the design and implementation of Operational Data Stores, Data Warehouses, and Data Marts At least 3 years experience implementing the above components in an Oracle environment At least 2 full scale implementations utilizing Oracle 10g or higher At least 1 year of experience with designing and implementing Informatica based ETL functions At least 1 year of experience with designing and implementing reporting applications with a leading BI tool suite such as Cognos, Business Objects, Hyperion, etc. Proven effective execution experience in high visibility, high criticality programs with multiple stakeholders both within and outside of the client organization Ability to demonstrably illustrate all above experience through: o Technical and functional interviews o Presentation of sanitized deliverables from past projects of similar nature o Multiple client reference testimonials State and or federal government experience helpful, but not mandatory *Skills Required:* Logical data modeling of both transactional and analytical databases Physical database design and optimization in an Oracle 10gR2 environment Database user load stress testing and optimization PL/SQL and stored procedure development Exposure to ETL based integration tools Exposure to XML based integration tools Creation of data dictionaries and meta data repositories within data warehouse Strong communication and documentation skills Consistent attention to detail Overall high degree of professionalism *Description of Project:* The purpose of this project is to assist the Commonwealth of Massachusetts with reporting, analytics and integration of information related to the American Recovery & Reinvestment Act of 2009 (ARRA). Major components of this multi-phased effort include the following: Data sourcing from multiple agencies, sub-recipients, and vendors involved with ARRA related programs Staging, validation and transformation of data provided by the aforementioned organizations Centralization and organization of data for optimized reporting, analytics, and overall transparency Submission of data to regulators and attainment of federally mandated reporting accuracy and transparency requirements Expansion of capabilities beyond federally mandated reporting & transparency requirements in the interest of further informing the residents of Massachusetts, and increasing the overall execution efficiency and effectiveness of ARRA projects performed within the Commonwealth Implementation of processes and controls across the above components *Duties Required of This Role:* The selected candidate will work as a specialist responsible for the development and maintenance of data warehouse application programs; develop databases using Oracle 10gR2 and related components; write extract programs; code and document scripts and stored procedures; develop appropriate programs and systems documentation; assist with metadata repository data management; create index and view scripts, etc. *Specific Deliverables:* * * Logical data model for Operational Data Store and Data Mart for map based analytics Physical construction and optimization of stress tested and approved Operational Data Store and Data Marts Maintenance processes including database optimization, troubleshooting, and porting across development / test / production environments Documentation of above components and knowledge transfer as needed I would appreciate if you can fill the following details and revert back to me asap. * * *Candidate Submittal* 1. Candidate First Name and Last name 2. Current Location 3. Phone # © / (H) 4. Employer Details /rate 5. References: Manager with Desk number / no cell phone # or personal ID i. Project manager name ii. 6. Why do you feel you are best candidate for this position Looking forward for a prosperous business relation!! Cheers, Rohit Shetty Technical Recruiter TRUSTEK, INC 1001 Durham Ave, Suite #101 South Plainfield, NJ 07080 ro...@trustek.com 9252181845 Work Number 866 294 1314 Fax www.trustek.com This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) And may contain confidential and privilege information. If you are not the intended recipient, Please contact the sender by reply e-mail and destroy all copies of original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying Of this email or any action taken in reliance of this e-mail is strictly prohibited and may be Unlawful. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "REQSRESUMES" group. To post to this group, send email to reqsresumes@googlegroups.com To unsubscribe from this group, send email to reqsresumes+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reqsresumes?hl=en -~----------~----~----~----~------~----~------~--~---
