Sql Developer

WOW Softech; Vadodara, Gurugram District; On-site; INR 600,000 - 1,100,000; Full time

Job summary

WOW Softech is seeking a SQL Developer in Gurugram to join our BI and data analytics team. You will write and optimize SQL statements, design data models, and deliver robust BI reports. The role requires strong SQL skills and hands-on SSIS/SSRS experience.

Ideal candidates have 4+ years of experience, a relevant bachelor's degree, and a track record of delivering scalable ETL solutions using BI tools such as Power BI, MicroStrategy or Oracle BI.

Qualifications

• 4+ years of SQL development experience.
• Proficiency in SSIS and SSRS.
• Experience with large SQL queries and data warehouses.
• Familiarity with BI tools like Power BI, MicroStrategy, Oracle BI.
• Bachelor's degree in a relevant field.
• Experience with data analytics and ETL processes.

Responsibilities

• Write and optimize SQL statements for in-application use.
• Ensure performance, security, and availability of databases.
• Prepare documentation and specifications for BI projects.
• Profile server resource usage and optimize as needed.
• Collaborate with team members and stakeholders to translate business needs into technical specs.
• Design, build and deploy BI solutions and reporting tools.
• Maintain and support data analytics platforms such as MicroStrategy.
• Create tools to store data (e.g., OLAP cubes) and conduct analyses.

Skills

SQL

SSIS

SSRS

5+ years

SQL Queries

Education

Bachelor's degree

Tools

Power BI

MicroStrategy

Oracle BI

Job description

Must Have

• SQL Experience
• SSIS
• SSRS
• 5 Years is must have experience
• Strong experience in SSIS & SSRS
• SQL Queries

POSITION NAME: SQL Developer

EXPERIENCE REQUIRED: 4+ years

LOCATION: Gurugram

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Help write and optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• Translate business needs to technical specifications
• Design, build and deploy BI solutions (e.g. reporting tools)
• Maintain and support data analytics platforms (e.g. MicroStrategy)
• Create tools to store data (e.g. OLAP cubes)
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requested projects
• Develop and update technical documentation

SUPERVISORY RESPONSIBILITIES: NO

QUALIFICATIONS

• Strong proficiency with SQL and its variation among popular databases
• Experience with some of the modern relational databases
• Skilled at optimizing large complicated SQL statements
• Knowledge of best practices when dealing with relational databases
• Capable of configuring popular database engines and orchestrating clusters as necessary
• Proven experience as a BI Developer or Data Scientist
• Industry experience is preferred
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude

EDUCATION

• Bachelors degree in relevant field