SSRS Developer

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

.Overall 5+ years of experience in application development using Java with creating and deploying microservices using the Spring Boot framework







• Strong experience in Maven.







• Good experience in unit(Junit) and integration testing.







• Experience in Microservices is a must.







Experience in designing and developing REST based services / Microservice development.







• Candidate should have good communication skills (written and verbal)







Excellent analytical and problem solving skills







Any one of these database Mongo, Maria, RMQ, Postgres, or other NoSQL servers







• Experience in AWS and CI/CD







5+ Years







Design, develop, and maintain robust, scalable, and secure backend services and APIs.







• Collaborate with frontend developers to integrate user-facing elements with server-side logic.







Write clean, efficient, and maintainable code following best practices and coding standards.







• Optimize performance and ensure high availability of backend services.







• Implement security measures to protect sensitive data and prevent vulnerabilities.







Design and manage databases, ensuring data integrity and efficient query performance.







Debug, troubleshoot, and resolve issues in production and development environments.







• Conduct code reviews and provide constructive feedback to team members.







Stay up-to-date with emerging backend technologies, frameworks, and best practices.







• Participate in Agile/Scrum ceremonies and contribute to sprint planning and estimations.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Extract the data from XML and load it to dimensional model.
• Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
• Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
• Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Develop T-SQL functions and store procedures to support complex business requirements.
• Create and configure an OLTP replication database for disaster recovery purpose.
• Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

Job Requirements-

Strong in programming fundamentals in C#, jQuery, JavaScript and Sql Server.
-Experience in Developing Web-Based App, SDLC & software engineering, Unit Testing.

• Analyze and document requirements for enhancements to systems and / or business processes.
• Write clean, testable code using .NET programming languages
• Develop technical specifications and architecture
• Test and debug various .NET applications
• Review and refactor code
• Deploy fully functional applications
• Upgrade existing programs
• Document development and operational procedures
• Support junior developers’ work

Technical Competencies

• Strong understanding of object-oriented programming concepts, design patterns and SOLID principles
• Must have hands on experience with C#, ASP.NET, MVC, Windows Services, .NET Entity Framework, SQL Server/T-SQL, IIS and related technologies
• Expertise in REST APIs and WCF
• Strong knowledge of modern techniques such as Responsive Web Design, LINQ, Dependency Injection and Design Patterns
• Strong Skills and experience with web client technologies inclusive of HTML5, CSS3, JavaScript, AJAX, JSON and JQuery
• Knowledge of various industry standard development practices (Agile methodology, OOD, TDD, BDD)
• Proficient with tools to enable SDLC (TFS, Visual Studio, etc.)

Behavioural Competencies

• A go getter attitude with the ability & desire to work in a fast-paced challenging environment
• An innovator mind-set who strives to make things better
• Ability to work independently with the knowledge as well as capability to quickly grasp and make an immediate impact
• Good written & verbal communication skills