Position: SQL Developer with Analytics
Experience: 5+ Years
Roles & 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.
