SQL Developer with Analytics
MotivityLabs · Hyderabad
Collected role description
Role overview
SQL Developer with Analytics at MotivityLabs
Please share your references to Talent@motivitylabs.com / referrals@motivitylabs.com
Responsibilities
- Very good experience in writing simple and complex queries using Joins, String functions, Date functions, Ranking functions, Analytical functions and set operators. - Analytics experience is mandatory. - Strong knowledge in Indexes, Joins, Views, Triggers, Functions & Stored Procedures. - Strong knowledge in creating and using Temporary table, Table Variable and CTE’s (Common table Expressions), Sub-Queries, Derived table and joins to simplify complex queries involving multiple tables. - Expertise in creating, maintaining database objects like Indexes, Functions, views, constraints. - Very good experience in building the Relationship using Constraints. - Strong Knowledge on SQL Profiler to Track the queries. - Experienced in Analysing Execution Plan and managing indexes and troubleshooting deadlocks. - Experience with Data Visualization (PLX Dashboard, Google Spreadsheets, Tableau desktop) creating dashboards and reports, and working with PLX / Google Data Studio.
- Website: https://motivitylabs.com/ Interview Rounds: 3 Technical Rounds followed by HR Round.
Required qualifications
- 5+ Years Roles &
Employment details
- Location: Hyderabad [India]
Additional role details
- Position: SQL Developer with Analytics
Collected experience requirement
5+ Years