New job - Data Warehouse Specialist (BI Specialist) - Company: Capital Group Companies - Irvine, CA - Phone-hire - Irvine- California

A new Job, ID: 27436 was added at eJobsVille.com - For the Best Tech Jobs in Town

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  (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 "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/groups/opt_out.