Obiee developer vs data warehouse developer

Differences between obiee developer and data warehouse developer duties and responsibilities

Obiee developer example responsibilities.

• Create and manage TNS entries for various environments on the server using UNIX.
• Implement LDAP security, manage access to the reports through roles and permissions.
• Create groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Manage appropriate security privileges on subject areas and dashboards as it are indicated in the business requirements.
• Work with user groups in creating and modifying dashboards or worksheets in desktop and server.
• Perform major role in understanding the business requirements, designing and loading the data into data warehouse (ETL).
Show more

Data warehouse developer example responsibilities.

• Help in set up the SharePoint server, deploy reports and create, manage subscriptions and data driven subscriptions.
• Achieve significant performance improvement in reducing response time of queries by rewriting and tuning SQL statements embed in PhP code.
• Develop MapReduce jobs in Java API to parse the raw data and store the refined data.
• Shell scripting, Linux administration, and Perl language support.
• Develop, modify and execute Perl and MySQL scripts from Linux command line.
• Liaise with QA in deploying ETL flows and reports into their environments and attend defect calls.
Show more