Website:
atsmantra.com
Job details:
Role Summary
We are seeking a hands-on Oracle Analytics Cloud & Oracle Data Integrator specialist to design and build enterprise analytics solutions end-to-end—spanning data ingestion, transformation, semantic modeling (RPD/Semantic Modeler), KPI definitions, and secure, high-performance dashboards and reports. The role includes responsibility for ETL development in ODI or any other ETL tool, OAC modeling and visualization, security design (row/object level), and deployment automation across Dev/UAT/Prod.
Key Responsibilities:
1) Data Warehousing & Integration (ODI / DW)
- Design and implement ETL pipelines in ODI (Mappings, Packages, Load Plans, Scenarios) using best practices.
- Build scalable data models (Star/Snowflake schemas), conformed dimensions, SCD handling (Type 1/2), and CDC strategies
- Optimize ELT/ETL jobs for performance (partitioning, parallelism, CDC, pushdown, set-based operations)
- Orchestrate end-to-end data flows across Oracle Fusion, ADW, OCI Object Storage, on‑prem sources, and third-party systems
- Implement data quality checks, error handling, logging, and restart/recovery strategies
2) Semantic Modeling (RPD / Semantic Modeler)
- Design logical and physical layers, hierarchies, aggregates, and time series metrics in RPD (OBIEE/OAS)
- Implement complex business logic (calculated measures, KPI frameworks, row-level filters, data-level security)
- Model subject areas to support Finance, Procurement, SCM, HCM, or custom domains; ensure semantic consistency and reusability.
3) Analytics & Reporting (OAC)
- Develop Dashboards, Analyses, Data Visualization (DV) projects (and BI Publisher reports when required)
- Build interactive dashboards, drill downs, narrative visualizations, and guided analytics for business users
- Tune query performance (aggregation strategies, cache, indexing, materialized views) and optimize dashboard response times
- Implement federated queries, dataset blends/joins, and curated semantic layers for self-service analytics
4) Security & Governance
- Design and implement application roles, object-level and row-level data security (RLS), and data masking
- Integrate with enterprise identity (IDCS/OCI IAM/AD) and manage user provisioning and entitlements
- Ensure adherence to data governance, audit trails, logging, and compliance
5) Deployment, DevOps & Operations
- Package and migrate across environments (e.g., BAR files, ODI scenarios, repository moves)
- Monitor platform health (OAC service status, ODI agent and scheduling), troubleshoot incidents, and manage SLAs
- Document runbooks, architecture diagrams, and operational procedures; conduct KT/training sessions
6) Stakeholder Engagement
- Partner with business/product owners to translate requirements into semantic models and dashboards
- Lead/participate in design reviews, demonstrate prototypes, and iterate on user feedback
- Provide best-practice guidance for self-service analytics and data literacy
Required Skills
- SQL and PL-SQL
- Oracle Data Integrator (comfortable working with other ETL Tools
- Oracle Analytics Cloud / Oracle Analytics Server / OBIEE
- Data warehousing concepts application
- Strong analytical/problem-solving: ability to simplify complex requirements.
- Excellent communication and stakeholder management; comfortable with demos/KT
- Documentation discipline (design specs, lineage, test plans, runbooks
Good to have:
- Knowledge/Experience in Fusion Data Intelligence.
- Exposure to OCI basics (Compartments, Object Storage, Domains, etc.)
- Certification in Oracle Analytics Cloud, Oracle Data Integrator 12c, or FDI/FAW (at least one certification in OAC or ODI).
- Knowledge/Experience working with Oracle Fusion BI
Click on Apply to know more.