Programmer Analyst - SQL / Webservices

About the Role :

We are looking for a detail-oriented and technically strong Programmer Analyst to join our development team.

In this role, you will be responsible for designing, coding, testing, and supporting web-based applications and data-driven solutions.

You will also work closely with cross-functional teams to understand business requirements, perform system analysis, and deliver scalable solutions aligned with the projects goals.

The ideal candidate has hands-on experience with SQL, web services, server integration, and a solid understanding of the full software development lifecycle (SDLC).

This is a highly collaborative role that requires strong analytical thinking, problem-solving ability, and a passion for solving real-world business problems through Responsibilities :

• Understand, analyze, and document business and technical requirements.
• Collaborate with business analysts and stakeholders to translate use cases into technical specifications.
• Participate in the estimation and scoping of new projects and modules.
• Design and develop efficient, reusable, and reliable application components using industry best practices.
• Write clean and maintainable code, with proper documentation, following coding standards and SDLC.
• Develop and maintain database logic using MySQL, including DDL, DML, and DCL operations.
• Work on web-based applications, web services (REST, SOAP), and device-server integration using JSON and XML.
• Exposure to Amazon AWS Glue services and ability to integrate ETL / data processing pipelines is a strong plus.
• Evaluate and integrate open-source frameworks / technologies to improve application capabilities.
• Support data migration, transformation, and integration with external systems or APIs.
• Perform unit, module, integration, and system testing to ensure functionality and performance.
• Debug and fix issues reported by QA, business teams, or end-users.
• Conduct code reviews and peer reviews to ensure quality and maintainability.
• Enhance and maintain existing applications, troubleshoot bugs, and provide post-deployment support.
• Perform database performance tuning and ensure data integrity and security.
• Provide technical support to cross-functional teams and departments as needed.
• Research and recommend tools, technologies, and frameworks that could enhance productivity and application performance.
• Suggest innovative solutions and contribute to architectural discussions.
• Participate in process improvements and ensure adherence to standard development Skills & Qualifications :
• 3 to 6 years of hands-on experience in software development and analysis.
• Strong MySQL knowledge, including writing complex queries, stored procedures, functions, and optimization.
• Proficient in DDL (Data Definition Language), DML (Data Manipulation Language), and DCL (Data Control Language) commands.
• Solid understanding of web-based application development using modern frameworks and technologies.
• Experience with JSON, Web Services (REST / SOAP), and device-to-server communication.
• Strong understanding of software engineering principles, data structures, algorithms, and design patterns.
• Knowledge of SDLC, including Agile / Scrum methodology.
• Excellent analytical, problem-solving, and debugging skills.
• Good understanding of version control systems such as Git.
• Strong communication and interpersonal skills; ability to collaborate across teams and work independently when required

(ref : hirist.tech)