Senior cognos developer vs sql bi developer

Differences between senior cognos developer and sql bi developer duties and responsibilities

Senior cognos developer example responsibilities.

• Introduce and develop OLAP dimensional analysis and eventually lead the transition of reporting from relational to dimensional.
• Create and design DTS packages (SSIS) used for implementing the schema for the required data mart.
• Work along with the ETL team to understand the flow of data from OLTP system to the OLAP system.
• Tweak the Java scripts in reports to support for Cognos10.1.
• Involve in creating Informatica transformations, scheduling jobs and data loading.
• Create an ODS for reporting from base tables in DB2 database.
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