Cognos Business Intelligence Developer

Medimpact; Chennai District, Bengaluru; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Medimpact in India is seeking a Senior Cognos BI Developer to design, develop, and maintain enterprise reporting and analytics on the IBM Cognos Analytics platform. You will own end-to-end delivery from data modeling and report development to performance tuning and production deployments.

Responsibilities include building complex paginated reports and dashboards, optimizing SQL, implementing security, and leading BI standards. Collaboration with business analysts and end users is essential.

Qualifications

• IBM Cognos BI/Analytics experience (10.x/11.x).
• Framework Manager modeling and Data Modules expertise.
• Report Studio / Cognos Reporting proficiency (list, crosstab, chart, dashboard, bursting).
• Strong SQL skills including joins, window functions, optimization.
• Dimensional modeling knowledge: star/snowflake schemas, slowly changing dimensions.
• Experience with enterprise RDBMS (SQL Server, Oracle, Teradata, DB2) and cloud warehouses (Snowflake, Synapse, BigQuery, Redshift).
• Exposure to ETL concepts and tools (SSIS, Informatica, ADF, DataStage).
• Cognos administration: content store, dispatcher, security, audit.
• Experience deploying Cognos in dev/test/prod lifecycles, version control, CI/CD.

Responsibilities

• Design and develop complex paginated reports, dashboards, and visualizations in IBM Cognos Analytics 10.x/11.x.
• Build and maintain Framework Manager packages and Data Modules.
• Translate business requirements into technical specs and collaborate with BAs, product owners, end users.
• Optimize SQL queries, procedures, and views across Oracle/PostgreSQL/SQL Server.
• Implement prompts, drill-throughs, security, burst scheduling, and distribution.
• Configure schedules, subscriptions, and deployment across environments.
• Mentor junior developers; conduct code reviews and enforce BI standards.
• Provide L3 support and troubleshoot production issues.

Skills

IBM Cognos BI

Framework Manager

Data Modules

Report Studio

SQL

Dimensional Modeling

RDBMS

Cloud Data Warehouse

ETL Concepts

Cognos Administration

CI/CD

Tools

SSIS

Informatica

ADF

DataStage

Cognos SDK

Job description

Job Title: Cognos BI Developer

Location: Bangalore/Chennai

Experience: 5-10 years

Role Summary: We are looking for a Senior Cognos BI Developer to design, develop, and maintain enterprise reporting and analytics solutions on the IBM Cognos Analytics platform. The role involves end-to-end ownership from data modeling and report development to performance tuning, deployment, and stakeholder engagement.

Key Responsibilities

• Design and develop complex paginated reports, dashboards, active reports, and visualizations in IBM Cognos Analytics (10.x/11.x)
• Build and maintain Framework Manager packages and modern Data Modules — define namespaces, query subjects, relationships, determinants, calculated items, and governors.
• Translate business requirements into technical specs; work directly with business analysts, product owners, and end users.
• Develop and optimize underlying SQL queries, stored procedures, and views on relational databases such as Oracle, PostgreSQL, SQL Server etc.
• Implement prompts, drill-throughs, master-detail relationships, conditional formatting, and bursting.
• Configure schedules, subscriptions, and distribution (email, file share, portal).
• Implement row-level / object-level security using Cognos namespaces, capabilities, and authentication providers (LDAP, AD, SSO/SAML).
• Perform performance tuning of reports, queries, and Cognos services — analyze query logs, indexing strategies, and caching.
• Migrate legacy content (SSRS, Crystal, older Cognos versions, BusinessObjects) into the current Cognos environment.
• Support deployments across environments (Dev UAT Prod) using deployment specifications, Lifecycle Manager, and Git-based version control.
• Mentor junior developers; conduct code reviews and enforce BI standards.
• Troubleshoot production issues and provide L3 support.

Required Skills

• 5–10 years of hands‑on experience in IBM Cognos BI / Analytics (10.x and 11.x).
• Strong expertise in Framework Manager modeling and Data Modules.
• Expert in Report Studio / Cognos Reporting — list, crosstab, chart, dashboard, active report, drill‑through, bursting.
• Strong SQL skills — complex joins, window functions, query optimization, execution plan reading.
• Solid grasp of dimensional modeling, star/snowflake schemas, slowly changing dimensions.
• Experience with at least one enterprise RDBMS (SQL Server, Oracle, Teradata, DB2) and ideally a cloud warehouse (Snowflake, Synapse, BigQuery, Redshift).
• Understanding of ETL concepts and exposure to tools like SSIS, Informatica, ADF, or DataStage.
• Working knowledge of Cognos administration — content store, dispatcher, security, audit.
• Experience deploying Cognos in dev/test/prod lifecycles, version control, and CI/CD principles.

Preferred / Nice‑to‑Have

• Experience with Cognos SDK / REST API for automation.
• Migration experience: Cognos Power BI/Tableau.
• Exposure to Power BI, Tableau, or Qlik for hybrid environments.

Soft Skills

• Strong communication and collaboration skills
• Ability to work independently and in a team environment
• Proactive mindset with attention to detail

Working Hours : alignment with PT (US) time-zone