Qualifications
- 7+ years of experience in data warehousing and business intelligence with emphasis on business requirements analysis, application design, and development, testing, implementation and maintenance of data warehouse and data mart systems
- 5 years of experience on Cognos Tools namely Cognos 10.2, Cognos 8.4 Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer, Powerplay)
- Experience with development of metadata modeling using Cognos Framework Manager
- Expertise with Cognos Administration and security
- Experience in designing and developing Business Insight Dashboards
- Expert proficiency with Workspace, Framework Manager, Transformer, Business Intelligence, Report Studio, Analysis Studio, and Query Studio
- Expertise with data modelling required – relational and multi-dimensional
- Proficient with SQL, PL/SQL
- Strong understanding of Oracle hardware architectures
- Experience with Linux or UNIX
- Advanced proficiency with MS Excel
- Strong analytical and statistical skills
- Professional, friendly, and courteous demeanor to work well with teammates
- Works with a strong sense of urgency, is proactive and flexible, strategic thinking, and self-motivated
- Ability to work well both independently and in diverse teams
- Minimum education requirement is 4-year college degree
Responsibilities
- Design and develop Training data metadata models catalogs, transformer model and packages using transformer and Framework Manager respectively
- Develop High Level Designs, Low-level Designs, Test Cases and finally the code for every module involved in a project
- Create new reports and enhance existing reports using Business Intelligence, Power Play, Analysis Studio and Report Studio
- Deploy Cognos content from Development environment to Production environment
- Develop multi-dimensional cubes for using Power Play applications for analysis
- Responsible for run time performance and tuning of the queries
- Provide Tier 3 support for other report developers with less proficiency
- Support production deployments & production support for applications
- Responsible for understanding and addressing customer and user requirements, their strategies, and their goals