Cognos Sr Developer

Job Summary:

We are seeking an experienced Cognos Developer to lead the consolidation and optimization of our Cognos reporting environment. This role involves analyzing, redesigning, and consolidating over 900+ reports to improve performance, eliminate redundancies, and build a scalable reporting infrastructure supporting various business functions including Underwriting, Claims, Finance, and Risk.

Key Responsibilities:

• Analyze existing Cognos reports (developed using Framework Manager packages and direct SQL) to identify duplication and inefficiencies.
• Categorize reports (Simple, Medium, Complex) based on logic, queries, and structure.
• Consolidate reports with overlapping logic or outputs into optimized versions.
• Work with business stakeholders to prioritize consolidation efforts based on usage, complexity, and business impact.
• Redesign reports for efficiency, scalability, and maintainability.
• Perform unit testing, QA, and regression testing on newly developed reports.
• Support user acceptance testing (UAT) and coordinate sign-offs.
• Collaborate with the Analytics and Reporting (AW) team to implement signed-off reports into the production environment.
• Document report analysis, design changes, validation results, and any identified issues or risks.
• Ensure consistency and accuracy of data across all consolidated reports.

Required Skills & Experience:

• 5+ years of experience in Cognos development (Cognos 10 or 11 preferred).
• Strong experience with Cognos Framework Manager and Report Studio.
• Proficiency in writing and optimizing complex SQL queries.
• Proven experience in analyzing and consolidating large sets of reports.
• Understanding of data warehousing concepts and reporting best practices.
• Experience in testing lifecycle – unit, QA, regression, and UAT support.
• Strong documentation skills and attention to detail.
• Ability to work independently and as part of a cross-functional team.
• Excellent communication and stakeholder management skills.

Nice to Have:

• Experience in performance tuning of Cognos reports.
• Exposure to data governance and metadata management.
• Familiarity with agile or iterative development methodologies.

Deliverables:

• Consolidation and optimization of 900+ existing Cognos reports.
• Detailed analysis and documentation for each consolidated report.
• Fully tested and validated reports ready for production deployment.
• Final documentation summarizing changes, validations, and recommendations.

Requirements
Education & Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
• Relevant certifications in Cognos BI or similar technologies (preferred but not mandatory).

Technical Skills:

• Cognos BI Tools:

• Strong hands-on experience with Cognos Report Studio, Query Studio, and Workspace Advanced.

• Proficiency in Cognos Framework Manager (FM) – building and modifying models/packages.

• SQL & Database:

• Advanced skills in SQL development and optimization.

• Ability to understand and work with complex queries and stored procedures.
• Experience working with relational databases (e.g., Oracle, SQL Server, DB2, or similar).

• Report Optimization & Consolidation:

• Demonstrated experience in analyzing and consolidating reports in large reporting environments (900+ reports or similar scale).

• Ability to identify and eliminate redundancy in reporting logic and design.

• Data & Reporting Concepts:

• Solid understanding of data modeling, ETL workflows, and data warehousing concepts.

• Familiarity with report categorization based on complexity (simple, medium, complex).

• Testing & Validation:

• Experience in unit testing, QA, regression testing, and user acceptance testing (UAT) support.

• Strong data validation and troubleshooting skills.

Soft Skills:

• Strong analytical and problem-solving skills.
• Excellent documentation skills – able to clearly articulate report changes, logic, and findings.
• Effective communication and stakeholder management abilities.
• Ability to work independently and manage tasks with minimal supervision.
• Team-oriented, collaborative, and proactive approach.

Preferred Experience:

• Experience working in insurance, finance, or regulated industries is a plus.
• Familiarity with report usage analysis and business impact assessments.
• Exposure to agile methodologies or similar iterative development environments.

Job Opening ID

RRF_5762

Job Type

Contract

Industry

IT Services

Date Opened

22/08/2025

City

Pune City

Province

Maharashtra

Country

India

Postal Code

411001

---