CareerBe a part of the future of Healthcare Technology
Senior MSBI Developer
-
Role:
Senior MSBI Developer
No. of years of experience:
5+ years of overall experience and 3+ of relevant experience
Skills Required:
- All scripts Product Knowledge
- Hands on experience on Sunrise Clinical Manger reports development and configuration is must.
- Understanding Of SCM workflow with database understanding is must.
- Understanding on Resource Management System (RMS) and Surgical Information System (SIS) would be an additional advantage.
- Strong design and development experience on MSBI (SSIS, SSRS, ETL and T-SQL with SQL Server 2005, 2008, 2008R2)
- Hands on experience in MSBI Data transformation and logging activities for development and maintenance troubleshooting
- Understanding of complex SSRS design architecture and maintenance
- Should be capable to handle large amount of Data with various transformations and maintenance task in SQL Server with quick turnaround time
- Data analysis capabilities to understand the optimized development and maintenance approach
- Understanding of SQL Job maintenance activities
- Strong troubleshooting skills of SSIS and SSRS Production issues with quick turnaround time
- Should be 5+ years of overall experience and 3+ of relevant experience
- Experience in writing advanced T-SQL, complex stored procedures, triggers, and functions, and performance tuning of SQL queries
- Should be able to create and use SQL DB objects such as views and functions and to write relatively complex SQL queries
- Should be able to do work independently and able to direct interact with customers and clients
Desirable Skills:
- Optimize report performance through database and query analysis in SQL Server and SQL Server Reporting Services
- Self-motivated
- Strong troubleshooting skills
- Strong analytical skills
- Team player
- Ready to work on flexible timings
- Should be flexible to work on call
- Problem visualization capabilities
- Understandings of BI Terminology
- Writing stored procedures, Sql queries, User defined functions, triggers, views, indexing, normalization and de-normalization
- Strong understanding of TQL concepts with performance optimization and execution plan drill down
- Requirement understanding with data analysis for query designing