Sr. Software Engineer - Sql Job in Ebix Inc

Job Description:

Primary Responsibilities

• The resource will be assigned specific set of tasks in a Product Release or Implementation Project. The set will consist of development activities for multiple Change Requests / Product Gaps, End to End product regression support, supporting implementation team in carrying out Sanity/Smoke test in client environment,onsite support, fixing UAT defects etc...
• Should be hands on in designing, coding, debugging, technical problem solving, prototyping
• Must understand Functional Specification Documents for Change Requests / Product Gaps and perform developments accordingly with zero or minimum number of bugs as per the policy
• Perform unit testing of the tasks with impact completely analysed & tested
• Get the development tasks reviewed & verified by TL

Secondary Responsibilities

• Provide onsite support to clients in India or abroad
• Publish status report for development area assigned
• Analyse defects raised by customer in SIT/UAT and discuss resolution with Business Analyst team members.

Technical Skills

• Proven experience in developing Complex SQL Code in SQL Server 2005/2008/2012
• T-SQL Queries with All Types of Joins in Procedures, Triggers, Cursors
• Ability to write complex stored procedures using Common Table Expression (CTE), Aggregate functions, Cross Tab queries, Pivot & Un-Pivot queries
• Extensive experience in Performance Tuning, Query Optimization, Indexing Strategies etc.

Functional Skills

• Preferably (not mandatory) having exposure to Investment banking / Capital Markets / Private Banking Industry

Soft Skills

• Curious, disciplined, self-starter, fast learner
• Good interpersonal skills, positive attitude
• Thrives among strong colleagues
• Ability to work & deliver under tough timelines
• Builds strong relationship with Business Analysis, Testing and Support teams
• Good Communication skills (spoken & written) is a must
• Ability to Estimate and Plan tasks
• Methodical & Meticulous