Job Summary
The Senior IBM Cognos Developer will play a critical role in developing, managing, and optimizing reporting solutions for a leading bank using IBM Cognos BI Suite. The candidate will bring a wealth of experience in creating complex reports, metadata modeling, and administration within the Cognos platform, ensuring robust reporting capabilities tailored to the banking domain.
Key Responsibilities
- Develop and maintain reporting applications using Cognos Business Intelligence components, including Report Studio, Framework Manager, Query Studio, and Cognos Connection.
- Design and implement complex reports in Cognos 10 and 11 BI Suite with advanced features like drill-through, master-detail relationships, conditional formatting, report bursting, and macros.
- Enhance existing Framework packages by integrating new namespaces, query subjects, query items, and data tables based on evolving business requirements.
- Perform metadata modeling tasks such as creating projects, managing metadata, preparing business views, and publishing packages to the Cognos portal.
- Administer Cognos environments, including creating data source connections, deploying reports from development to production environments, and managing user permissions for packages and folders.
- Conduct OLTP/OLAP system analysis and maintain database schemas, such as Star and Snowflake schemas, to ensure efficient data management.
- Optimize report performance, write and debug complex SQL queries, and troubleshoot issues to maintain seamless reporting operations.
- Leverage domain expertise in banking and finance to align reporting solutions with industry-specific needs.
Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
- Proficiency in IBM Cognos BI Suite (versions 10 and 11), including Report Studio, Framework Manager, Query Studio, and Event Studio.
- Strong experience in metadata modeling and Cognos administration.
- Hands-on expertise in OLTP/OLAP systems and database schema design (Star and Snowflake schemas).
- Proficiency in SQL with experience in writing and troubleshooting complex queries.
- Knowledge of banking and finance processes and reporting needs is a significant advantage.
- A minimum of 5+ years of relevant experience in Cognos BI development and administration.
- Excellent problem-solving abilities, attention to detail, strong communication skills, and the ability to work collaboratively with cross-functional teams.