Primary Skill: SQL

Secondary Skill: Testing

JD:

• Having relevant experience of 7 years in SQL testing
• Experience in MSSQL Joins: Inner, Left, Right, Full outer and cross joins practically.
  Should be able to explain practical questions
• Handling In-built Functions: Date, aggregate, Conversion, Numeric, Null handling and Ranking functions.
• Set operators: Union, Union all, Intersect, Except
• Use of Temp tables
• CTE and recursive CTE
• Experience in using DML/DDL
• Arithmetical/calculations implementation in complex queries
• Window function and case statement usage in different practical scenarios
• Experience in Teradata
• Experience in Functional testing concepts
• Experience in SSIS, Informatica, Oracle, Putty and WinSCP is added advantage