Oracle Fusion HCM BI Reporting

 We're Hiring Module Lead Oracle D2k

Location: Gurgaon, India

Experience Level: C2

Job Type: Full-time

Job Description:

• Design and develop custom Oracle Forms and Reports applications.
• Perform technical architecture design and document system requirements, processes, data flow, and message/interface designs.
• Develop Oracle SQL and PL/SQL scripts to meet business requirements.
• Review and optimize existing code, ensuring adherence to best practices and standards.
• Collaborate with internal teams to understand software issues and recommend solutions.
• Conduct Proof-of-Concepts (POCs) to evaluate new technologies or innovative ideas.
• Provide regular updates to the IT team and stakeholders, ensuring smooth project execution.
• Contribute to the development of API interfaces using Swagger and manage API security, authorization, and access control.
• Maintain thorough documentation throughout the development lifecycle.

Key Skills & Experience:

• Hands-on experience in designing, developing, and delivering Oracle Forms/Reports (12c).
• Strong knowledge of Oracle SQL and PL/SQL for database-driven application development.
• Experience with Oracle Database 19c and Unix shell scripting.
• Familiarity with Oracle REST Data Services (ORDS).
• Proficiency in API design and Swagger documentation; understanding of API security and access control.
• Knowledge of DevOps tools and experience with JIRA is a plus.
• Exposure to Java programming will be an added advantage.
• Strong communication and leadership skills, with a track record of working collaboratively with cross-functional teams.

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.

Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.

Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL

Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.

Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.

Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.

Create technical designs to support business requirements.

Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.

Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.

Assist in developing baseline datasets and reports to support testing of technical solutions.

Skill for BI Backend developer -

-SQL development (Snowflake preferred but any other version of SQL would work)

- ETL

- Stored Procedures

- Creating jobs and work flows in SQL

- some business knowledge

• Basic knowledge of Oracle Forms and reports - (Must)
• Good experience on SQL*Loader.
• Should Knowledge on Agile / Scrum.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Using SQL developer tool we debugged the code and unit test
• Knowledge of oracle programming
• MySQL, Oracle,
• Knowledge of Unix platform
• PostgreSQL
• advance database knowledge.
• Writing PL/SQL and PL/MySQL
• Coding support
• Debugging & Project module management
• Deployment and fine-tuning as per team lead.

• 4-8 years of experience in BI/DW
• 3+ years of experience with Microstrategy schema, design and development
• Experience in Microstrategy Cloud for Azure and connecting with Azure Synapse as Data Source
• Extensive experience in developing reports, dashboards and cubes in Microstrategy
• Advanced SQL coding skills
• Hands on development in BI reporting and performance tuning
• Should be able to prepare unit test cases and execute unit testing

• 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)