Position: SQL Developer with Java
Location: Kansas City KS/Atlanta GA/Frisco TX***Day 1 Onsite***
Duration: 1 Years
JD: Advanced SQL skills
- Maintain existing features troubleshoot bugs resolve ad-hoc requests and work on enhancement (major and minor) /new developments based on business/ client requirements
- Provide client support by presenting data information resolution for client requirements as well as keeping track of schedule for on time delivery of assigned tasks as per the defined quality standards.
- Optimize complex SQL queries and stored procedures for reporting using indexed views execution plan tuning and partitioning strategies reducing average report load time by 70%.
- Use advanced T-SQL constructs including common table expressions (CTEs) cross apply try/catch merge window functions etc.
- Design and maintain ETL pipelines using Azure Data Factory for cloud and hybrid environments.
- Manage CI/CD pipelines for SQL and Power BI artifacts using Azure DevOps and Git.
- Use Azure Boards and Agile tools to manage deliverables and sprint priorities.
- Automate data refresh schedules to ensure up-to-date reporting.
- Utilize DAX to create custom measures and calculated columns for advanced analytics.