Mandatory Technical / Functional Skills 8-10 years hands on database experience including database development and administration within Microsoft SQL Server environment which includes SQL Server, SSIS, SSAS and Power BI. Proven experience in strategies/techniques for implementing data warehousing/BI support systems.
Must be proficient using Script task in SSIS Proficient with complete MS BI stack, including database design, optimization, and SSIS/SSRS/SSAS (Multi-dimensional and Tabular)/Power BI Experience developing, delivering and maintaining SSAS cubes (MultiDimensional & Tabular) Must have strong experience and should be experienced with Cubes To design and suggest and recommend how the current process can be improved better . Must have experience in working with diversified teams in an onsite and offshore model Must have strong communication / Written skills Should be capable to meeting all the deliverables as per the Agile model Experienced in Agile Methodology Experience with SSMS, SSRS, SSAS, SSIS, TFS. Very strong, experienced building solutions using Microsoft SQL Server Integration Services (SSIS), . Extensive knowledge of relational and multi-dimensional data design and development techniques cube design, ETL and others. Good in writing SQL, creating Stored Procedures, Index, Triggers, Views.
Roles and responsibility Manage BI tool set and compel best practices for use with business and project teams. Provide business and project teams with a consistent level of service and problem resolution. Engage Daily, weekly and Monthly status review meeting with key customer stakeholders - Managers, Directors and Senior directors Identifying and diagnosing opportunities and network architecture/design Designing and reviewing the code developed by Team.
Identifying best practices in measuring and visualizing impact of product and visualize the "to-be" system. Total experience in required skill (years) 8-10 years of experience
Tata Consultancy Services