About the Role

We are seeking an experienced Senior Technical Consultant with a strong background in Oracle Data Integrator (ODI) and Oracle Analytics Cloud (OAC). The ideal candidate will be responsible for designing, developing, and maintaining robust data integration solutions that transform raw data into actionable insights, supporting our business intelligence and data warehousing objectives.

Key Responsibilities

• Design, develop, implement, and optimize data integration processes using Oracle Data Integrator (ODI).
• Collaborate with cross-functional teams to translate business requirements into technical specifications, ensuring data accuracy, integrity, and performance across all data pipelines.
• Design and develop interactive dashboards and compelling data visualizations using Oracle Analytics Cloud (OAC).
• Translate complex business requirements into effective analytical solutions and insightful visual representations.
• Build and optimize data models and datasets for efficient reporting and in-depth analysis.
• Implement robust data security, role-based access, and governance within OAC environments.
• Design and develop comprehensive RPD models to support analytics and reporting needs, adhering to best practices in both logical and physical layer design.
• Integrate data from diverse sources to support comprehensive analytics and reporting initiatives.
• Ensure data quality, consistency, and integrity throughout the entire data lifecycle.

Required Skills

• Strong proficiency in Oracle Analytics Cloud (OAC) and RPD development.
• Solid knowledge of SQL, PL/SQL, and database design principles.
• Proven experience with data warehousing concepts and best practices.
• Excellent problem-solving and analytical capabilities.
• Strong communication and collaboration abilities.

Preferred Skills

• ODI (Oracle Data Integrator)
• RPD development
• BICC

Good to Have Skills

• OAC/OBIEE dashboard experience
• OCI, Fusion application basics