5 - 10 years

20 - 27 Lacs

Posted:Just now| Platform: Naukri logo

Apply

Work Mode

Hybrid

Job Type

Full Time

Job Description

Please Immediate to 15 Days joiners APPLY

SQL developers / analytics engineers:

SQL Expertise

  • Mastery of window functions: Proficient with ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LEAD(), LAG(), and other analytic functions for complex data analysis.
  • Advanced aggregation techniques: Skilled in using GROUPING SETS, ROLLUP, and HAVING for multidimensional summaries.
  • Recursive queries: Able to write and optimize recursive Common Table Expressions (CTEs) for hierarchical or complex data structures.
  • Dynamic SQL: Experienced in constructing and executing SQL statements dynamically for flexible query logic.
  • Pivoting and unpivoting data: Uses PIVOT and UNPIVOT operations to reshape datasets for reporting and analysis.
  • Error handling and control-of-flow: Uses TRY...CATCH, CASE, and conditional logic to manage complex workflows and exceptions.
  • Performance optimization: Understands how advanced functions impact query plans and applies indexing, partitioning, and statistics to maintain performance.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Anblicks Solutions logo
Anblicks Solutions

Information Technology and Services

Frisco

RecommendedJobs for You

noida, new delhi, greater noida