IBM Cognos & DataStage Architect

8-10 Years

We are seeking an experienced IBM Cognos & DataStage Architect to lead the design development and implementation of enterprise Business Intelligence (BI) Data Warehousing Reporting and Data Integration solutions.

The ideal candidate should possess strong expertise in IBM Cognos Analytics Framework Manager IBM InfoSphere DataStage PL/SQL and Enterprise Data Warehousing. The role requires working closely with business stakeholders data engineering teams and solution architects to build scalable reporting and analytics platforms.

Experience with modern cloud and big data technologies such as Databricks Spark Scala and AWS is highly preferred.

• Design and architect enterprise-scale Business Intelligence and Data Warehousing solutions.
• Define data integration ETL reporting and analytics architecture.
• Develop enterprise reporting strategies and governance standards.
• Design scalable and high-performance BI platforms.

• Design and develop Cognos reports dashboards scorecards and analytical solutions.
• Build and maintain Cognos Framework Manager models.
• Create reusable reporting frameworks and metadata layers.
• Optimize Cognos reporting performance and security.

• Design and develop ETL solutions using IBM InfoSphere DataStage.
• Build and maintain complex data integration workflows.
• Perform data extraction transformation cleansing and loading processes.
• Support large-scale enterprise data migration projects.

• Develop and optimize PL/SQL procedures packages functions and triggers.
• Design and maintain data warehouse schemas and data marts.
• Perform SQL tuning and query optimization.
• Support data quality and governance initiatives.

• Collaborate with cloud and data engineering teams.
• Support integrations with:
  • Databricks
  • Apache Spark
  • Scala
  • AWS Cloud Services
• Participate in cloud modernization and migration initiatives.

• Work closely with business users to gather reporting and analytics requirements.
• Collaborate with developers architects and project managers.
• Provide technical leadership and mentoring to development teams.
• Participate in architecture reviews and solution design discussions.

• IBM Cognos Analytics
• Framework Manager
• Report Studio
• Dashboard Development
• Metadata Modeling

• IBM InfoSphere DataStage
• ETL Development
• Data Warehousing
• Data Migration

• PL/SQL
• Oracle Database
• SQL Optimization
• Data Modeling

• Enterprise Data Warehouse
• Data Integration Architecture
• Reporting Architecture

• Databricks
• Apache Spark
• Scala

• AWS
• S3
• EMR
• Redshift

• Data Governance
• Data Quality
• Performance Tuning
• Agile Methodologies

• 8-10 years of experience in Data Warehousing ETL and BI solutions.
• Strong expertise in IBM Cognos and Framework Manager.
• Hands-on experience with IBM DataStage.
• Strong PL/SQL development experience.
• Experience designing enterprise reporting and analytics solutions.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.