Oracle Analytics Cloud Developer(OAC)!

Aziro; Pune District, Chennai, Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Aziro is seeking an Oracle Analytics Cloud (OAC) Developer Data Visualization Expert to design, develop, and deploy dashboards and reports. The role emphasizes data modelling, performance tuning, and AI/ML model integration within the OAC ecosystem.

The ideal candidate will work across Oracle databases, SQL Server, and cloud platforms, ensuring data quality, security, and governance while collaborating with analysts and engineers to deliver insights.

Qualifications

• Bachelor's degree in CS/IT or related field.
• 5+ years in Oracle Analytics Cloud (OAC) development.
• 3+ years in RPD development.
• 3+ years in Informatica PowerCenter ETL development.
• Strong proficiency in OAC and RPD development.
• Knowledge of SQL/PLSQL and data warehousing concepts.
• Excellent problem-solving and analytical skills.

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.

Skills

OAC development

RPD development

Informatica PowerCenter ETL

SQL/PLSQL

Data warehousing concepts

Communication skills

Education

Bachelor's degree in CS/IT or related field

Tools

Informatica PowerCenter

Oracle Analytics Cloud

Oracle Analytics Server

SQL

Job description

Job Title: Oracle Analytics Cloud (OAC) Developer Data Visualization Expert

Department: Data Fabric & Advanced Analytics

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.

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.

Qualifications

• Education:
• Bachelors 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.