Job Title: Cognos Developer (Ref Code: 3-21-12 KF1)

Location: Washington DC

Duration: Long Term

Send Resumes to Careers@iormyx.com with the Ref Code

Job Description:

The candidate should have combined business analysis and OLAP/Relational Database technical background, a proven record of accomplishment, and a minimum 6 years of workplace experience.

The candidate should have an understanding of the development and documentation of user requirements. The candidate should have strong oral and written communication skills.

The candidate should have an excellent understanding of the Cognos OLAP tool, particularly of Cognos Series 8 (Framework Manager, Report Studio, Query studio, Event Studio, Analysis Studio, and Connection). The candidate will also potentially carry out development in a relational database/data warehouse environment; therefore, he or she should have a background in designing tables and views in relational databases and be able to use PL/SQL proficiently. Knowledge of Oracle databases is a must.

 

The candidate should have:

In-depth theoretical understanding and practical expertise with regards to data warehousing architecture and methodology
Min. 5 years of hands-on data warehousing expertise covering all aspects of software project life-cycle, i.e. business and data modeling, data analysis, system design, development, etc.
Experience in working with the large-scale (100+ entities) relational data models
Thorough understanding of relational and dimensional data modeling techniques
Min. 3 years of hands-on expertise with Oracle databases, especially 9i/10g
Strong knowledge of SQL, PL/SQL, performance tuning techniques for working with the large volume tables
Familiarity with data modeling tools such as ERWIN (3.5 and 4.1)
Familiarity with various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams)
Excellent communication and facilitation skills
Excellent understanding of the Cognos OLAP tool, particularly of Cognos Series 8 (Framework Manager, Report Studio, Query studio, Event Studio, Analysis Studio, and Connection)

This position requires flexibility, creativity and initiative. Candidates should be self-starters who enjoy working with an international team of people. Candidates must be able to multi-task their workload assignments. Candidates must be fluent in spoken and written English, have strong writing and communication skills, and be team players.




This individual will carry out the following business analysis and technical responsibilities for DOTS/IDG Reporting project on Cognos 8 platform:

Prepare technical specifications from user requirements
Develop and maintain Cognos Framework models and packages.
Develop and maintain reports using Report Studio and Query Studio.
Develop analytical reports using Analysis Studio.
Develop Cognos Transformer cube models such as dimensions and measures using specs modeled after user needs.
Trouble-shoot cube and query build issues and errors.
Validate cube and query data from the reporting system back to the source system.
Attend requirements definition meetings with business users and document meeting outcomes