Overview:Job TitleIBM Cognos & DataStage ArchitectExperience Required8-10 YearsJob SummaryWe 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.
Key ResponsibilitiesArchitecture & Solution Design- 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.
IBM Cognos Development- 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.
Data Integration & ETL- 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.
Database Development- 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.
Cloud & Big Data Integration- Collaborate with cloud and data engineering teams.
- Support integrations with:
- Databricks
- Apache Spark
- Scala
- AWS Cloud Services
- Participate in cloud modernization and migration initiatives.
Stakeholder & Team Collaboration- 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.
Mandatory SkillsIBM Cognos- IBM Cognos Analytics
- Framework Manager
- Report Studio
- Dashboard Development
- Metadata Modeling
ETL & Data Integration- IBM InfoSphere DataStage
- ETL Development
- Data Warehousing
- Data Migration
Database- PL/SQL
- Oracle Database
- SQL Optimization
- Data Modeling
Data Architecture- Enterprise Data Warehouse
- Data Integration Architecture
- Reporting Architecture
Preferred SkillsBig Data- Databricks
- Apache Spark
- Scala
CloudAdditional- Data Governance
- Data Quality
- Performance Tuning
- Agile Methodologies
Required Qualifications- 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.
