
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

Similar jobs
You should understand concepts of Web very well, Web Services Relational Database : MySQL (Good to know PostgreySQL ) NoSQL DB : MongoDB or any other.
Role: FullStack Developer
Experience: 1+ years
Location: Madurai
Mode: Work from office
We have vast experience in delivering high-quality products with significant output on time. We are specialized in creating web and mobile applications with the latest technology. We are expert in developing a perfect solution for rental marketplace services and on-demand businesses done by our proficient team of experts with strong experience in development.
- Minimum of 6 months of real-time experience in React/Node.js/Angular
- Good understanding of structured and unstructured databases (MySQL and MongoDB)
- Knowledge of isomorphic React is an added advantage
- Experience in implementing well-known React workflows such as Redux
- Ability to learn new technologies and languages quickly
- Proficient understanding of code versioning tools, such as Git
- Experience with Javascript backend framework like Express.js
- Good time-management skills
- Experience with Restful API services
- Delivering a complete front end application
- Professional, precise communication skills
- Deep knowledge of Angular/Node.js/React practices and commonly used modules based on extensive work experience
- Good knowledge in Javascript and able to handle Array & Objects built-in methods
- A Good logical thinking and problem-solving skills
- A good team player
MERN stack Developer:
We are looking for a MERN Stack developer to join our team at the earliest. In this role, as a Senior Mern Stack Developer, you will be entrusted with developing JavaScript applications using Node.js, Express, React.js, and Mongo DB. Apply now for the role of a Mern Stack Developer at Pattem that’s opening doors for skilled, energetic developers looking for Mern Stack Developer Jobs in Bangalore. If you can help us design and create multiple layers of applications while working cross-functionally across different infrastructures. You would fit perfectly if you love problem-solving, design, and creating quality offerings.
Know Your Work:
- As a MERN Stack Developer, it’s your responsibility to translate storyboards and various use cases to create high-performing apps
- Write, execute, and maintain clean, reusable and scalable code
- Integrate our various data storage solutions
- Ensure the responsiveness and boost the performance of our apps
- Find and address the various bottlenecks and bug-fixes
- Help in code automatization
What You Need To Apply:
- Previous working experience as a MERN stack developer for 3+ years
- Strong experience with full-stack Javascript framework, Mongo DB, Express, React.JS, Node JS.
- Self-motivated with the ability to work independently or jointly in a self-directed way.
- Demonstrated successful development of enterprise-grade web applications
- Proven analytical and problem-solving capabilities
- Keen attention to detail
- Comfortable leading product development
- Strong work ethic and desire to build industry-leading products
- Proactive instead of reactive
- Looking for ways to improve self and projects
|
Work across the full stack, building highly scalable distributed solutions that enable positive user experiences and measurable business growth |
|
Develop new features and infrastructure development in support of rapidly emerging business and project requirements |
|
Assume leadership of new projects from conceptualization to deployment |
|
Ensure application performance, uptime, and scale, maintaining high standards of code quality and thoughtful application design |
|
Work with agile development methodologies, adhering to best practices and pursuing continued learning opportunities |
|
Visualize, design, and develop creative and innovative software platforms, as we continue to experience dramatic growth in the usage and visibility of our products |
|
Create scalable software platforms and applications, and efficient networking solutions that are unit tested, code reviewed and checked regularly for continuous integration |
|
Examine existing systems, identifying flaws and creating solutions to improve service uptime and time-to-resolve through monitoring and automated remediation |
|
Plan and execute full software development life cycles (SDLC) for each assigned project, adhering to company standards and expectations |
|
Special Skills Required |
Bachelor’s degree in software engineering or information technology |
|
|
2+ years of experience engineering software and networking platforms |
|
|
2+ years of experience in building large-scale software applications. |
|
|
Proven ability to document design processes, including development, tests, analytics, and troubleshooting |
|
|
Experience with rapid development cycles in a web-based environment |
|
|
Strong scripting and test automation abilities, ability to drive a Test Driven Development Model |
|
|
Working knowledge of relational databases as well as ORM and Postgre and other SQL technologies |
|
|
Proficiency with Javascript, Typescript, React.js, Babylon, Nodejs, HTML5, CSS3, and order management systems |
|
|
Proven experience designing interactive applications and networking platforms |
|
|
Web application development experience with multiple frameworks, including Blockchain, Hyperledger, Spark, Kafka, Elasticsearch, neo4j, graphQL |
|
|
Desire to continue to grow professional capabilities with ongoing training and educational opportunities |
|
|
Additional Knowledge in computer vision, embedded, blockchain technologies a plus |
|
|
Experience Designing and integrating RESTful APIs |
|
|
Excellent debugging and optimization skills |
|
|
Unit/integration testing experience |
|
|
Interest in learning new tools, languages, workflows, and philosophies to grow |
|
|
Professional certifications |
|
Location |
Bengaluru, Karnataka, India - 560072 |

• 8+ years of experience into Technical Expertise & People Management
• 5+ Years of Experience into MERN Stack
• Have deep expertise in React.js, Node JS, and MongoDB
• Must have relevant experience in designing, building, maintaining, and extending large-scale production systems.
• Bootstrap, NO-SQL, Backbone Lookout
• Proven leadership skills: courage to challenge with candour, motivate and inspire teams.
• Comfort working with multiple groups within the business
• Strong interpersonal and communication skills, for both technical and non-technical audiences.
About Us: -
We are a fast-growing, US-based EdTech start-up that is shaping the future of education. Our SaaS platform now serves over 10M students in over 8,000 schools across the USA and that number is growing. We are making such a splash that teachers, schools, and districts call us "a game-changer." We are focused on helping teachers teach and students learn and work hard to support educators by providing them with robust ways to track student progress and inform instruction with instant data.
Our employees are the secret sauce to our success. With our team of motivated, positive, and skilled professionals, we continue to maintain, build, and grow a strong product offering. Innovation, listening to customers, and service are at the forefront of what continues to guide us to success. Diligence, excellent team communication, knowing that our work makes a difference, and a good sense of humor are the elements that carry us through each day.
Overview
Xcelpros is a Global company, headquartered in Chicago (US) with multiple locations in US and Bengaluru, India. Our focus is Tech Innovation, Product Development and Technology Consulting.
We are hiring for our Product Development team and have an immediate need for a Backend Developer / Fullstack MERN Developer. The position calls for someone with a mindset who can build great products, manage multiple projects and related tasks on deadline. We are looking for high-quality and passionate developers that want to be a part of a great product team.
You need to have at least 2 years of demonstrated experience as a Backend Developer using MERN (NodeJS, MongoDB, PostgreSQL & Express) & GraphQL technologies. The candidate will work closely with our internal teams in the design, development, launch and enhancement of various products.
About XcelPros
XcelPros is a Global company, headquartered in Chicago (US) with multiple locations in US and Bengaluru, India. XcelPros is focused on Tech Innovation, Product Development and Technology Consulting.
XcelPros specializes in technology solutions for Business-to-Business (B2B) and Business-to-Consumer (B2C) areas. We believe technology is the enabler of exponential growth for us and our customers. We are strategists delivering innovative business and technology solutions. We have been well funded and operational since 2011.
XcelPros and affiliated group of companies are proud to foster a high-performance culture, one that's defined by having the best people, with the skills and determination to deliver above and beyond. We look for insightful and astute professionals who are also forward-thinking, confident, self-motivated and globally minded. Our core team consists of professionals with a wide range of skills and backgrounds. XcelPros is continuously looking for talented, highly motivated individuals who believe in excellence and are committed to providing superior service to our customers and stakeholders.
Experience
- Minimum of 2 years of experience in the design and development of Web and Mobile applications using NodeJS, MongoDB, PostgreSQL, Apollo - GraphQL and React
- You are required to have experience with development in Microservices Architecture
- Experience with NestJS framework is a major plus
- Hands on experience with GoLang is not mandatory but a major plus
Start Date - Immediate
Positions - 2 (Immediate Need)
Responsibilities
- Minimum of 2 years of hands-on experience building applications in NodeJS, MongoDB, PostgreSQL, Apollo - GraphQL and React
- Strong and mandatory experience of 2 years of experience in building applications using the Microservices architecture in NodeJS
- Strong and mandatory skills in Automating Components, Perceptibility, Configuration Management, Debugging & Consistency while writing Microservices.
- Experience building applications using NestJS or similar frameworks is a major plus
- Experience building applications and service integrations using Apollo / GraphQL
- Adhere to best practices of engineering by writing high-quality code.
- Hands on experience in Elastic Search and related technologies
- Hands on experience with one or more testing frameworks such as Jest
- You are required to write / conduct unit & integration testing to ensure code meets high-quality standards
- Collaborate with multiple stakeholders, including Production Support, BAs, Architect, Project Managers, and Product Owners to deliver high quality solutions.
- Develop, build, configure and unit test solutions from low level designs
- Ensure that solutions meet requirements outlined in the design documentation
- Perform all work to agreed time, cost and quality constraints
- Ensure that developed solutions are peer reviewed and formally documented
- Design, develop, test and document detailed technical specifications for application components built using MERN (MongoDB, ExpressJS, ReactJS, NodeJS) stack and integrations
- Develop and maintain high traffic / high performance React and Node based e-commerce web applications and web services, including support for mobile
- Participate in support activities to help UI developers integrate with APIs / services
- Create and maintain scalable infrastructure leveraging modern AWS cloud platforms
- Knowledge of all development aspects within an Agile SDLC framework, including; estimation, design, development, unit test, code reviews, and documentation
- Develop solutions that satisfy business requirements as outlined in user stories, and within agreed upon timelines
- Ensure solutions are of high-quality with regards to following standards and best practices, as well as satisfying security and performance requirements
- Collaborate effectively with other Agile team members
- Work with the Production Support team in the research and resolution of production issues.
- Prior hands-on experience with architecture for Web and Mobile technologies, E-commerce, Payment Gateways, Data security and encryption is a major plus
- Experience with CICD, containers and container management platforms(Dockers, Docker Swarm/Kubernetes, etc.)
- Knowledge of GOLANG is a major plus
- Good understanding of the Twelve-factor App methodology is a major plus
- Experience defining new architectures and ability to drive project from an architecture standpoint is a major plus
- Experience with Security configuration is a major plus
- Experience in understanding platforms & key AWS services like Elastic Beanstalk, AWS Lambda, ECS, AWS Fargate, EKS, EC2, S3 etc. is a major plus
- Troubleshoot and resolve complex technical issues in cloud integrations
- Highest levels of code quality
- Needs to conduct weekly code reviews
- Ensure timely and quality release of the product in collaboration with other team members
- Must be a self-starter and able to build up presence in the team.
- Perform other related duties as assigned
Technical Expertise / Hands-On Skills:
- MERN (MongoDB, ExpressJS & Node JS)
- PostGreSQL
- Apollo GraphQL
- JEST
- RESTAPIs
Key Deliverables
- Develop very high sense of ownership, the zeal to build scalable applications
- Develop a deep understanding of product development and start-up ecosystem
- Work with a performance oriented team driven by ownership and open to experiments
- Build customer facing technology product for global customers
- Collaborate with development teams to help identify and develop reusable platforms/libraries.
Key Requirements
- Can do attitude
- Highly motivated to bring fresh thoughts to the table
- Highly creative and most importantly willing to exercise it
- Self-starter and self-learner focused on research and learning
- Ability to play a variety of roles and most importantly take accountability
- Ability to communicate openly and embrace various perspectives without judgment
- Believe in a ”No politics” attitude. Politics can be detrimental to yourself and the organization.
Job Description :
- In-depth understanding of the entire web development process (design, development and deployment)
- Experience building complex web application.
- Hands on experience with programming stacks like MEAN, MERN, LAMP
- Participate in software/product development from ideation to deployment and beyond.
- Should have good knowledge on build tools like Maven, NPM, NODEJS.
- Optimizing components for maximum performance across a vast array of web-capable devices and browsers; awareness of cross-browser compatibility issues and client-side performance considerations
- Should have a good understanding of database concepts.
- Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model
- Thorough understanding of React.js and its core principles
- Experience with popular React.js workflows (such as Flux or Redux)
- Familiarity with code versioning tools (such as Git, VSTS)
- Working knowledge of Agile/SCRUM development methodologies and best practices.
- Ability to understand business requirements and translate them into technical requirements
- Working on Cloud[AWS/Azure] based environment is a huge plus
- Recommending new policies, approaches, and procedures.
Responsibilities :
- Ability to work with project delivery goal as mindset.
- Use advanced modelling tools & techniques to build full stack applications.
- Strong understanding on how to document and create a functional plan for complex project.
- Knowledge of creating Information Architecture, Server Architecture & State-flow diagram to better understand complex project.
- Ability to take risks, strive for learning & implementing new practice with maintaining project deliverables.
- Be seen as a leader for a group of engineers working to quickly design, prototype and build new features per requirement.
- Strong ability to handle a naive team & able to get the required output delivered.
- Build scalable/reusable code and libraries for future use.
- Interact with other team leads and departments to accomplish a project requirement.
Job brief
We are looking for a full stack developer to produce scalable software solutions. You’ll be part of a team that’s responsible for the full software development life cycle, from conception to deployment.
As a full stack developer, you should be comfortable around both front-end and back-end coding languages, development frameworks and third-party libraries. You should also be a team player with a knack for visual design and utility.
Responsibilities
- Work with development teams and product managers to ideate software solutions
- Design client-side and server-side architecture
- Build the front-end of applications through appealing visual design
- Develop and manage well-functioning databases and applications
- Write effective APIs
- Test software to ensure responsiveness and efficiency
- Troubleshoot, debug and upgrade software
- Create security and data protection settings
- Build features and applications with a mobile responsive design
- Write technical documentation
- Work with data scientists and analysts to improve software
Requirements
- 3+ years of experience as a full stack developer
- Experience developing desktop and mobile applications
- Familiarity with common stacks
- Knowledge of multiple front-end languages and libraries (e.g. HTML/ CSS, JavaScript, XML, jQuery)
- Knowledge of multiple back-end languages (e.g. C#, Java, Python) and JavaScript frameworks (e.g. Angular, React, Node.js)
- Familiarity with databases (e.g. MySQL, MongoDB), web servers (e.g. Apache) and UI/UX design
- Good communication
- Attention to detail
- Enthusiasm and aptitude to learn new technologies
- Team player
- Degree in Computer Science











