Senior Analyst / Senior SQL Developer

Prasaditya Idea Private Limited; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Prasaditya Idea Private Limited in Mumbai seeks a Senior Analyst Programmer / Senior SQL Developer with 4+ years of experience handling large-scale databases, complex SQL queries, and BI reporting.

You will design and optimize SQL queries, develop SSRS reports, create SSIS ETL packages, ensure data integrity, and collaborate with stakeholders to deliver data-driven insights. Strong analytical skills and the ability to learn new tools are essential.

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field.
• 4+ years of hands-on SQL development experience.
• Proficiency in SQL queries, stored procedures, and functions.
• Experience with SSRS and SSIS.
• Understanding of data warehousing concepts.

Responsibilities

• Design, develop, and optimize complex SQL queries for large data volumes.
• Translate business requirements into technical data solutions.
• Develop and maintain SSRS reports for business and financial reporting.
• Design and manage SSIS packages for ETL processes.
• Ensure data accuracy and integrity across systems.
• Perform performance tuning and query optimization.

Skills

SQL development

Query optimization

Performance tuning

Data analysis

Problem solving

Communication

Education

Bachelor's degree in Computer Science/IT or related field

Tools

SQL Server

Oracle

MySQL

Job description

Job Summary

We are seeking a highly skilled Senior Analyst Programmer / Senior SQL Developer with 4 + years of experience in handling large-scale databases, developing complex SQL queries, and building reporting solutions. The ideal candidate will have strong expertise in SQL, SSRS, and SSIS, along with excellent analytical and problem-solving skills to support business intelligence and data-driven decision-making.

Key Responsibilities

• Design, develop, and optimize complex SQL queries to retrieve and manipulate large volumes of data efficiently


• Analyze business requirements and translate them into technical data solutions


• Develop, maintain, and enhance SSRS reports for business and financial reporting


• Design and manage SSIS packages for ETL (Extract, Transform, Load) processes


• Ensure data accuracy, consistency, and integrity across systems


• Perform performance tuning and query optimization for large databases


• Collaborate with business stakeholders, analysts, and cross-functional teams to understand reporting needs


• Troubleshoot data issues and provide timely resolutions


• Support ongoing maintenance and enhancements of existing data systems


• Document technical specifications, processes, and workflows

Required Skills & Qualifications

• Bachelor’s degree in Computer Science, IT, or related field


• 4+ years of hands-on experience in SQL development


• Strong expertise in:
  
  
  
  • Writing complex SQL queries, stored procedures, and functions
  
  
  • Query optimization and performance tuning
  
  
  • Working with large relational databases (e.g., SQL Server, Oracle, MySQL)
  
  
  
  


• Experience with:
  
  
  
  • SSRS (SQL Server Reporting Services)
  
  
  • SSIS (SQL Server Integration Services)
  
  
  
  


• Solid understanding of data warehousing concepts and ETL processes


• Strong analytical, logical, and problem-solving skills


• Ability to quickly learn and adapt to new tools and technologies

Preferred Skills (Good to Have)

• Knowledge of financial data/reporting systems


• Familiarity with data modeling concepts


• Basic scripting knowledge (Python, Shell scripting)

Soft Skills

• Excellent communication and stakeholder management skills


• Strong attention to detail


• Ability to work independently and in a team environment


• Proactive and solution-oriented mindset

Experience

• 4+ years in SQL development, reporting, and ETL processes

Location

• Lower Parel, Mumbai

Employment Type

• Full-time