Mastek - Oracle Analytics Cloud/ODI Architect

OAC ODI Architect to be based in Ahmedabad or Chennai

Oracle Analytics Consultant (OAC, ODI, FDI) Tech Architect

Expected DOJ : ASAP

Employment Type : Full-time

Experience Level : 10 - 15 Years

Job Summary :

Key Responsibilities :

- Architect and implement data integration pipelines using Oracle Data Integrator (ODI) for on-prem and cloud data sources.

- Collaborate with business and IT stakeholders to design and deploy Fusion Data Intelligence (FDI) based dashboards and KPIs.

- Optimize performance of OAC dashboards and reports, including data modeling and visualization best practices.

- Develop and manage data models, RPDs, and semantic layers within OAC.

- Build and maintain ETL mappings, packages, and workflows in ODI.

- Integrate Oracle Fusion Applications with OAC and FDI for near-real-time reporting.

- Drive data governance and quality initiatives across analytics platforms.

- Troubleshoot technical issues and provide solutions in a timely manner.

- Mentor junior developers and provide technical leadership on complex projects.

Qualifications :

- 10+ years of relevant experience with strong focus on: Minimum Architect exp 4 Yrs

- Oracle Analytics Cloud (OAC) - Must

- Oracle Data Integrator (ODI) - Must

- Fusion Data Intelligence (FDI) Good to Have

- Expertise in Oracle Fusion ERP/HCM data models and subject areas.

- Experience integrating multiple data sources, including on-premise and cloud systems.

- Strong understanding of SQL, PL/SQL, and performance tuning.

- Familiarity with data lake architecture, data warehousing, and ELT/ETL design patterns.

- Proven experience working in Agile/DevOps environments.

- Excellent communication, analytical thinking, and problem-solving skills.