Detailed JD:
Np- 15days to Immediate
S.NoJD - SQL/DWComments
1. Good understanding of different SQL Joins Required
2. Hands-on SQL writing, Aggregate, CTE, DML , DDL , constraint Required
3. Analytical functions query writing, transactional control implementation Required
4. Very good understanding on Views, Indexes, cursors Required
5. Very good understanding different table Partitioning types & it?s implementation Required
6. Hands-on experience on writing on SQL Server Triggers Required
7. Hands-on experience on writing Stored Procedure, scalar/table valued functions, UDF, Troubleshooting code, Exception handling Required
8. Understanding on SQL Always ON, RDBMS architecture Required
9. Understanding on DW concepts Required
10. Understanding of query plans Required
11. Understanding on Code checkin/Checkout, branching, merge strategies Required
12. Basic understand on Unix/Linux commands Required
13. Basic understanding on Scheduling tool such as (Autosys, Control-M or any equivalent tool)Required
14. Understanding on DevOps such as preferably (GIT, TeamCity, Jira, Confluence)Required
15. User , roles, privs, schema Required
16. Advanced performance tuning - Profiling, Execution plan, SQL Trace Good to have
17. Exposure on any ETL tool such as Informatica, Ab-Initio , MS - SSIS Good to have
18. Understanding on DMV Good to have
19. Understanding on System information schema views Good to have
V 0.0.1