Senior DW Consultant for a 6montsh contract in Boston, MA  Please revert to

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

o       Multiple client reference testimonials

­       State and or federal government experience helpful, but not

*Skills Required:*

­       Logical data modeling of both transactional and analytical databases

­       Physical database design and optimization in an Oracle 10gR2

­       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

­       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

­       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


6.      Why do you feel you are best candidate for this position

Looking forward for a prosperous business relation!!


Rohit Shetty

Technical Recruiter


1001 Durham Ave, Suite #101

South Plainfield, NJ 07080

9252181845 Work Number

866 294 1314 Fax

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

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 
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at

Reply via email to