CareerBe a part of the future of Healthcare Technology

Senior MSBI Developer

  • Role:
    Senior MSBI Developer
    Gurgaon, India
    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