BI Architect

Best InfoSystems Ltd.
  • Bangalore, Mumbai
  • 10-20 lakh
  • 10-16 years
  • 31 Dec 2015

  • Project/ Program Management IT

  • IT/ Technology - Software/ Services
Job Description

  • About 10 Yrs Relevant Experience (preferably in Banking industry - Large EDW Project delivery)
  • Overall Technical Architecture Landscape Visioning across following Solution stacks

    EDW Layer:

    A) Data Sources, ETL (DataStage/QualityStage), IBM BDW (SOR), Data Mart, Reporting layer (Cognos 10 - Reports/Dashboards/Mobile), transformations/Job Scheduling/data Migration/Archival and Back-up Strategy, Masterdata management , and end-2-end interfaces across solution stack
    B) Data Mining Layer (SPSS/DataStage)
    C) Planning and Budgeting (IBM Cognos TM1) - Optional
    D) Analytical CRM (Unica) - Optional
    E) Sungard (FTP/ALM - Static&Dynamic) - Optional
  • Planning/Visioning of Macro/Micro Design for ETL from Source to SOR to Data Mart
  • Experience of Converting the PDM (SOR) into ETL mappings
  • Planning of Macro/Micro Design for Reports and Dashboards from Source/ Data Model (SOR)
  • Guiding the team toward Source system Study/Gapping/Mapping - Source Extracts and Database Tables (wherever data files not being provided by CBI) with Measures/Dimensions/Attributes in Reports/Cubes
  • Guiding/Visioning the team for Unix/Cron Jobs/Scripts to Pull / Push data
  • Work with ETL Lead to Design from Source to Staging to BDW SOR to Data Mart to Reporting Layer to XBRL (ADF reports submission to RBI)
  • Validate the Design for the Development/Testing/Transport to Test and Production and Performance Tuning, etc.
  • Work with BDW Modeler for Design of BDW Model and Cognos Lead for Design of Reporting Layer
  • Capability to independently handle end to end Macro Design sign off
  • Good knowledge of UNIX scripting, scheduling
  • Responsible for review of architecture from time to time to ensure currency (in case of Change/New Requirements impacting the architecture)

Job Posted By

About Organisation

Best InfoSystems Ltd.