Description
Overview:
- Responsibilities are to design, build & deliver BI solutions using various Cognos tools.
- Support a Business Intelligence environment using Cognos & other IBM products
- Troubleshooting of report issues and performance issues are critical
- Work with DBAs, report writers and system administrators to track down and improve or eliminate bottlenecks in the BI reporting & ETL environment
- Provide technical support to the Cognos report writers
Required Skills: Cognos 10, Transformer, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Oracle 11g, Relational, OLAP, Star Schema, Multi-dimensional database models.
Qualifications:
- Strong understanding of Data warehouse and Business Intelligence concepts and best practices processes.
- Experience with administration, deployment and security setups within Cognos.
- Strong experience in creating Framework models with different layers.
- Strong experience with Report development.
- Hands-on development and implementation of Cognos 10 BI suite of tools.
- Must have strong understanding of DW processes and OLAP concepts, with star schema data models.
- Experience with administration and security setups within Cognos.
- Strong experience in creating OLAP Cubes using Cognos Transformer
- Strong experience in creating Framework models with different layers.
- Strong experience in creating advanced reports in Report Studio and Analysis Studio.
- Experience with building Dashboards and Scorecards.
- Experience with Cognos Workspace Advanced and Active Reports.
- Experience and Proficiency in writing Oracle SQL queries.
- Good understanding of Java scripts usage in Cognos.
- Must have excellent analytical, conceptual, troubleshooting, and problem-solving skills.
- Excellent communications skills, able to work effectively with business users to understand and clarify requirements as well as educate and resolve end user reporting issues.
- 5-7 years of Cognos BI experience
Preferred Qualifications:
- Cognos Analytics 11.x, Framework Manager, Event Studio, Oracle 12c, Relational, OLAP, Star Schema, Multi-dimensional database models.
- Experience with ETL tools like DataStage is a plus.