Sql Developer

EY; Hyderabad, Gurugram District, Mumbai; Hybrid; INR 700,000 - 1,500,000; Full time

Job summary

EY is seeking a skilled SQL Developer to join our Hyderabad team. You will develop and optimize complex SQL queries, manage stored procedures, functions, and views, and handle large, messy datasets to ensure data quality. Proficiency in Python for automation is a plus.

Ideal candidates will have 3+ years of hands-on SQL Server / T-SQL experience, strong problem-solving abilities, and the ability to collaborate with business and technical teams to meet data requirements.

Qualifications

• Proficient in SQL and T-SQL with hands-on experience in complex queries.
• Experience building and maintaining stored procedures, functions, views and triggers.
• Strong skills with joins, subqueries, CTEs and window functions.
• Ability to optimize queries and work with execution plans and indexes.
• Experience handling large, messy datasets and ensuring data quality.
• Python scripting for data processing and automation.

Responsibilities

• Write and optimize complex SQL/T-SQL queries.
• Develop and maintain stored procedures, functions, views and triggers.
• Leverage joins, subqueries, CTEs, temp tables and window functions.
• Perform query optimization and performance tuning.
• Work with indexes and execution plans to troubleshoot performance issues.
• Handle large datasets and address data quality or consistency issues.
• Perform data validation, reconciliation, cleansing and transformation.
• Use Python for scripting, automation and data processing.

Skills

SQL

SQL Server / T-SQL

Complex SQL queries

Stored Procedures

CTEs & Window Functions

Joins & Subqueries

Query optimization

Data cleansing

Python

Job description

Role: SQL Developer
Experience: 3+ Years
Primary Skills: SQL Server, T-SQL, Complex SQL Queries, Python

Job Description

We are looking for a strong SQL Developer with hands-on experience in developing, troubleshooting, and optimizing complex SQL queries. The candidate should be comfortable working with large, messy, unclean, or inconsistent datasets and should have good problem-solving skills.

Key Responsibilities

• Write and optimize complex SQL/T-SQL queries.
• Develop and maintain stored procedures, functions, views, and triggers.
• Strong hands-on experience with joins, subqueries, CTEs, temp tables, and window functions.
• Perform query optimization and performance tuning.
• Work with indexes and execution plans to troubleshoot performance issues.
• Handle large datasets and identify data quality or data consistency issues.
• Perform data validation, reconciliation, cleansing, and transformation.
• Use Python for scripting, automation, and data processing activities.
• Troubleshoot SQL/database issues and provide effective solutions.
• Collaborate with business and technical teams to understand data requirements.

Mandatory Skills

• Strong hands-on SQL
• SQL Server / T-SQL
• Complex SQL query writing
• Stored Procedures
• CTEs and Window Functions
• Joins and Subqueries
• Query Optimization / Performance Tuning
• Indexing and Execution Plans
• Handling messy / inconsistent data