Senior Software Specialist ( Java Developer)

Parametric Technology (India) Private Limited; Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Parametric Technology (India) Private Limited in Haryana is seeking a BI Developer to design and implement Cognos-based analytics, reports, and dashboards across the business.

The role emphasizes ETL, SQL/PLSQL, and data modeling, with collaboration across teams to translate requirements into scalable BI solutions.

Candidates should have experience with Cognos tools, Unix scripting, and data integration, contributing to performance optimizations and reliable reporting.

Qualifications

• Experience connecting, cleansing, and blending data within an ETL or SQL environment.
• Proficiency with IBM Cognos, SQL, PL/SQL, Pentaho, and ETL development.
• Strong knowledge of SQL, including stored procedures, triggers, indexes, and other database objects.
• Experience with Cognos Framework Manager, Cognos SDK, and Unix scripting.
• Detail-oriented with strong mathematical and written communication skills.
• Excellent ability to communicate effectively with departmental teams, cross-functional partners, and senior management.
• Exceptional planning skills and adaptability to a rapidly changing environment.
• Ability to prioritize work, manage time effectively, and work collaboratively in teams.

Responsibilities

• Design and develop BI solutions, including reports, visualizations, cubes, and metadata models using Cognos Analytics.
• Develop BI reports from discovery through deployment.
• Create databases and schema objects—tables, indexes, stored procedures, functions—as part of ETL processes.
• Design and develop dashboards and drill-through reports using Cognos.
• Use Cognos 12, Cognos Framework Manager, Unix scripts, and Cognos SDK to troubleshoot and recommend optimized design techniques.
• Analyze and refine business requirements into detailed design specifications for analytical reports and dashboards.
• Develop complex SQL programs and PL/SQL database procedures, and comprehensive database queries.
• Identify issues and optimize report performance using Cognos, BIRT, and related tools.
• Automate report schedules with Unix and shell scripts.
• Provide support for adhoc requests.

Skills

Cognos Analytics

SQL

PL/SQL

ETL development

Cognos Framework Manager

Cognos SDK

Unix scripting

BIRT

Pentaho

Data blending

Tools

IBM Cognos

Cognos Framework Manager

Cognos SDK

Pentaho

Unix

Job description

Responsibilities

• Design and develop BI solutions, including reports, visualizations, cubes, and metadata models using Cognos Analytics.
• Develop BI reports from discovery through deployment.
• Create databases and schema objects—tables, indexes, stored procedures, functions—as part of ETL processes.
• Design and develop dashboards and drill-through reports using Cognos.
• Use Cognos 12, Cognos Framework Manager, Unix scripts, and Cognos SDK to troubleshoot and recommend optimized design techniques.
• Analyze and refine business requirements into detailed design specifications for analytical reports and dashboards.
• Develop complex SQL programs and PL/SQL database procedures, and comprehensive database queries.
• Identify issues and optimize report performance using Cognos, BIRT, and related tools.
• Automate report schedules with Unix and shell scripts.
• Provide support for adhoc requests.

Qualifications

• Experience connecting, cleansing, and blending data within an ETL or SQL environment.
• Proficiency with IBM Cognos, SQL, PL/SQL, Pentaho, and ETL development.
• Strong knowledge of SQL, including stored procedures, triggers, indexes, and other database objects.
• Experience with Cognos Framework Manager, Cognos SDK, and Unix scripting.
• Detail-oriented with strong mathematical and written communication skills.
• Excellent ability to communicate effectively with departmental teams, cross‑functional partners, and senior management.
• Exceptional planning skills and adaptability to a rapidly changing environment.
• Ability to prioritize work, manage time effectively, and work collaboratively in teams.
• Understanding of retail business operations and retail management principles.
• Ability to convey information clearly and concisely.