A new Job, ID: 27436 <http://ejobsville.com/display-job/27436/> was added
at *eJobsVille.com - For the Best Tech Jobs in Town* <http://ejobsville.com>
*Title:* *Data Warehouse Specialist (BI Specialist) - Company: Capital
Group Companies - Irvine, CA* posted on 2013-08-28 14:57:19
*Job Description:*
*Title: Data Warehouse Specialist*
*Company: Capital Group Companies*
*Location: Irvine, CA*
*Length: 6+ months*
Data Warehouse Specialist responsible for designing and developing data
warehouse solution in support of users' BI needs
*JOB DUTIES*
- Gathering user data requirements, identifying and analyzing source
data to meet user requirements
- Designing relational data models for handling integration of source
data and dimensional models for BI reporting
- Designing and developing the integration components (e.g. UNIX
scripts, Stored Procedures, PowerCenter ETLs) to enable final delivery
of data to BI layer
- Leading the strategic design and maintenance of business intelligence
applications
- Identifies, researches, and resolves technical problems
- Ensures that the use of business intelligence applications enhances
business decision making capabilities
- Work closely with BSA and business users in gathering requirements,
source system teams to understand and analyze data patterns, DBAs to fine
tune physical data structures and developers to execute on the overall data
warehouse solution
*REQUIRED EXPERIENCE*
- Oracle - 6 + Years
- Data Analysis - 6 + Years
- Data Modeling - 6 + Years
- Data Warehousing - 6 + Years
- Integration - 6 + Years
*CORE SKILLS*
- Data Analysis
- Data Modeling (conceptual, logical, & Physical)
- Data Warehousing
- Data Integration
DETAILED SKILLS
- Oracle 11g
- Ability to write SQL Statements
- Stored procedures
- Performance Tuning
- Data Modeling
- Case Tool experience Erwin
- Data Warehouse
- Understand Data Warehouse Architecture
- Different layers to Data Warehousing
- Data Flow - how data flows from 1 area to the next within data
warehouse.
- Staging area
- Will be given sample data and expected to demonstrate what needs to be
done.
- Will work closely with ETL Developers
- Unix
- Good communication skills (requirements gathering)
*Click here to view full job descripton and
apply*<http://ejobsville.com/display-job/27436/>
(Guest users can also apply)
------------------------------
Best regards,
eJobsVille.com - For The Best Tech Jobs In Town
--
You received this message because you are subscribed to the Google Groups
"oraapps" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/oraapps.
For more options, visit https://groups.google.com/groups/opt_out.
