Click here to login or register
Reference # : 13-00862 Title : BIPM Data Architect
Location : Portland, OR
Position Type : Full Time/Contract
Experience Level : 5 Years Start Date : 03/12/2013  
Pay Rate : $ 65.00 /Hour
Description
 
Skills Required:
  • Hands on experience in DBMS like SQL Server 2008 R 2 or Oracle 10g.
  • Experience in Languages like SQL, T-SQL, oracle PL/SQL.
  • Should be comfortable in working with Operating Systems like Linux, Unix and Windows.
  • Hands on experience in ERP (Basis admin) like SAP R/3 4.6C, 4.5B, ECC.
  • Experience in Tools/Utilities like Sybase Power Designer, Cognos 10.1, Toad, SQL Server Management Studio, and Oracle SQL Developer.

Roles & Responsibilities:
  • Translate business requirements into an actionable conceptual data model.
  • Apply business and application knowledge to design the data model for flexibility, simplicity, consistency and integrity.
  • Perform data profiling (familiarity with profiling tools like information analyzer is desirable) and analyze the data to identify the different data sources to meet the Reporting requirements.
  • Design the various data models and maintain the integrity and quality of the work products/deliverables for the data environment.
  • Work closely with the Database Administrator to help insure the physical design meets the functional and performance requirements of the application.
  • Work with BI DBA, Technical Architecture and engineering on indexing strategies, database objects maintenance (size and physical location), processing patterns and CPU usage management, temporary space and rollback segments, RAID implementation, and other technical issues.
  • Define, design and construct data structures or databases.
  • Conduct QC testing of ETL and Reports.
  • Work closely with the Principal Enterprise Architect and BI Data Analysts, ETL and Reporting teams to help ensure all data structures and databases contain all required data elements.
 
   ******Please apply online with a word copy of your resume along with your Contact details   Please dont call .*******