Fullstack Engineer

Triveni Global Consulting; Ahmedabad District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Triveni Global Consulting is seeking a Full Stack Engineer with a strong backend focus to build ERP and enterprise-grade applications. You will design RESTful APIs with Node.js, implement ERP workflows, and optimize complex SQL queries across MySQL or PostgreSQL databases.

The role also covers frontend work using React.js to deliver data-heavy interfaces. You should be proficient in asynchronous programming, have strong problem-solving skills, and experience with Git-based version control.

Qualifications

• Strong hands-on experience with Node.js and API development.
• Solid understanding of SQL and database design.
• Experience writing optimized queries and handling large datasets.
• Knowledge of async programming and event-driven architecture.
• Working experience with React.js.
• Strong logical thinking and mathematical problem-solving ability.
• Candidates must possess working knowledge of at least one source control or version management system, such as GitHub, Azure DevOps, or TFS.

Responsibilities

• Design and develop RESTful APIs using Node.js (Express.js preferred).
• Implement business logic for ERP workflows such as pricing, accounting, production, and inventory workflows.
• Write and optimize complex SQL queries (joins, aggregations, subqueries).
• Work with relational databases like MySQL or PostgreSQL or similar.
• Use ORM tools such as Sequelize for database operations.
• Implement validation, error handling, and structured logging.
• Ensure API performance, scalability, and reliability.
• Handle transactions and maintain data consistency.
• Develop UI components using React.js (Hooks-based architecture).
• Integrate frontend with backend APIs.
• Build reusable components and handle forms.
• Manage basic state using Context / Redux Toolkit / React Query.
• Implement data-intensive UI components such as grids (AG Grid or similar).
• Ensure responsive UI and cross-browser compatibility.

Skills

Node.js API development

SQL and database design

Optimized queries

Async programming

React.js

Problem solving

Git/GitHub

Tools

Sequelize ORM

MySQL

PostgreSQL

GitHub

Job description

Role Overview

We are hiring a Full Stack Engineer with a strong backend focus to build ERP and enterprise-grade applications. The role involves working on data-intensive systems, implementing complex business logic, and developing scalable APIs. The ideal candidate should have strong problem-solving ability, solid database knowledge, and hands-on experience in Node.js and React.js. Backend capability and logical thinking are the primary evaluation criteria.

Key Responsibilities

Backend Development

• Design and develop RESTful APIs using Node.js (Express.js preferred)
• Implement business logic for ERP workflows such as pricing, accounting, production, and inventory workflows
• Write and optimize complex SQL queries (joins, aggregations, subqueries)
• Work with relational databases like MySQL or PostgreSQL or similar
• Use ORM tools such as Sequelize for database operations
• Implement validation, error handling, and structured logging
• Ensure API performance, scalability, and reliability
• Handle transactions and maintain data consistency

Frontend Development

• Develop UI components using React.js (Hooks-based architecture)
• Integrate frontend with backend APIs
• Build reusable components and handle forms
• Manage basic state using Context / Redux Toolkit / React Query
• Implement data-intensive UI components such as grids (AG Grid or similar)
• Ensure responsive UI and cross-browser compatibility

Required Skills (Must-Have)

• Strong hands-on experience with Node.js and API development
• Solid understanding of SQL and database design
• Experience writing optimized queries and handling large datasets
• Knowledge of async programming and event-driven architecture
• Working experience with React.js
• Strong logical thinking and mathematical problem-solving ability
• Candidates must possess working knowledge of at least one source control or version management system, such as GitHub, Azure DevOps, or TFS.

Good to Have (Trainable Skills)

• Basic knowledge of MongoDB
• JWT-based authentication and authorization
• Experience with RabbitMQ or any messaging system
• Exposure to Socket.IO or real-time communication
• Familiarity with Material UI or similar frameworks
• Basic understanding of Docker and Git workflows
• Strong prompt writing skills for AI-assisted development tools
• Experience using Cursor AI or similar AI coding assistants in real projects

What We Expect

• Ability to convert business requirements into structured logic
• Strong debugging and analytical mindset
• Clean, maintainable, and scalable coding practices
• Ownership-driven task execution
• Ability to work in fast-paced and evolving environments