Oracle Fusion HCM BI Reporting

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.

• Power BI Report development.
• Building Analysis Services reporting models.
• Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
• Connecting data sources, importing data, and transforming data for Business intelligence.
• Analytical thinking for translating data into informative reports and visuals.
• Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
• Should have an edge over making DAX queries in Power BI desktop.
• Expert in using advanced-level calculations on the data set.
• Responsible for design methodology and project documentaries.
• Should be able to develop tabular and multidimensional models that are compatible with data warehouse standards.
• Very good communication skills must be able to discuss the requirements effectively with the client teams, and with internal teams.

• Hands on Java experience with minimum 8 yrs. More experience is a plus but need to be hands on.
• Server side programming experience with technologies: Spring, Hibernate & Swing is a plus
• Good DB knowledge, hands on PL/SQL or T-SQL
• Experienced to work on Linux, git, IntelliJ, Eclipse
• Experience of designing and developing end-to-end solutions.