Sql Developer
- anblicks
- 5 - 10 years
- Hyderabad
- 4 months ago
- Email to a friend
- Report this job
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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: Data AnalystEmployement Type: Full timeContact Details:
Company: Anblicks SolutionsLocation(s): Hyderabad+ View Contact
Keyskills: SQL Development Data Modeling Data Warehousing
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
anblicks
Anblicks, a team of specialists in strategic dUnlock the full potential of your data with Anblicks, a team of strategic data modernization experts. Our tailored services cover seamless data migration, robust re-architecture, and transformative solutions. The AIM Framework from Anblicks, encompassi...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in