Oracle Analytics Cloud Implementation Consultant

Title : Oracle Analytics Cloud (OAC) Developer

Duration : Fulltime

Location : India - 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.