Oracle Fusion HCM BI Reporting

Backend – Software Development Engineer II

Experience: 4–7 years

Location: Bangalore

Work Mode - Hybrid

About Wekan Enterprise Solutions

Wekan Enterprise Solutions is a leading Technology Consulting company and a strategic investment partner of MongoDB. We help companies drive innovation in the cloud by adopting modern technology solutions that help them achieve their performance and availability requirements. With strong capabilities around Mobile, IOT and Cloud environments, we have an extensive track record helping Fortune 500 companies modernize their most critical legacy and on-premise applications, migrating them to the cloud and leveraging the most cutting-edge technologies.

Job Description

We are looking for passionate software engineers eager to be a part of our growth journey. The right candidate needs to be interested in working in high-paced and challenging environments. Interested in constantly upskilling, learning new technologies and expanding their domain knowledge to new industries. This candidate needs to be a team player and should be looking to help build a culture of excellence. Do you have what it takes?

You will be working on complex data migrations, modernizing legacy applications and building new applications on the cloud for large enterprise and/or growth stage startups. You will have the opportunity to contribute directly into mission critical projects directly interacting with business stakeholders, customer’s technical teams and MongoDB solutions Architects

What you will do

• Own backend features and migration workstreams end to end, from understanding the existing codebase and data model to delivering production-ready implementations.
• Build and enhance Java/Spring Boot services used in modernization, migration, and cloud transformation projects.
• Design and implement backend flows that are safe under retries and partial failures, with clear thinking around validation, transaction boundaries, idempotency, and downstream side effects.
• Work across application, database, and deployment layers to improve reliability, maintainability, and operational visibility.
• Model data based on access patterns and business workflows, with sound choices around schema design, indexing, and query performance.
• Investigate production issues using logs, request traces, database state, and service behavior; identify root causes and implement durable fixes.
• Collaborate with internal teams, customer engineering teams, architects, and stakeholders to deliver high-quality solutions on mission-critical projects.
• Write clean, modular, testable code and participate actively in sprint ceremonies, code reviews, design discussions, and release activities.

What we’re looking for

• 4–7 years of backend engineering experience, with strong hands-on delivery in Java-based systems.
• Solid experience with Java, Spring Boot, and microservice-style backend development.
• Demonstrated ownership of at least one meaningful backend service or feature area in production.
• Strong understanding of backend engineering fundamentals, including service reliability, data consistency, failure handling, and production-grade design considerations.
• Strong database fundamentals, including schema design, query writing, indexing, and performance reasoning.
• Strong depth in MongoDB or a relational database such as Oracle, with working comfort across both styles being a plus.
• Ability to investigate and resolve real production issues across services and databases, including consistency, performance, and reliability problems.
• Hands-on experience with testing frameworks such as JUnit and Mockito.
• Proficiency with Git, including branching, code review workflows, and conflict resolution.
• Strong communication skills and the ability to collaborate effectively with engineers, stakeholders, and customers.

Preferred qualifications

• Experience working on legacy modernization, data/service migrations, or decomposition of existing systems into cleaner service boundaries.
• Exposure to both MongoDB and relational databases, including query tuning, indexing, and production troubleshooting.
• Familiarity with Oracle PL/SQL or migration of logic from database-heavy systems into service-layer Java code.
• Exposure to CI/CD deployment and cloud environments like AWS, Azure, or GCP.

Requirements:

• 4-6 years of experience in developing Enterprise Web Applications using Java/J2EE technologies with a good professional track record.
• Excellent knowledge in Core Java (J2SE) and J2EE technologies.
• Proficient knowledge in Servlets, JDBC & JSP.
• Good knowledge of Spring framework (MVC, Cloud, Data and Security. Etc) and ORM framework like JPA/Hibernate.
• Strong knowledge of Exception Handling, Collections, File I/O Streams, Interfaces, and logging mechanisms is a must.
• Experience in developing REST APIs and integration of third-party APIs.
• Proficient knowledge in SQL/PLSQL.
• Expertise in application/web server deployment and connection pooling techniques.
• Cloud deployment (AWS & Azure) will be an added advantage.
• Experience in Version Control tools like Git, Bitbucket, etc.
• Experience in data security and protocols is a must.
• Maven and IDE tools experience is a must.
• Multi-threading and serialization techniques knowledge is a must.
• Good understanding of end-to-end software development lifecycle.
• Ability to read and understand requirements and design documents.
• Good Analytical skills and should be self-driven. Good communication with interpersonal skills.
• Open to learning new technologies and domains.
• A good team player and ready to take up new challenges
• Languages: Java(J2SE), J2EE (Servlets, JSPs, JDBC)
• Databases: MySQL, Oracle, SQL Server, PostgreSQL.
• DB Script: SQL and PL/SQL
• Frameworks: Spring, Spring Boot, Jersey, Hibernate and JPA
• OS: Windows, Linux/Unix.
• Cloud Services: AWS and Azure (Good to have)
• Version Control tools: Git, Bitbucket.
• Deployment Servers: Tomcat, JBoss, and Web sphere
• Build Tools: Gradle/Maven

Oracle Apex Developer:

• No. of Position: 3
• Budget: 12 - 16 LPA all inclusive depending on experience bracket
• Work Location – For Mumbai candidate it will be Mahape - Navi Mumbai; candidates from Pan India who are not ready to relocate can permanently WFH.
• Joining Time – Immediate to 45 Days
• US Client – Long term logistics domain project
• Opportunity to work with a team of 20+ Apex experts on the latest Apex technologies in the market
• Onsite opportunity for tenured employees

Experience:

• 5-8 years’ experience in Oracle PL SQL & Oracle Apex; (Majority of Oracle Apex experienced required)
• Preferred Education: B. Tech / B. E - Any Specialization, Computers (OR) BCA (AND/OR) MCA                                 

Core Competencies:

• Experience working on Oracle PL/SQL Programming and DB features
• Proficient in Oracle Apex components is a must
• Experience in Javascript, Jquery and CSS
• Knowledge of Page zero concept, shared components, Page rendering & processing, Interactive reports
• Exposure to DBA activities like Table space management, Export/Import etc.
• Experience in Unix Shell scripting
• Exposure to any reporting tool
• Good communication skills
• Ability to take responsibility and handle pressure 
• Ability to think creatively and solve complex problems 
• Self-motivated, fast learner with the ability to operate independently 
• Team player with strong interpersonal skills and a willingness to help others 
• Ability to thrive in a cross-functional team on business-critical projects 
• Intrinsically cares about the quality of work 
• Organized and focused on delivering tasks within defined deadlines

Specific Responsibilities:

• Would work in design, develop, enhance, test and maintain software applications
• Design and develop SQL scripts, stored procedures, packages, parameterized queries and objects using tools like Toad, SQL Developer, Pl/SQL developer
• Build and maintain Application database schema/objects and account for data migration/upgrades across versions
• Identify and automate routine maintenance tasks
• Optimizing DB queries, stored procedures, Data structures, Indexes and DB Normalization.
• Certify all queries written by software developers to ensure optimal execution of the queries
• Research, investigate and evaluate potential database solutions to business problems/requirements
• Write Test cases for developed queries/functions using PLSQL and Quest code tester.

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)