*Note: Please forward resumes to **[email protected]*
*Job Position : *Business Intelligence Developer
*Job Location : *Richmond VA *(Need Locals)*
*Job Duration : *6 Months +
*NOTE : Candidates will be required to come in for a face to face interview.
** *
*Job Description:*
*Requirement Details:*
* *
Supports and executes the organization's strategy to analyze and organize
data for information processing and delivery purposes. This position
supports the Database Administration Team within the Corrections Technology
Services Unit (CTSU) by participating in the development, implementation,
and support of a data warehouse.
Serves as an expert in solutions delivery with SAP Business Objects
reporting platform. Creates Business Objects Universes to present data to
the business in an easy to use structure. Assists with cross functional
project teams in the development, continuous improvement and use of SAP
Business Objects across the enterprise.
Working knowledge of all aspects of Business Intelligence (BI) systems (data
warehouse design, dimensional modeling, business question identification,
Extract, Transform, and Load (ETL), On-line Analytical Processing (OLAP)
reporting, and information delivery).
Experience in developing and administering SAP Business Objects reporting
stack(Includes developing Universes, Xcelsius Dashboards and Reports).Must
have experience with Business Objects Enterprise XI 3.1, Web Intelligence,
Xcelsius, Crystal Reports and Business Explorer (BEx)
*Resource MUST have worked on BOBJ and have successfully completed at least
one implementation*
Working knowledge of MS Structured Query Language (SQL) 2008. Experience
developing BI solutions, preferably with Microsoft BI tools. Experience
developing ETL programs with MS SQL Server 2008 Integration Services.
Experience developing OLAP cubes with MS SQL Server 2008 Analysis Services.
Ability to deliver work accurately and timely while independently managing
multiple priorities.
*Required / Desired Skills*
Deep knowledge of SAP Business Objects and Universe creation :
Required 4 Years
ETL Design and Development
: Required 4 Years
Develop OLAP cubes, reports, extracts, presentation dashboards :
Required 4 Years
* *
*Questions For Requirement*
* *
*Please answer the below question***
* *
Question 1:
What is ER Modeling and Dimensional Modeling?
Question 2:
What is the difference between "intersect" and "except"?
Question 3:
How do you generate an Auto Incremental Number in SSIS? (If candidate is
unfamiliar with SSIS, ask "how is it generated in T-SQL or MS Reporting
Services?")
Question 4:
How do you send an SSRS report from SSIS?
Question 5:
What are materialized views? Do the changes to the views affect the
corresponding tables?
Question 6:
What is the purpose of "factless" fact tables and junk dimensions?
Question 7:
What are Analysis Services Cubes?
Question 8:
**SITUATIONAL**
By the time I'm finished, all my tables have a ton of entries which must be
deleted out before I deliver the product for production. After deleting out
all the superfluous data, is there a way to have SQL Server start over at
the initial sequential prpimary key value of '1' for all my tables? How?
*Vasanth Dolai *
*Recruiting Specialist*
*Saxon Global Inc*
*1300 | W Walnut Hill Ln, *
*Suite 257 | Irving, TX 75038 *
*Phone: 972 573 3667 (Direct)*
*Phone: 972 550 9346 * 212*
*Fax : 866 405 9572*
*Email : **[email protected]* <[email protected]>
* *
*Yahoo IM: Vasanthdolai*
*The Lord Jesus Christ said, "The one who comes to Me I will certainly not
reject" (John 6:37)*
--
You received this message because you are subscribed to the Google Groups
"Oracle-Projects" 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.com/group/oracle-projects?hl=en.
