Excellent Opportunity for Full Stack 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

Job Description for PHP Developer :

• Experience – 1- 6 yrs

• Qualification- MCA /B. Tech, BE/BCA

• Job Nature - Permanent

• Skills - PHP, Java, C, C++, MYSQL, CSS, Jquery

• Working days - 5

Description:

• Should have hands-on experience in Web Development

• Good understanding of PHP and Object-oriented programming paradigm.

• Able to understand project requirement and handle project independently.

• Strong learning capability.

• Having a good knowledge of Jquery.

• Framework experience would be beneficial.

• Should be comfortable to work with the team.

• Should be comfortable with work on any MVC based framework.

Skills required:

• Able to understand project requirement and handle project independently.

• Strong learning capability.

• Contribute in all phases of the development.

• Knowledge of PHP/CodeIgniter/Laravel/Magento/Symfony/Wordpress will be preferred.

• Basic Knowledge of JavaScript, Web Services.

• Sound knowledge of php,mysql,Jquery etc.

Perks & Benefits:

• Employees Family Health Insurance, EPF & ESIC.

• Employee Health Insurance.

• Late-night meal facility.

• Innumerable in house & outdoor party.

• Cab facility available in late-night working.

• Various compensations & bonuses.

• No dress code

• Festival Celebration

• Employees B'day celebration.

• Hobby club

• Mini Gym

• Cafeteria facility

• Work from Home

• A hands-on application developer who is passionate about Java development, building highly scalable and resilient applications, and focused on solving complex business problems
• He/She will have responsibility for unit-level design, coding, unit testing, integration testing, and participating in the full SDLC
• He/She will be expected to produce high-quality code that can pass critical peer review, and to work under a high-pressure and timeline-driven environment.
• Actively participate in development along with team members in creating modules & systems that can be treated as a working reflection of the best practices

Qualifications

• Bachelor’s degree or higher in Computer Science or Engineering equivalent
• Minimum of 3 years’ experience in Java development
• Responsible, organized and possess critical thinking with good interpersonal and communication skills
• Able to demonstrate good analytical problem-solving abilities and strong leadership aptitude
• Able to work at both abstract and detailed level
• Must be fluent in English, and strong communication skills.
• Motivated self-starter that likes to work as part of a team

Technical Requirements

• Strong experience in Core Java 8 and above, Collections and Data structures.
• Develop solutions using core java, Spring / Spring Boot, JSON, Rest API and other web technologies
• Hands on with UI development with strong experience in HTML5, JavaScript, CSS3, Responsive UIs. Added advantage for exposure to Angular. Knowledge on Liferay will be added advantage. Ability to design and develop UIs and end to end integration.
• Object oriented analysis and design using common design patterns
• Excellent knowledge of Relational Databases, SQL and ORM technologies (Hibernate and Mybatis)
• Strong knowledge of test-driven development and continuous integration
• Preference towards candidates having excellent Java multi-threading skills
• Passion for collaboration and working on agile teams
• Develop and Consume Web Services using REST.
• Enforcing and Writing code following good standards (well documented with good code coverage and properly tested code)

Vacancy Magento Developer

About us

We are Light Tree Ventures, a company specialized in Research, Development and Manufacturing of LED Light Therapy products for beauty and health. We have offices in the Netherlands, China, the US and India, with our headquarters in Rijswijk.

Our team of professionals are the heart of our company and encompass a wide variety of cultures, skills and competences. We love our work and share the ambition to be the best at what we do: create meaningful, well-designed products for LED Light therapy markets worldwide.

Light Tree Ventures (LTV) works with brands from all over the world. We develop custom light therapy devices that are being sold online and offline (in Sephora e.g.). This development is often a R&D sprint, designing a prototype and getting it ready for production. A fast and creative process, realizing the next generation product for a brand. LTV also owns several brands for which we develop our own innovative light therapy products.

In our Indian team we are looking for a growth marketing specialist that can build our brands. You will be working with our team to launch new brands and grow existing ones.

So, what will you do exactly?

Job Description

As a fulltime you will be responsible for the Development of Magento plugins, customizations and creating web applications, web sites etc. You will work within our international team to initiate and execute all the development and customization part.

Your Key Responsibility Areas will be:

• Develop and manage e-commerce websites, web applications & web sites.
• Analyze, design, code, debug, test, document & deploy applications.
• Participate in project & deployment planning.
• Expertise in Magento and Customizations.

Required skills set:

• Magento 2, WordPress, Drupal, Shopify, and other CMS based platform
• Core PHP,
• My SQL,
• AWS server Knowledge
• MVC Code Igniter,
• Laravel optional
• UI knowledge
• Theme integration and development

Required Candidate profile

• Must be a self-starter & be able to work with minimum supervision
• Exp. In modules/extensions development/customization.
• Exp. In Theme integration/customization.
• Exp. In API creation/integration.
• Preferred multi-level marketing experience.

Your Required Skill Set Are:

=> Hands on experience in Coding, Testing, Implementation/Maintenance Support in PHP and MySQL. => Extensive development of jQuery, JavaScript, => expert in using CakePHP, Codeigniter Framework to develop a web application and portal. => Strong in JavaScript, Ajax, jQuery and good knowledge of Node js, React js, Angular js, AJAX, DHTML, DOM, YUI, jQuery => OOPS PHP development. => Integration Ability: Strong in understanding and integrating third party web services. => Platforms: Windows Server, Linux Server => Webserver installation & configuration: Apache, AWS Amazon => have capacity to work independently and also as a part of team. => Understanding client requirements & functional specifications. => Developing and maintaining dynamic websites and web applications. => Quick learner and eager to learn new technologies.

Other Key skills:

• Photoshop, Illustrator, InDesign, Dreamweaver, Web Designing, Graphics, Maya, 3D Max etc.
• Academic Qualification Requirement: Education- Graduate+ any relevant certified course.
• Diploma/degree matching to this profile.

What We Offer:

• A highly motivated, young and energetic team.
• Fast growing company with a lot of opportunities to develop yourself.
• Salary as per Industry Standard Lucrative hike on current package.
• On-site visit opportunity in USA, China & Netherlands.
• Performance bonus.
• Plenty of tea and coffee.
• Thrilling team parties.
• Flexible work environment; and
• Opportunity to work closely with overseas clients.

Company Website: http://www.lighttreeventures.com">www.lighttreeventures.com

We are Light tree ventures looking to expand our team. Will you join us in this amazing adventure.

• Minimum 3+ years' experience as a software developer.
• Proficiency in JavaScript, Angular.js, HTML 5, CSS.
• Familiarity with Git.
• Linux and/or OS X experience.
• Experience consuming API endpoints.
• Good to have - Kafka/queuing system
• Should be well-versed in using multiple Databases - SQL/NO SQL,
• Should have experience using in- memory Data Bases-Redis
• Experience with Unit-Testing.
• Experience building web applications with responsive design.
• Experience with Node.js and/or other server-side JavaScript technologies and tools.
• Strong knowledge of design principles, user interfaces, web standards and usability.
• ES6, React JS/JSX, Redux, Web pack, Immutable.js.