Job Description :

1. Oracle Fusion Data Intelligence (FDI) - Mandatory :

- Formerly known as Oracle Analytics for Applications (OAX).

- Candidate should have :

a. Experience implementing Oracle Fusion Data Intelligence.

b. Building subject areas and dashboards.

c. Data extraction from Oracle Fusion Cloud Applications.

d. KPI creation and business reporting.

e. Security and role-based access implementation.

f. Data validation and reconciliation.

2. Oracle Analytics Cloud (OAC) :

- Candidate should be able to :

a. Create dashboards and reports.

b. Develop custom visualizations.

c. Design analytical models

d. Create calculated measures and metrics.

e. Perform drill-down and drill-through analysis.

3. Data Modelling - Mandatory :

- Strong understanding of :

a. Star Schema

b. Snowflake Schema

c. Fact & Dimension Tables

d. Data Warehouse Concepts

e. Logical & Physical Data Models

Responsibilities :

- Designing enterprise data models.

- Data relationship mapping.

- Performance optimization.

4. Oracle Fusion Applications Knowledge :

- Should understand Oracle Fusion modules such as :

a. HCM

b. Finance

c. SCM

d. Procurement

e. Projects

Candidate should know :

- Oracle Fusion data structures.

- Fusion reporting architecture.

- Subject areas and business objects.

5. ODI (Oracle Data Integrator) - Mandatory :

Expected skills :

- ODI Development

- ODI Mappings

- Packages

- Scenarios

- Load Plans

- Incremental Loads

- Error Handling

Responsibilities :

- ETL development.

- Data integration.

- Data migration.

- Data transformation.

Must have practical implementation experience.

6. ETL Development :

Strong experience in :

- Data extraction.

- Transformation logic.

- Data loading.

- Scheduling jobs.

- Performance tuning.

Tools :

- ODI

- Informatica

- DataStage

- Talend

- Oracle ETL Frameworks

Testing Experience (Mandatory) :

Candidate should have :

- SIT Testing

- UAT Support

- Data Validation

- ETL Testing

- Report Testing

- Reconciliation Testing.

Responsibilities :

- Validate source vs target data.

- Report accuracy checks.

- Defect analysis.

- Test case preparation.

SDLC Knowledge :

Candidate should understand :

- Requirement Gathering

- Design

- Development

- Testing

- Deployment

- Production Support

Exposure to :

- Agile

- Scrum

- Waterfall

Tools :

- JIRA

- Azure DevOps

- ServiceNow

Responsibilities :

- Design and develop Oracle Analytics solutions.

- Build and maintain Oracle Fusion Data Intelligence reports and dashboards.

- Develop ETL solutions using ODI.

- Create and maintain data models.

- Work with business stakeholders to gather reporting requirements.

- Perform testing and validation of data.

- Troubleshoot production issues.

- Support end-to-end SDLC activities.

- Optimize report and ETL performance.

- Prepare technical documentation.