SEO Executive

Job Title: MERN - Full Stack Developer

Job Description:

We are seeking a highly skilled MERN Full Stack Developer to join our team. The ideal

candidate will have experience developing and maintaining web applications using the

MERN stack (MongoDB, Express.js, React.js, and Node.js).

Responsibilities:

 Design and develop web applications using the MERN stack

 Build and maintain efficient, reusable, and reliable code

 Collaborate with other team members to identify and solve complex problems

 Ensure the performance, quality, and responsiveness of applications

 Troubleshoot and debug applications as needed

 Stay up-to-date with new technologies and programming languages

Requirements:

 Minimum 3 years of experience in full stack development in the MERN stack

 Strong experience with the MERN stack (MongoDB, Express.js, React.js, and Node.js)

 Proficient in JavaScript and TypeScript

 Experience with web development frameworks and libraries such as React, Angular, or

Vue.js

 Experience with Git and version control

 Strong understanding of web development principles and best practices

 Good understanding of RESTful APIs

 Strong problem-solving and debugging skills

 Good communication skills and ability to work in a team environment

 Experience with cloud-based platforms such as AWS or Azure or GCP

 Event-driven and Microservices architectures; Understanding the nature of

asynchronous programming

 Experience with implementing run-time architecture services (caching, logging, etc.)

 Experience with Test Driven Development

 Experience using Containers - Docker, Kubernetes

 Experience with Agile development methodologies

Location: Mumbai

Work arrangement: Flexible. Includes hybrid. Mon-Fri. Visit https://www.solarsquare.in/ to

learn more

We are seeking a skilled Flutter Developer with a strong command of Dart, REST API integration, and UI/UX enhancements. The ideal candidate will have experience with redesigning UI components to improve the user experience while leveraging MVM and MVVM architectural patterns.Additionally, a knowledge of Java, JSP, Servlets, AJAX, SOAP, and REST APIs will be considered a plus. Familiarity with SVN for version control management and production-level deployment is also essential.

Responsibilities:

Develop, maintain, and enhance mobile applications for iOS and Android using Flutter.

Collaborate with design teams to redesign UI components for improved usability, aesthetics, and performance.

Implement responsive design practices to ensure a seamless user experience across various devices and screen sizes.

Integrate REST APIs and ensure smooth communication between mobile apps and backend services.

Apply MVM and MVVM architectural patterns for scalable, maintainable app development.

Collaborate with backend teams for API integration and optimize app data handling.T

roubleshoot, debug, and resolve issues related to performance, UI bugs, and API interactions.

Manage version control processes using SVN, including handling code branches, merges, and revisions.

Set up CI/CD pipelines for streamlined testing, building, and deployment processes.

Oversee production-level deployment, including Google Play and App Store submissions.Write unit and widget tests to ensure stability and reliability.

Stay updated on the latest Flutter, Dart, and mobile development trends.

Required Skills:

Proficiency in Dart programming and experience building mobile applications using Flutter.

Strong experience in UI/UX design and redesigning UI components for improved user experience and performance.

In-depth knowledge of MVM and MVVM architectural patterns for scalable and maintainable Flutter apps.

Strong experience with REST API integration, including handling JSON data in Flutter applications.

Familiarity with state management solutions such as Provider, Riverpod, or Bloc etc.

Experience using SVN for version control management, including handling branches, merges, and revisions.

Solid understanding of unit testing and widget testing in Flutter.Knowledge of CI/CD tools and practices for efficient app testing and deployment.

Experience with production-level deployment processes for App Store and Google Play submissions.

Preferred Qualifications (Plus Points):

Java development experience, particularly in building backend services.

Knowledge of JSP, Servlets,AJAX and web application development.

Familiarity with SOAP and REST APIs for integrating backend services with mobile apps.

Experience with cloud services such as Firebase, or Google Cloud Console for backend integration.

Understanding of mobile app authentication (OAuth, JWT) and API security practices.

Familiarity with native Android/iOS code and experience working with Flutter plugins.

Strong understanding of mobile app performance optimization and debugging techniques.

Education & Experience:

Bachelor’s Degree from IIT, DTU, BITS in any Engineering field (required).

Preference for an additional MBA degree from a top business school.3-7 years of experience in Flutter development, with a strong focus on UI enhancements, version control management, REST API integration, and SVN.

Additional experience with Java, JSP, Servlets, AJAX, SOAP, and REST APIs will be highly regarded.

Job Types: Full-time, Permanent

Benefits:

• Paid sick time
• Paid time off
• Provident Fund

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

Position Overview:

We are seeking a highly skilled and experienced Senior Visual Designer with a deep understanding of UI principles and a proven track record of excellence in the field. As a key member of our creative team, the ideal candidate will bring a wealth of design expertise, strategic thinking, and innovative solutions to enhance the user experience across various digital platforms. If you are passionate about creating visually stunning and user-friendly interfaces and have a minimum of 5 years of professional experience, we invite you to apply for this exciting opportunity.

Qualifications:

1.    Bachelor's degree in Design, Visual Arts, Communication, or a related field.

2.    Minimum 3- 5 years of professional experience as a Visual Designer, with a strong emphasis on UI design.

3.    Proven track record of successful projects showcasing your design and copywriting skills.

4.    Proficiency in design tools such as Adobe Creative Suite, Sketch, Figma, or similar.

5.    Strong understanding of UI principles, design thinking, and user-centered design.

6.    Excellent copywriting skills with the ability to craft clear, concise, and compelling messaging.

7.    Exceptional portfolio demonstrating your design and copywriting capabilities.

8.    Strong communication and collaboration skills

Responsibilities:

●     Collaborate with cross-functional teams, including product managers, developers, and fellow designers, to understand project goals and requirements.

●     Design and conceptualize visually appealing user interfaces for various digital platforms, ensuring a seamless and delightful user experience.

●     Integrate strategic copywriting skills to create engaging and persuasive content that complements the visual design and enhances the overall user experience.

●     Develop and maintain design systems and guidelines to ensure consistency across all digital touchpoints.

●     Stay current with design trends, industry best practices, and emerging technologies, and apply these insights to your work.

●     Conduct user research, analyze feedback, and iterate on designs to continuously improve user satisfaction.

●     Provide mentorship and guidance to junior members of the design team.

1. Design cloud infrastructure that is secure, scalable, and highly available on AWS, Azure and GCP
2. Work collaboratively with software engineering to define infrastructure and deployment requirements
3. Provision, configure and maintain AWS, Azure, GCP cloud infrastructure defined as code
4. Ensure configuration and compliance with configuration management tools
5. Administer and troubleshoot Linux based systems
6. Troubleshoot problems across a wide array of services and functional areas
7. Build and maintain operational tools for deployment, monitoring, and analysis of AWS, Azure Infrastructure and systems
8. Perform infrastructure cost analysis and optimization

Description of Skills/abilities:

We are looking for a great JavaScript developer who is proficient with React.js. Your primary focus will be on developing user interface components and implementing those with well-known React.js workflows such as Redux. You will ensure that these components and the overall application are robust and easy to maintain. You will coordinate with the rest of the team working on different layers of the infrastructure. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product is a must.

You will be responsible for architecting and building the applications, as well as coordinating with the teams responsible for other layers of the product infrastructure. Building a product is a highly collaborative effort, and as such, a strong team player with a commitment to perfection is required.

Responsibilities

1. Developing new user-facing features using React.js, React hooks.
2. Building reusable components and front-end libraries for future use.
3. Translating designs and wireframes into high quality code.
4. Optimizing components for maximum performance across a vast array of web-capable devices and all browsers.
5. Build pixel-perfect, buttery smooth UIs across all web browsers.
6. Diagnose, fix bugs, maintain code and write automated tests to ensure the product is of the highest quality.
7. Key understanding about Object Oriented Programming, Web Architecture, SDLC, Rest Framework.
8. Should have understanding in Hybrid App Ecosystem, Code Once - Deploy Anywhere thought process.
9. Responsible for development of new highly-responsive, web-based user interface.
10. Construct visualizations that are able to depict vast amounts of data.
11. Work with product team and graphic designers.
12. Develop a flexible and well-structured front-end architecture, along with the APIs to support it React.js developer requirements and qualifications.
13. Support the entire application lifecycle (concept, design, test, release and support). Produce fully functional web, mobile applications writing clean code.

Skills

1. Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model.
2. Thorough understanding of React.js and its core principles.
3. Having Experience with popular React.js workflows such as Redux.
4. Familiarity with newer specifications of Typescript.
5. Having Experience with data structure libraries (e.g., Immutable.js).
6. Knowledge of isomorphic React is a plus.
7. Familiarity with RESTful APIs.
8. Knowledge of modern authorization mechanisms, such as JSON Web Token.
9. Familiarity with modern front-end build pipelines and tools.
10. Experience with common front-end development tools such as Babel, Webpack, NPM, etc.
11. Familiarity with code versioning tools such as Git, SVN.
12. Knowledge of functional or object-oriented programming.
13. Ability to write well-documented, clean typescript code.
14. Rock solid at working with third-party dependencies and debugging dependency conflicts.
15. Understanding of REST APIs, the document request model, and offline storage.

Skill Set:

React, React Hooks, Redux, and Typescript with minimum of 6+ Years of relevant Experience.