Obiee developer vs sql bi developer

Differences between obiee developer and sql bi 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

Sql bi developer example responsibilities.

• Work with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
• Used data transformation services (DTS) an ETL tool of SQL server to migrate data from various data sources.
• Create and maintain proper documentation of all the SSIS and SSRS reports, check in into TFS for future reference.
• Develop user define financial reports to provide on demand financial data analysis using SSRS.
• Experience designing visual report solutions, including dashboards using SSRS and/or other data visualization/dashboard tools.
• Design and update informative dashboards and collaborate with other team members by sharing customize reports and up-to-date documents in SharePoint.
Show more