First IT Solutions

Played BI / OLAP architect Role for at least two end to end large engagements

Build reporting and meta-data models in IBM Cognos Framework Manager to support strategic data initiatives

Good understanding of ROLAP / MOLAP functionalities

Knowledge of IBM BI Reference Architecture BI Methodology

Strong knowledge of Dimension Modeling

Extensive knowledge of the IBM IM stack

Enterprise Data Architecture

Full software development lifecycle

Data (logical & physical) Modeling tools and methodologies in data design

Data Warehouse methodologies

Relational and Dimensional Design concepts

OLTP, OLAP and DSS implementations

Oracle, SQL Server Databases, Indices, Views, Etc.

IBM Netezza design and optimization for Cognos BI

IBM Cognos BI (Report Studio, Framework Manager, Workspace Advanced, Query Studio, Analysis Studio, Event Studio)

ETL tool knowledge (Informatica, SSIS, Data Stage)

Willingness to work with multiple project teams in tandem in a technical consultation role.

Excellent analytical and problem solving skills.

Should have excellent communication and customer presentation skills.

Experience and desire to work in a Global delivery environment

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

At least 5 years of experience with DW/BI and ETL tools.

At least 2 years of hands on experience in Design, Development & Build activities in Ab Initio Projects - MUST.

At least 7 years of experience in Project life cycle activities on DW/BI development and maintenance projects and IT

Job Status: Full Time

Eligibility: EAD GC or GC or US Citizens

Share the Profiles to mkonni(at)1stitsolutions.com

Contact: 703-349-1214

Keep the subject line with Job Title and Location