Microstrategy developer vs sql bi developer

Differences between microstrategy developer and sql bi developer duties and responsibilities

Microstrategy developer example responsibilities.

• Develop UNIX shell scripts to automate repetitive database processes.
• Maintain and manage the LINUX server platform for effective operations of the OBIEE and ODI applications.
• Involve in creating users, groups, assigning rights to users or groups, scheduling reports, managing servers using CMC.
• Used PL/SQL procedures in different places.
• Work with creating of views in TeraData.
• Design, implement and tune interfaces and batch jobs using PL/SQL.
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