Frontend Developer; backend 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

Web Developer

Job Description

• The web developer will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is a plus
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties & Responsibilities:

• Understand how FTP server is setup for the site
• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Technical Expertise:

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities:

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

Full Stack senior developer with ReactJS & Redux

• Node js with Express framework

• Knowledge of HTML, CSS and Javascript with React JS
• Experience with MongoDB
• Knowledge of RESTful APIs.
• Experience with web paradigms such as REST, Responsive Web Design etc.
• Experience with CI/CD tooling (at least Git and Jenkins)
• Good understanding of code versioning tools, such as GIT
• Good to know Agile/Scrum/Kanban

Job Title: MERN Stack Developer (5+ Years Experience)

Position: MERN Stack Developer

Location: Ahmedabad (On-Site)

Onshore Opportunity

Experience: 5 to 7

Joining: Immediate Joiners Preferred

Employment Type: Full-Time

About the Role

We are seeking a talented and experienced MERN Stack Developer to join our on-site team. As a key member of our development team, you will be responsible for building and maintaining high-performance web applications using MongoDB, Express.js, React.js, and Node.js.

Key Responsibilities

• Develop and maintain scalable, responsive web applications using the MERN stack
• Write clean, efficient, and well-documented code
• Integrate APIs and third-party services
• Work closely with UI/UX designers, QA, and product teams
• Optimize applications for maximum speed and scalability
• Perform code reviews and provide constructive feedback
• Debug and resolve technical issues and bugs
• Ensure cross-platform and cross-browser compatibility

Required Skills & Qualifications

• 5+ years of professional experience with the MERN stack
• Strong proficiency in JavaScript, ES6+, HTML5, and CSS3
• In-depth experience with React.js (including hooks, Redux, component lifecycle)
• Strong backend development skills using Node.js and Express.js
• Proficient in working with MongoDB, including aggregation, indexing, and schema design
• Experience with RESTful APIs and JSON
• Familiarity with Git and version control workflows
• Strong problem-solving and debugging skills
• Excellent communication and teamwork abilities
• 
  

Must-Have Experience

•  5+ years working professionally with the MERN stack
•  Has experience in a team lead role
•  Expertise in JavaScript (ES6+), HTML5, CSS3
•  Deep understanding of React.js (Hooks, Redux, lifecycle)
•  Backend development with Node.js & Express.js
•  Strong hands-on with MongoDB (schemas, indexing, aggregation)
•  API integration, Git, version control, and debugging

Preferred Qualifications

• Experience with deployment on AWS, Heroku, or similar cloud platforms
• Familiarity with containerization tools like Docker
• Experience with testing frameworks such as Jest or Mocha
• Knowledge of agile methodologies

About Company

Our client is in the business of delivering cutting-edge software solutions, hardware systems, and IT services. It lends the right technological edge to governments and businesses. This enables them to achieve their organizational objectives efficiently and effectively to scale their businesses to newer heights.

Minimum Requirements/Qualifications:

• Bachelor’s/Master’s degree in computer science, Computer Engineering or a related field is preferred.

• Must have at least 5 to 7 years of experience in PostgreSQL.

• Sound knowledge of Object-Oriented Programming (OOP) Patterns and Concepts.

• Knowledge & hands-on experience with PostgreSQL, Java, and Spring Framework is a must.

• Additional knowledge of JDBC, Apache TomCat Server & relevant open-source technologies is required.

• Must have experience with Bootstrap CSS, jQuery, etc.

• Basic Understanding of the concepts of MVC (Model-View-Controller) Pattern, JDBC (Java Database

Connectivity), and RESTful web services.

• Experience in handling external and embedded databases.

Roles & Responsibilities

• Maintaining the Database, creating efficient queries, and understanding and improving the current database structure.

• Develop new modules, patches & Updates/upgrades for an existing application (developed in house by the client)

• Analyze user requirements to define business objectives.

• Maintain Java-based applications that can be high-volume and low-latency.

• Identify and resolve any technical issues arising.

• Write well-designed, testable code.

• Conducting software analysis, programming, testing, and debugging.

• Support continuous improvement, investigating alternatives and technologies, and presenting for architectural review.

About the role:

We are looking for a PHP developer, responsible for the development and maintenance of the Websites, CMSs, Services, APIs and MySQL databases (writing procedures and complex queries). The developer will be a part of a full-stack team of engineers.

You will be responsible for -

● Hands on experience in Core PHP and MySQL Database.

● Good experience of relational databases, database keys and joins.

● Clear understanding of Object Oriented Programming, CSS, HTML layout.

● Strong experience in JavaScript, Ajax, Jquery and secure REST API.

● Strong skills in JSON parsing as well as XML for fetching data into the application

● Good knowledge of the application deployment process using FTP.

● Basic knowledge of Unix Command / environment

● Should be able write the code independently.

● Knowledge of PHP frameworks and CMS.

● Candidate should be able to follow Best Practices as they apply to coding Languages

● Collaborate with cross-functional teams to define, design, and implement features.

● Unit-test code for robustness, including use cases, usability, and general reliability.

● Identify and correct bottlenecks, work on bug fixing and improving application

performance

● Continuously discover, evaluate, and implement new technologies to maximize

development efficiency

● Must have specific experience and ability to understand business requirements and

translate them into technical / coding requirements.

● Proficient in understanding of code versioning tools, such as Git.

● Must have strong communication skills and be able to think out of the box to

implement defined business logic with minimal impact and revisions.

● Contribute in all phases of the development lifecycle.

Qualification & Experience:

● Engineering Graduate or Post Graduate.

● BS degree in Information Technology, Computer Science or equivalent

● 3 Years of Professional Experience.

Qualification & Experience:

● Engineering Graduate or Post Graduate.

● BS degree in Information Technology, Computer Science or equivalent

● 3 Years of Professional Experience.

Job Description

We are looking for applicant from top schools and product based technology companies who can play a key technical leadership role.

Responsibilities

• Lead the technical direction of the product.
• Document current, intermediate, and future state technical architectures that support the product’s vision and mission.
• Assist product development teams to provide technical leadership and guidance
• Facilitate and collaborate with scrum teams and product owners to create technical architectural documentation as required.
• Responsible for contributing to the technical direction of the product for the next 3-5 years by incorporating best of breed technologies.
• Provide ongoing evaluation of technology solutions and capabilities to ensure appropriate alignment of business objectives.
• Assess options, risks and cost-benefit analyses as they pertain to data architecture, security, and other technology issues.
• Outline technical recommendations and identify technological requirements that support the product roadmap.
• Develop a technical roadmap that maps to the product’s future state.
• Promote technical standards, guidelines, best practices and quality control measures for enabling and implementing software systems.
• Develop a foundational strategy to scale our platform to meet upcoming growth
• Hands-on coding, code reviews, and leadership of the technical team
• Continuous drive to explore, improve, enhance, automate, and optimise systems and tools to best meet evolving business and market needs
• Attention to detail, coupled with ability to think abstractly
• Create prototypes and proof-of-concepts for iterative development
• Keen to learn new technologies and apply the knowledge in production systems
• Take complete ownership of projects and their development cycle

Additional Requirements:

1. 10+ years of Software Development background.
2. Min 3 Years of working experience as an Architect.
3. Deep background knowledge in software development and architecture with Java for Enterprise solutions.
4. A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field) from IITs and Premier Engineering College.
5. Excellent Object Orientation, coupled with excellent problem solving and debugging skills.
6. Highly skilled at Java and related technologies, including Java Frameworks like Spring-boot or Drop wizard, RESTful web services, J SON, Servlet, JSP, MySQL, MongoDB, Kafka, AWS, Solr.
7. Must have hands-on experience in building scalable and secure back-end systems.
8. Have hands-on experience with systems that are asynchronous, RESTful and demand concurrency
9. Good to have knowledge of best software engineering practices for all stages of the software development life cycle, including coding standards, code reviews, testing, deployment.
10. 5-9 years of software development experience in Java with web architecture and scalable design.
11. Experience with agile development, continuous delivery, and DevOps and related tools.
12. Proactive and communicative to be closely aligned within the Product Management and customer requirements.
13. Strong communication and influencing skills with the ability to develop technical and business artifacts.

1. Exposure to Bigdata related technologies / tools.
2. Exposure to Elastic Search.
3. Large scale application development.
4. Able to manage large data structure and huge volume of data.
5. Exposure of developing interactive graphs and business intelligence tools
6. Object-Oriented design, patterns, algorithms, data structures
7. Exposure to business process workflow.
8. Start up work culture mindset.

ABOUT IDEAPOKE
Emerging Technologies | Bengaluru, India

Ideapoke is a global, fast growing start-up with offices in Bengaluru, Bay Area, Tokyo and Shanghai. Our software, search and insights power the innovation agenda of the largest Fortune 500 and Global 2000 companies worldwide.

Our growth is powered by our people and their unwavering commitment to the company-wide vision, strong work ethic and an entrepreneurial do-it-all spirit. We push the boundaries and break existing thought processes with the strong belief that innovation amplifies success in every piece of work we do and by extension, amplifying the success of our clients.

Ideapoke’s like to constantly learn, grow and make a difference. Join us and be part of our story.