Oracle Analytics & Data Warehouse Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Techno Talent Inc., is seeking the following. Apply via Dice today! Title: Oracle Analytics & Data Warehouse Developer Location: Iselin, NJ USA We are seeking a Oracle Analytics & Data Warehouse Developer (Contract) to design, develop, and maintain enterprise analytics solutions using Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), and related technologies. You will build dashboards, semantic models, data pipelines, and integrations to support critical business intelligence initiatives. Key Responsibilities • Develop OAC Workbooks, dashboards, and visualizations • Build and maintain Semantic Models (RPD) using Oracle BI Administration Tool • Design and implement Data Warehouse solutions (Star/Snowflake schemas) • Create ODI mappings, packages, and load plans for ETL/ELT processes • Develop and maintain OAC Classic Reports (Pixel Perfect) • Manage OCI Cloud infrastructure for analytics workloads • Support legacy OBIEE and Hyperion environments and migrations • Build REST API integrations for data automation Detail Job Responsibilities Oracle Data Integrator (ODI) Development • Design and develop ODI mappings, packages, and load plans for data integration • Create reusable ODI components including knowledge modules, variables, and sequences • Implement CDC (Change Data Capture) and incremental loading strategies • Configure ODI agents, topology connections, and security settings • Troubleshoot ODI execution errors and optimize job performance • Manage ODI repository and perform version control activities Data Warehouse Development • Design and implement dimensional data models (Star Schema, Snowflake Schema) following Kimball or Inmon methodologies • Develop and maintain ETL/ELT processes for data warehouse loading and transformation • Create and optimize fact tables, dimension tables, and aggregate tables • Design and maintain data warehouse architecture for scalability and performance • Develop stored procedures, functions, and database objects for data processing Semantic Model & RPD Development • Design, build, and maintain the Semantic Model/RPD (Repository) using the Model Administration Tool • Create and optimize Business Models, Logical Table Sources, and Presentation Catalogs • Develop complex calculations, aggregations, and time-series functions within the semantic layer • Implement row-level security, data filters, and object permissions in the RPD • Perform RPD migrations, merges, and deployments across development, test, and production environments • Troubleshoot and resolve RPD-related performance issues and logical SQL problems Oracle Analytics Cloud (OAC) Development • Design, develop, and maintain OAC workbooks, dashboards, OAC Classic Reports and visualizations to meet business reporting requirements • Implement pixel-perfect reports and interactive dashboards for various stakeholders • Configure and manage OAC instances, including security, connections, and system settings Oracle Cloud Infrastructure (OCI) Administration • Provision and manage OCI resources including Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and OAC instances • Configure OCI networking, security lists, and IAM policies for analytics workloads • Implement data integration between on-premises systems and OCI cloud services • Monitor OCI resource utilization and optimize costs • Manage OCI Object Storage for data lake and staging requirements API Development & Integration • Develop and consume REST APIs for OAC automation and integration • Integrate OAC with external applications using APIs and web services Technical Skills Required: • OAC/OBIEE: Expert-level proficiency in OAC Data Visualization, Classic Analytics, Answers, Dashboards, Agents, and BI Publisher • Semantic Modeling: Advanced RPD development including complex joins, level-based measures, aggregate navigation, and fragmentation • Data Warehouse: Strong experience in dimensional modeling, ETL design patterns, and data architecture • ODI: Proficient in ODI 12c development including mappings, packages, load plans, and knowledge modules • SQL/PLSQL: Expert-level SQL and PL/SQL skills for Oracle Database • OCI: Experience with OCI console, CLI, and services (ADW, ATP, Object Storage, OAC) • APIs: Experience with REST API development and integration. Preferred: • Hyperion: Experience with Hyperion Financial Reporting, Planning, Essbase, or HFM • Python/Java: Scripting skills for automation and API integration • Git: Version control experience for collaborative development