Job title: Java SQL
Support
Experience:
3-7 Years
Notice
period: Immediate to 15 days
Location: Delhi
JD:
· Advanced SQL queries (should know
extensive usage of aggregate functions in SQL)
· SQL procedures and functions
(candidate should be proficient in debugging of SQL stored procedures and
functions)
· SQL server jobs (candidate should
have basic idea about the SQL server jobs)
· SQL performance tuning (increasing
performance of existing SQL objects)
· Data Analytics (candidate should be
able to understand the data structures and link the data entities in the
application universe by studying the data)
· Troubleshooting of web applications
(candidate should have prior knowledge of troubleshooting of web applications
to find and fix issues)
· ETL (knowledge of SSIS - ETL is
required for debugging and development of data transfer services)
· Reporting (basic knowledge of SSRS reporting is required for troubleshooting web
reports)
Nice to
have:
· Windows Task Scheduler (Creation and
maintenance of scheduled tasks)
· Implementation knowledge of SCD
using SSIS or other ETL tools
· Web applications using Spring boot
framework
· VUE JS (basic knowledge)
· MS Excel (knowledge of MS Excel for
data representation and data visualization)
· SCM Domain knowledge will be
additional advantage to candidate