Cognos Analyst

Job description

BI tool -Cognos, Relational Database Knowledge - Tables, Relations, Types, Database Model 3NF, Database Model Dimensional, Database Model STAR, Database Model Schema, MS SQL Server, Data Analysis, DW/BI Knowledge OLPT, DW/BI Knowledge OLAP
Oracle SQL, Empirical understanding of data systems (BI analytics, data blending, data warehousing, data ETL, etc.) on process automation and standardization

Good experience in requirement gathering/ analysis, coding, Unit testing, SIT Support
Knowledge working on both Agile and waterfall models
Develop end to end framework
9+ Years of experience in BI Reporting
5+ Years of experience in designing Cognos Business Intelligence Reporting systems
9+ years SQL development experience either SQL Server, DB2, Oracle, Sybase and MySQL.
Ability to create complex reports requiring multiple parameters, summarizing data with crosstabs, using sections and section underlay for groups, and related report functions
Knowledge of Shell Scripting and BI
Strong written and verbal communication, and proficiency in reporting analysis tools.

Understanding of ETL & DWH Concepts
Core Compliance Domain knowledge
Experience in the Agile Scrum Methodology