Typical Roles In DWH Project

  •    Project Manager
  •    Database Administrator
  •   DWH Platform Admin
  •   DWH Architect
  •   Platform Architect
  •    ETL Developer
  •    OLAP Developer
  •  Data Modler
  •  QA Group
  •  Unix Admin

  •  Network Admin

  • Project Manager:  This person will oversee the progress and be responsible for the success of the data warehousing project. 
  • DBA: This role is responsible to keep the database running smoothly. Additional tasks for this role may be to plan and execute a backup/recovery plan, as well as performance tuning.
  • DWH Architect: This role is responsible for developing and implementing the overall technical architecture of the data warehouse, from the backend hardware/software to the client desktop configurations.
  • ETL Developer: This role is responsible for planning, developing, and deploying the extraction, transformation, and loading routine for the data warehouse.
  • OLAP Developer/Reporting Part: This role is responsible for the development of OLAP cubes. 
  • Platform Architect : Responsible for the Overall Infrastructure Build.
  • Data Modler: This role is responsible for taking the data structure that exists in the enterprise and model it into a schema that is suitable for OLAP analysis. 
  • QA Group: This role is responsible for ensuring the correctness of the data in the data warehouse. This role is more important than it appears, because bad data quality turns away users more than any other reason, and often is the start of the downfall for the data warehousing project.

4 comments:

  1. Hi
    I am facing issue when I am trying to connect salesforce.com by Informatica 9.1.

    Bellow error is showing

    Login Failed.Errorcode:[SOAP-ENV:Client] Reason:[Timeout].

    using Service URL:https://test.salesforce.com/services/Soap/u/23.0
    Also I have set proxydetails in C:\INFORMATICA\9.0.1\clients\PowerCenterClient\client\bin\pmsfdc.ini.

    ProxyHost=
    ProxyPort=
    ProxyUser=
    ProxyPassword=

    Please can you let me know what is the resolution of this?

    Thanks
    PP

    ReplyDelete
    Replies
    1. Have the proxy server details set in your Internet Explorer.

      • Tools > Internet Options > Connections > LAN Settings > Proxy Server.
      • And also add the proxy host name and ip in C:\Windows\System32\drivers\etc\hosts.ini file.

      Please go through my post about sales force.

      How to connect to Sales Force (SFDC) From Informatica

      Delete
  2. I would like to say that this blog really convinced me to do it! Thanks, very good post. architecture

    ReplyDelete
  3. This is extremely fascinating substance! I have completely delighted in perusing your focuses and have reached the conclusion that you are right about a hefty portion of them. You are extraordinary.  House blog

    ReplyDelete

Featured Post

Cloud : A Trendsetter Technology