Oracle Analytics Cloud (OAC) Developer

Title - Oracle Analytics Cloud (OAC) Developer

Location - Remote

Job Summary :

We are looking for talented and experienced professionals with a strong background in Oracle Analytics Cloud (OAC) with rich data visualization skills to join our data analytics team. The ideal candidates will have hands-on experience designing, developing, and deploying interactive dashboards, data visualizations, and reports using Oracle Analytics Cloud. A good understanding of data modelling, performance tuning, and advanced analytics is essential. Experience in AI / ML model integration and predictive analytics within the OAC ecosystem will be considered a strong plus.

Qualifications : Education :

Bachelor’s degree in Computer Science, Information Technology, or a related field.

Experience :

5+ years of experience in Oracle Analytics Cloud (OAC) development.

3+ years of experience in RPD development.

3+ years of experience in Informatica PowerCenter ETL development.

Skills :

Strong proficiency in Oracle Analytics Cloud (OAC) and RPD development.

Expertise in Informatica PowerCenter for ETL processes.

Knowledge of SQL, PL / SQL, and database design principles.

Experience with data warehousing concepts and best practices.

Excellent problem-solving and analytical skills.

Strong communication and collaboration abilities.

Preferred Qualifications :

Experience with other ETL tools and data integration technologies.

Knowledge of cloud-based analytics solutions.

Certification in Oracle Analytics or Informatica.

Key Responsibilities :

Design and develop interactive dashboards and data visualizations using Oracle Analytics Cloud.

Translate business requirements into analytical solutions and visual insights.

Build and optimize data models and datasets for efficient reporting and analysis.

Integrate data from multiple sources (Oracle, SQL Server, cloud platforms, etc.) into OAC.

Implement data security, role-based access, and governance in OAC environments.

Collaborate with business users, data engineers, and other stakeholders to ensure analytical consistency.

Leverage AI / ML models and predictive analytics capabilities in OAC or through Python / R integration.

Perform performance tuning and troubleshooting for OAC dashboards and datasets.

Document architecture, design, and implementation details for ongoing maintenance.

Design, develop, and maintain Oracle Analytics Server (OAS) solutions.

Configure and manage OAS environments, including installation, upgrades, and patches.

Create and optimize dashboards and reports to meet business requirements.

RPD Development :

Design and develop RPD models to support analytics and reporting needs.

Implement best practices in RPD development, including logical and physical layer design.

Perform metadata modeling, security management, and repository configuration.

Informatica ETL Development :

Design, develop, and maintain ETL processes using Informatica PowerCenter.

Create efficient data extraction, transformation, and loading processes.

Optimize ETL processes for performance and scalability.

Data Integration :

Integrate data from various sources to support analytics and reporting.

Ensure data quality, consistency, and integrity throughout the data lifecycle.

Troubleshoot and resolve data integration issues.

Collaboration and Communication :

Work closely with business analysts and stakeholders to understand requirements.

Collaborate with data architects and other developers to design and implement solutions.

Provide technical guidance and support to team members.

Documentation and Training :

Document technical designs, processes, and procedures.

Conduct training sessions and provide support to end-users.