Software Solutions Engineer II

Duckcreek (Chandigarh, CH, India) 2 days ago

Senior Analyst – SQL Development is responsible for understanding business requirements ,designing and developing database solutions for manageability, scalability and performance. He will work closely with business analysts, project manager, other development team members to build and deliver database solutions. The role also entails technical mentoring of other SQL Development team members.


  • Understand data model of the products within the insurance domain
  • Develop Conceptual, Logical and Physical Design of the database based on business requirements
  • Develop and test stored procedures, views, triggers and functions
  • Optimize performance stored procedures, views, triggers and functions
  • Develop and maintain SQL Server Integration Services (SSIS) packages for Extraction Transform and Loading (ETL) processes
  • Develop, maintain and enhance SSRS reports, queries and data exports
  • Perform detailed data analysis on data related defects
  • Provide extracts business users the data required for metrics and analysis
  • Create and maintain data models and documentation for all projects


  • Experience with Microsoft SQL Server Management Studio (SSMS), TSQL and Stored Procedures
  • Experience working with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Experience in Data modeling principles and techniques
  • Experience in performance optimization of Stored Procedures and SQL Queries
  • 4 or more years of experience as a Database Developer.
  • Design and develop Stored Procedures
  • Strong oral and written communication skills
  • Strong trouble shooting and problem-solving skills
  • Strong analytical skills
  • Should be a quick learner.


  • Experience with Insurance and/or Financial Reporting systems will be an added advantage
  • Experience in Data Warehousing and BI Tools
  • Four-year degree, or equivalent work experience


  • IT Park Chandigarh.

Software Solutions Engineer II

Apply On Company Site
Back to search page