hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

MSBI Developer

8.00 to 10.00 Years   Chandigarh   18 Oct, 2021
EMERSON INNOVATION CENTER
Job LocationChandigarh
EducationNot Mentioned
SalaryNot Disclosed
IndustryManufacturing
Functional AreaWeb / Mobile Technologies
EmploymentTypeFull-time

Job Description

*Description / SummaryWe have been having good growth on the SQL server as a service instances, we are now getting more demand on supporting instances where we need expertise in MSBI (SIS) Developer who can help identify and help troubleshoot MSBI related issues. Team is supporting 24*7 instances operations., *Following is the

  • Experience in Data Design and Development on Microsoft SQL Server, T-SQL, Performance Tuning, Troubleshooting, SSIS,MS cubes, SSRS, SSAS and Data-warehousing.
  • Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
  • Extensive knowledge of Normalization and Relational Database Management Systems.
  • Good understanding in database and data warehousing concepts (OLTP & OLAP).
  • Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
  • Great ability to create and manage various database objects like tables, views.
  • Excellent SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
  • Experience in Performance Tuning and Query Optimization.
  • Experienced in using ETL tools in (SSIS) MS SQL
  • Hands on experience in using ProClarity to browse cubes, create views and books.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and third part DB systems.
  • Data analysis and data migration by transferring them using SSIS packages.
  • Experience with logical and physical data modelling and database design using Erwin.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in modifying MDX Cubes and Dimensions in SSAS.
  • Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
  • Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
  • Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
  • Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
  • Experience 8+ years

Keyskills :
ssisdatabase designetl toolsssrssql serverms sqldata warehousingdatabase managementsql server analysis servicessqlstored proceduresetlmicrosoft sql serverperformance tuningreporting services

APPLY NOW

MSBI Developer Related Jobs

© 2019 Hireejobs All Rights Reserved