SQL- DWH Developer

About Sun King

Sun King is the world’s leading off-grid solar energy company, delivering energy access to 1.8 billion people without reliable grid connections through innovative product design, fintech solutions, and field operations.

Key highlights:

• Connected over 20 million homes to solar power across Africa and Asia, adding 200,000 homes monthly.
• Affordable ‘pay-as-you-go’ financing model; after 1-2 years, customers own their solar equipment.
• Saved customers over $4 billion to date.
• Collect 650,000 daily payments via 28,000 field agents using mobile money systems.
• Products range from home lighting to high-energy appliances, with expansion into clean cooking, electric mobility, and entertainment.

With 2,800 staff across 12 countries, our team includes experts in various fields, all passionate about serving off-grid communities.

Diversity Commitment:

44% of our workforce are women, reflecting our commitment to gender diversity.

About the role:

The Backend Developer works remotely as part of the technology team to help Sun King’s EasyBuy business unit design and develop software to improve its field team operations.

What you will be expected to do

• Design and develop applications/systems based on wireframes and product requirements documents. 
• Design and develop logical and physical data models to meet application requirements. 
• Identify and resolve bottlenecks and bugs based on operational requirements.
• Perform unit tests on code to ensure robustness, including edge cases, usability, and general reliability. 
• Write reusable and easily maintainable code following the principles of DRY (Don’t Repeat Yourself). 
• Integrate existing tools and business systems, both in-house and external services, such as ticketing software and communication tools. 
• Collaborate with team members and product managers to understand project requirements and contribute to the overall system design. 

You might be a strong candidate if you have/are

• Have development experience: 1-2 years backend development experience and have strong problem-solving abilities, proficiency in data structures, and algorithms. 
• Have a profound grasp of object-oriented programming (OOPS) standards and expertise in Core Java. 
• Have knowledge of SQL, MySQL, or similar database management. 
• Have Experience in integrating web services, such as SOAP, REST, JSON, and XML. 
• Have familiarity with RESTful APIs for linking Android applications to backend services. 
• Have preferred experience with version control systems like Git, but not mandatory. 
• Have additional knowledge of web technologies like HTML, CSS, JavaScript, and frameworks like Spring or Hibernate would be advantageous. 

What we offer (in addition to compensation and statutory benefits):

• A platform for professional growth in a rapidly expanding, high-impact sector.
• Immerse in a collaborative culture, energized by employees of Sun King who are collectively motivated by fostering a transformative, sustainable venture.
• A genuinely global environment: Engage and learn alongside a diverse group from varied geographies and backgrounds.
• Tailored learning pathways through the Sun King Center for Leadership to elevate your leadership and managerial capabilities.

Job Summary:

We are looking for a skilled and experienced Java Developer to join our team. As a Java Developer, you will be responsible for developing and maintaining our applications using Java, Spring framework, and other related technologies. The ideal candidate should have a strong understanding of object-oriented programming principles, as well as experience with a variety of technologies such as SQL, NoSQL, and cloud computing.

Responsibilities:

• Design, develop, and maintain our applications using Java, Spring framework, and other related technologies
• Write clean, efficient, and optimized code for applications
• Collaborate with cross-functional teams to understand user requirements and deliver high-quality solutions
• Develop and maintain backend systems using Spring framework
• Work with databases, including SQL and NoSQL
• Ensure code quality and maintain documentation
• Troubleshoot and debug applications
• Stay updated with emerging trends and technologies in Java development
• Work with other teams to deploy and maintain applications

Requirements:

• 3-7 years of experience in Java development
• Strong understanding of object-oriented programming principles
• Experience with Java, Spring framework, and related technologies
• Familiarity with databases, including SQL and NoSQL
• Knowledge of cloud computing is a plus
• Excellent problem-solving and debugging skills
• Strong communication and collaboration skills
• Ability to work independently and as part of a team
• Bachelor's degree in computer science or a related field

Key Skills:

• Strong proficiency in Java programming language
• Experience with Spring framework, including Spring Boot and Spring MVC
• Familiarity with cloud platforms such as AWS, GCP, and Azure
• Experience building RESTful APIs
• Knowledge of microservices architecture
• Familiarity with SQL and relational databases such as MySQL and Postgres
• Familiarity with NoSQL databases such as MongoDB and Redis
• Experience with messaging systems such as Kafka and RabbitMQ
• Experience with containerization tools such as Docker and Kubernetes
• Understanding of software development principles and experience with SDLC methodologies
• Experience with Git version control and build tools such as Maven and Gradle
• Familiarity with front-end technologies such as Angular and React is a plus
• Strong problem-solving and analytical skills
• Good communication and interpersonal skills
• Ability to work independently and take ownership of tasks
• Experience with test-driven development and unit testing frameworks such as JUnit and Mockito
• Familiarity with CI/CD tools such as Jenkins is a plus
• Familiarity with caching technologies such as Redis is a plus
• Working knowledge of design patterns and software architecture principles is a plus.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

JOB DUTIES & RESPONSIBILITIES:

• Lead and mentor developers thru coaching and sharing of knowledge
• Architecture design and Develop new functionality and critical business logic of software products
• Enhance existing applications and software products and design new product

SKILLS:

• Strong knowledge on software implementation best practices
• Strong knowledge of SQL Server and/or Oracle database including store procedure, trigger etc.
• Knowledge of security and vulnerability best practices to design secure web application
• Knowledge of web application architecture with horizontal and vertical scalability
• Experience of working with application with large dataset of millions or billions of row in database table
• Ability to adapt quickly to an existing, complex environment
• Ability to complete all phases of software development life cycle including analysis, design, development, testing and support
• Ability to develop large scale web/database applications
• Ability to work on multiple projects with multiple deadlines
• Ability to communicate clearly with business users and project manager
• Ability to innovate and provide functional applications with intuitive interfaces

MUST HAVE SKILLS
- CORE JAVA & SQL

Desired Skills
Designing, implementing and delivering high quality Software project in JAVA, SQL / Oracle, J2EE and other JAVA technologies.

Job Responsibilities
Participate in detailed level in design, coding, code walk through, peer code reviews and unit testing,  System Testing, UAT, Demos, POCs, installation, maintenance of Software modules. 

❑ Ensures the preparation of the following: 

▪ Software prototype 

▪ System Architecture 

▪ Software Design Document 

▪ User interfaces to be developed as per UX guidelines 

▪ Code files ensuring coding guidelines followed 

▪ Code review artefacts during peer code review 

▪ Test plan and Test Cases 

▪ Installation / Deployment document 

▪ Release Document 

▪ Technical Documentation 

❑ Documents and demonstrates solutions by developing documentations, flowcharts, layouts, diagram, charts,  code. comments and clear code; Ensuring that project task are completed in defined effort and timelines ❑ Prepares and installs solutions by determining and designing system specifications, standards & programming. 

❑ Testing: Writing of test cases, unit testing, system testing, negative testing 

❑ Trouble shooting: Log analysis and database query optimization  

❑ Improves operations by conducting system's analysis. 

❑ Updates job knowledge by studying state of the art development tools, programming techniques & computing equipment; participates in educational opportunities, reads professional publications & maintains  personal networks.  

❑ Protects operations by keeping information confidential. 

❑ Provides information by collecting, analyzing and summarizing development and service issues.  ❑ Develops software solution by studying information needs, conferring with users, studding system flow,  data usage and work processes, investigating problem areas, following delivery cycle. 

At Cityflo, we are solving the problem of commuting to the office which affects employees in big, populated Indian cities every day. Cityflo provides a bus experience like no other - we run premium AC buses for daily commuters. We’re changing the way urban Indians commute and enabling everyone to reclaim hours of their time every day. Before the imposed lockdown due to coronavirus, we were serving about 7500 commuters per day. We plan to scale to 5,00,000 per day in the next 4 years in a profitable and sustainable manner.

You can read more about our engineering and culture on our blog: https://blog.cityflo.com/tag/engineering/" target="_blank">https://blog.cityflo.com/tag/engineering/

Role & Requirements

• 2+ year experience in application development
• ability to write efficient SQL queries and design schemas for relational databases
• good knowledge of operating systems and networking concepts
• experience in using and understanding code from Open Source
• experience with implementing best software engineering practices like version control with git, code reviews, writing unit-tests, writing readable code
• experience with Python and Django is a plus.
• inclination towards researching new technologies and adapt them to solve challenges we face

We look for engineers who

• Are committed to their growth and learning
• care about working in and building a strong engineering culture
• want to take significant ownership and decision making power
• want to make an impact in the real world while working with a great team in a hyper-growth environment