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.