Senior cognos developer vs sql developer

Differences between senior cognos developer and sql 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 developer example responsibilities.

• Manage migration of SQL 2005 databases to SQL 2008 R2.
• Work with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
• Coordinate with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Used subversion tools, SVN version management to manage various versions of the procedures and functions for of the application.
• Achieve significant performance improvement in reducing response time of queries by rewriting and tuning SQL statements embed in PhP code.
• Involve in DBA responsibilities such as managing users and permissions, creating audit triggers, and overlook the daily back up.
Show more