Msbi-tech Lead

HR Central
  • Mumbai
  • Confidential
  • 6-8 years
  • 31 Jul 2015

  • Software Design & Development

  • IT/ Technology - Software/ Services
Job Description

Common Skill Set
-- 6-8 yrs of experience in MSBI (SSIS, SSRS and SSAS)
-- Excellent Communication Skils
-- Client/Customer Facing Experience
-- Good in SQL Server Database Concepts including performance tuning
-- At least know Microsoft BIDS and SSDT and their relation with different versions of Visual Studio 2008, 2010 and 2012, .. +
-- Thorough understanding of the ETL as a process, experience in designing the ETL Process and then implementation using SSIS
-- Slow Changing Dimensions, Scripting in SSIS (C# .NET), use of third party components in SSIS
-- Must understand fast load, table load concepts (why and when to use)
-- Caching of data, lookup values in SSIS (caw files or in memory)
-- Package Configurations, Connection Managers
-- Other components of SSIS, such as source, transformation and destination/target
>> Joins, Merge, Sorting, Multicast, Conditional, For Each Task, Script Task, Execute Process Task, File Task, so on
>> Control Flow, Data Flow
-- Thorough understanding of Reporting Services Configuration & Reporting Manager and deployment of reports
-- Using Matrix and table formats, Graphs -Line Chart, Bar Chart, Pie Chart, Bubble Chart
-- Grouping of data using row and column grouping
-- Reporting Parameters (visible, hidden, internal)
-- Data Sources, Datasets (shared, embeded, direct)
-- Inline scripting/coding in SSRS using Visual Basic
-- Inline SQL scripting, stored procedure calls
-- Using expressions in SSRS
-- Dimensions, Cubes, hierarchy (how to use MDX)

Competencies/Skill sets for this job

Tech Lead Ssis Msbi Visual Studio Lookup Scripting

Job Posted By

About Organisation

HR Central