Fullstack Developer

Key Responsibilities

Reporting & Analytics Development

• Design, develop, and maintain complex reporting solutions serving mission-critical emergency

response operations

• Build interactive dashboards and data visualizations that transform large datasets into

actionable insights

• Develop advanced analytics features including trend analysis, predictive metrics, and

operational intelligence

• Create self-service reporting capabilities enabling stakeholders to access critical data

independently

• Implement real-time and scheduled reporting systems with appropriate caching and

optimization strategies

SQL & Database Architecture

• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window

functions, and aggregations

• Review existing database architectures and identify performance bottlenecks and optimization

opportunities

• Design and implement database schema enhancements to support evolving reporting

requirements

• Develop and maintain stored procedures, functions, and views optimized for reporting

workloads

• Perform comprehensive query performance analysis and implement tuning strategies across

PostgreSQL and AWS Aurora environments

• Create efficient indexing strategies and data access patterns for large-scale datasets

• Establish data modeling best practices for dimensional and transactional reporting needs

Performance Optimization

• Conduct systematic performance analysis of reporting queries processing millions of records

• Implement query optimization techniques including execution plan analysis, index tuning, and

query refactoring

• Design and implement data aggregation strategies, materialized views, and summary tables for

improved performance

• Monitor and optimize database performance metrics including query response times, resource

utilization, and concurrency

• Develop ETL processes and data pipelines optimized for reporting and analytics workloads

• Implement caching strategies and data archival policies to maintain optimal system

performance

Technical Collaboration

• Partner with Product and stakeholder teams to translate business reporting requirements into

technical solutions

• Conduct code reviews focused on SQL quality, performance, and best practices

• Provide technical guidance to development teams on reporting architecture and database

optimization

• Document database schemas, reporting architectures, and optimization strategies

• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives

Required Qualifications

Experience & Background

• 8+ years of software engineering experience with significant focus on reporting, analytics, or

business intelligence

• 5+ years of hands-on experience writing complex SQL in production environments

• 3+ years working with large-scale databases (millions+ records) and optimizing query

performance

• Proven track record developing enterprise reporting solutions and analytics platforms

• Experience conducting database architecture reviews and implementing performance

improvements

Technical Expertise - SQL & Databases

• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and

advanced aggregations

• Deep PostgreSQL expertise with production experience in query optimization and performance

tuning

• Strong understanding of database internals including execution plans, indexing strategies, and

query optimization

• Experience with AWS Aurora or other cloud-based PostgreSQL solutions

• Proficiency in stored procedures, triggers, functions, and database programming

• Advanced knowledge of database design principles, normalization, and dimensional modeling

• Experience with database performance monitoring and profiling tools

• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)

• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting

interfaces

What You'll Work With

• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures

• Backend: PHP (Yii framework), RESTful APIs

• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries

• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres

• Tools: Git/GitHub, JIRA, Agile development workflows

Work Location

Hyderabad, India - On-site position with flexible working arrangements to accommodate both India

and onsite teams

- Good understanding of NODE JS back-end development

- Strong understanding of Node.js and frameworks available for it

- Understanding of front-end technologies, such as React/Angular, HTML and CSS3
-Solid understanding of object-oriented development and design patterns.

- Good experience with AJAX, REST and JSON

- Experience with development practices such as Test-Driven Development and Continuous Integration
-Experience in Version Control Systems like GIT, Bitbucket
- Must have good problem solving and analytical skills.

- Must be a team player, having good communication skills, self-starter

- Ability to pick up new technology is needed.

About the Job:

As an Odoo developer, you will work together with your technical colleagues, a project manager and functional analysts. You will be building, integrating and maintaining Odoo implementations for our customers.

What we Offer:

● Interesting digital Odoo projects for the biggest Odoo partner in Europe!

● A long term collaboration in a stable and fast growing company with open culture

● A lot of fun and great colleagues!

Role Responsibilities:

● Analyze business requirements

● Develop and customize Odoo modules

● Integrate Odoo with 3rd Party systems

● Troubleshooting

● Share ideas on how to continuously improve the system and way of working

Requirements:

The desired candidate should have below skills:

● Working knowledge of Python with the Odoo-framework (minimum 3 years experience)

● Should be familiar with the latest versions of Odoo.

● Have experience with Object Oriented programming.

● Have knowledge of PostgreSQL.

● Should have experience with Python unit testing.

● Have experience with setup of interfaces between different systems using API’s.

● Should be familiar with Agile and Scrum methodology.

● Have experience with collaboration tools like Git, Buildout, Jira, Confluence, etc

● Have experience with Linux (Ubuntu)

● Experience with other frameworks of Python is a plus.

● Front-end experience (Javascript, CSS, HTML) is a plus.

Non-technical requirements:

● You are available to join us in our Bangalore office from Day 1.

● You have strong communication skills.

● You have strong analytical skills.

● You are customer friendly and service minded.

● You are social, flexible, assertive and have a dynamic mindset.

● You are a teamplayer, but can also work independently.

• Technical skills in C# .NET Core, ASP.NET MVC and Entity framework, LINQ and REST APIs
• Additional skills in MySQL and SQL server, Ajax, jQuery, ReactJS, HTML, Javascript, XML
• Have good analytical ability to breakdown problem statements into solutions
• Working knowledge of various development tools like IDE’s (VS2008 or above), source control systems like TFS, Subversion.
• Good at Troubleshooting, problem solving and has supported customers in production environment
• Experience in Test driven development is desirable.
• Strong written and verbal communication skills and the ability to follow verbal/written instructions
• Ability to troubleshoot assigned technical issues and also the ability to meet tight project deadlines
• MUST have experience in major systems development and implementation
• Leading a team would be an added advantage.

We are searching for Full Stack PHP Developers to join our Tech team. You will work as a part of a Full-stack Tech team that is responsible for all aspects of the ongoing product & services development from the initial specification, through to developing, testing, and launching.

You will be responsible for building multiple platforms; integrating new templates/themes on the platform, maintain the platform etc – end to end development & maintenance of the products & services along with your team of developers.

● PHP 5 or later, MVC frameworks such as Laravel, Code Igniter
● Web services, REST API
● Candidate should have sound knowledge/understanding of Front-end technologies such as HTML & CSS,
JQuery Ajax, Node.js, React JS, Responsive design.
● Server management knowledge such as AWS, apache configuration, linux apt-get, crontab scheduling etc
● Working with MYSQL, writing stored procedures, query optimization.
● Problem solver and go getter
● Write clean, readable code and tests
● Skills of development of basic mobile apps is an addon.
● Candidate's role will require them to communicate with project managers, clients solution architects in the
team and overseas counterparts.
● Be a self-motivated, independent, detail oriented, responsible team-player and exhibit exceptional
relationship management skills
● Help TL/PM in project estimations as & when required

Your skills and experience should cover:

• Excellent programming skills using JavaScript or TypeScript

• 2+ years of relevant software engineering experience

• Proven Node.JS programming skills with knowledge on how to scale huge Node.JS setups

• Experience profiling and optimizing Node.JS applications

• API design and development best practices

• Restful web services, service-oriented architectures

• SQL and NoSQL expert

• Hands-on experience with developing automated tests

• Test-driven development (TDD)

• Experience with SCM systems like Git/SVN

• Experience in Agile software development and continuous Integration systems like Jenkins

The following areas are highly advantageous:

• Experience with Express and Knex

• Experience with Loopback (https://loopback.io/" target="_blank">https://loopback.io/ TypeScript framework)

• Experience/Interest with MySQL or PostgreSQL database