Extensive experience in working with MS SQL server database including creating database objects such as tables, views, stored procedures, functions, and triggers
Extensive experience in writing queries using CTE, sub queries, joins and temporary tables
Experience in maintaining the database integrity by identifying and creating required constraints
Experience in writing dynamic SQL queries and knowledge on linked servers
Experience in working on indexes
Experience in using SQL built-in functions and user define functions
Should have experience in performance tuning and query optimization
Should have experience in error handling.
Should have good understanding on transactions in SQL Server
Experience in creating SSIS packages and all data flow task transformations is a plus
Experience in loading data from flat file, Excel, and other sources
Should have good knowledge on data modeling
Experience in SSRS and Power BI would be an added advantage
Knowledge on SQL Agent jobs and Autosys
Good to have knowledge on Infrastructure and ServiceNow data
Is comfortable in a fast-paced, dynamic work environment
Can manage multiple tasks simultaneously; pays close attention to detail
Is capable of following through on all assignments
Possesses exceptional oral and written communications skills
