Product Manager ll [email protected] ll

🚀 Hiring: MEAN Stack Developer

⭐ Experience: 5+ Years

📍 Location: Pune, Bhopal, Jaipur, Gurgaon, Bangalore

⭐ Work Mode:- Hybrid

⏱️ Notice Period: Immediate Joiners

Passport: Mandatory & Valid

(Only immediate joiners & candidates serving notice period)

Key Responsibilities

• Design and develop high-performance front-end features using Angular and JavaScript/TypeScript.
• Build robust RESTful APIs and server-side logic using Node.js and Express.js.
• Work with databases like MongoDB, caching systems, and cloud deployment environments.
• Optimize applications for maximum speed, scalability, and reliability.
• Ensure responsive, pixel-perfect design and participate in code reviews.
• 
  

Required Skills

• Must-Have: Node.js, Angular, JavaScript, HTML, CSS
• Good to Have: TypeScript, MongoDB, Express.js, Git, CI/CD exposure

Responsibilities

Develop and maintain web and backend components using Python, Node.js, and Zoho tools

Design and implement custom workflows and automations in Zoho

Perform code reviews to maintain quality standards and best practices

Debug and resolve technical issues promptly

Collaborate with teams to gather and analyze requirements for effective solutions

Write clean, maintainable, and well-documented code

Manage and optimize databases to support changing business needs

Contribute individually while mentoring and supporting team members

Adapt quickly to a fast-paced environment and meet expectations within the first month

Leadership Opportunities

Lead and mentor junior developers in the team

Drive projects independently while collaborating with the broader team

Act as a technical liaison between the team and stakeholders to deliver effective solutions

Selection Process

1. HR Screening: Review of qualifications and experience

2. Online Technical Assessment: Test coding and problem-solving skills

3. Technical Interview: Assess expertise in web development, Python, Node.js, APIs, and Zoho

4. Leadership Evaluation: Evaluate team collaboration and leadership abilities

5. Management Interview: Discuss cultural fit and career opportunities

6. Offer Discussion: Finalize compensation and role specifics

Experience Required

5- 7 years of relevant experience as a Software Developer

Proven ability to work as a self-starter and contribute individually

Strong technical and interpersonal skills to support team members effectively

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

Introduction

Ever wondered what it would be like to be a part of the core team of Airbnb or Netflix when they were just starting out? Here’s your chance to try that path with Ohana!

We are looking for a founding engineer to join our team.

Who we are

Ohana is an E-learning platform for holistic learning. We are an angel-funded early stage startup backed by some of the marquee angel investors from India and Singapore. Our investors include Vivek HR (co-founder and CEO, Bounce), Tanushree Gupta (co-founder and CEO, Doubtnut), Jagmal Singh (CTO, Janio Asia) to name a few!

Check us out at https://ohana.academy!

Our Product

“Creativity is as important as literacy” - Sir Ken Robinson

With this belief, Ohana is building the world's largest holistic learning academy. Our product offering:

The Classroom: Offering live online classes on arts, crafts, linguistics, yoga, dance and many more subjects
The Playground: Enabling social learning - a community for kids to find peers with similar interests

Our mission

India has 250Mn kids in the K12 segment. However, except the top 0.1%, most parents can’t find high-quality and affordable holistic learning for their kids. Fortunately, 140Mn kids are now connected to the digital world with 4G access. We want to leverage this new connectivity and bridge the gap in children's overall development with Ohana.

Where are we in our journey

Team: We are a team of two co-founders (Saurabh and Suyash), both IIT Delhi alums with over a decade of experience each in leading consumer businesses. We have a total of 15 people team including 4 engineers (currently outsourced)

Customers: Over the last couple of months, we have grown to 5,000+ registered users and aim to reach 10K+ paid users and 1 Mn+ community strength in the next 12 months.

Young, inspired, and focused - We are ready for take-off!

Our Culture

• “Mission-driven” is not a buzzword for us. We care deeply about the impact we want to create on kid’s lives and we want to exemplify the value of “no child left behind”
• Be inclusive - We are creating a product that is accessible and affordable. We want to solve this not just for Bangalore and Mumbai, but for Indore, Jabalpur, Raipur as well
• Not just customer obsessed - we also care about their well-being. We are willing to compromise profits - but will not resort to unethical sales tactics or compromise on product quality
• Our team cares about a strong culture and respects our code of conduct

Why work for us

• We have global ambitions - Holistic education is a $75Bn global market, with India alone contributing more than $10Bn. Apart from salary compensation, you get a piece of the pie (equity) of a potentially billion-dollar organization
• You will have exposure to building large, scalable systems and will be mentored by people who have done the same for millions of users
• You will have exposure to starting up / entrepreneurship (ever feel like you want to build a startup?) owning end to end consumer tech product which impacts the life of thousands of students/parents on daily level

Job Location

We are based out of Bengaluru and work from an office. We encourage working from office, but are completely ok if you would like to work remotely until things return to normal.

Expectations from the role

• You will work closely with the founding team and a small team of engineers, currently outsourced, in a fast-paced environment.
• You will work as a tech lead and will be responsible for architecting the new features as well as improving the existing codebase. You will be expected to have a high degree of ownership and responsibility for deliverables.
• You will wear a product hat as and when required and help in shaping the product.
• You will provide technical mentorship to other engineers in the team and will lead a team of junior engineers.
• You should be able to deal with ambiguity, have strong bias towards action, ability to deep dive whenever required and quickly deliver to unblock the team

Preferred experience and competencies

• You are a software engineer with 4+ years of industry experience.
• Professional experience with at least one web dev framework (ReactJS or Django/Python)
• Professional experience with one or more (SQL or NoSQL) databases.
• A stint in a product company or a startup or any similar faced paced environment is preferable.
• Experience working with cloud infra providers (e.g., AWS, GCP, Azure etc.) is preferable.
• Strong proficiency in REST API