SQL Developer

Heptarc; Pune District; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Heptarc is seeking an experienced SQL Developer to join our Pune team on a contractual basis with a client. You will design and optimize database solutions, implement SQL procedures, and translate business needs into scalable data models.

You will analyze complex queries, contribute to data warehouse patterns, and work with data architects to align technology directions. The role emphasizes performance tuning, reporting, and mentoring junior staff in a dynamic environment.

Qualifications

• Bachelor’s degree in IT, Computer Science, or related field.
• 5+ years of experience as a SQL Developer or similar role.
• Strong proficiency with SQL and Snowflake databases.
• Experience with performance tuning of complex SQL queries.
• Experience in data warehousing patterns and OLAP design.
• Strong problem-solving and data analysis skills.

Responsibilities

• Development of high-quality database solutions.
• Develop, implement, and optimize stored procedures and functions using SQL.
• Review and interpret ongoing business report requirements.
• Analyze existing SQL queries for performance improvements.
• Gather user requirements and identify new features.
• Provide data management support to users.
• Ensure all database programs meet company and performance requirements.
• Build appropriate and useful reporting deliverables.
• Suggest new queries.
• Provide timely scheduled management reporting.
• Investigate exceptions about asset movements.
• Mentor junior team members as needed.
• Work with data architects to ensure that solutions are aligned with company-wide technology directions.

Skills

SQL Developer

SQL Proficiency

Query optimization

Data warehousing

Performance tuning

Data analysis

Education

Bachelor's degree in IT/CS

Job description

Experience-5 To 9 Year

Location-Pune

Job Type- Contract For Client

Job Description-

Responsibilities:

• Development of high-quality database solutions
• Develop, implement, and optimize stored procedures and functions using SQL
• Review and interpret ongoing business report requirements
• Analyze existing SQL queries for performance improvements
• Gather user requirements and identify new features
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Build appropriate and useful reporting deliverables
• Suggest new queries
• Provide timely scheduled management reporting
• Investigate exceptions about asset movements
• Mentor junior team members as needed
• Work with data architects to ensure that solutions are aligned with company-wide technology directions

Required Skills Technical

• Bachelor’s degree in IT, Computer science, or related field
• 5+ years of experience as a SQL Developer or similar role
• Strong proficiency with SQL and its variations among popular databases (Snowflake)
• Strong skills in performance tuning of complex SQL queries, procedure and indexing strategies
• Experience in designing, OLAP databases using data warehouse patterns and schema’s including facts, dimensions, sorting keys, indexes, constraints etc.
• Query design and performance tuning of complex queries for very large data sets Knowledge of best practices when dealing with relational databases
• Capable of troubleshooting common database issues
• Translating functional and technical requirements into detailed design
• Data Analysis experience, for example – mapping the source to target rules and fields