Oracle FDI OAC- Senior Associate

PwC; Hyderabad, Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

PwC is seeking an Oracle Analytics Cloud (OAC) Senior Associate with 5-9 years of hands-on experience to design and deliver enterprise data integration solutions for Fortune 1000 clients. The role focuses on ODI, GoldenGate, and OCI Data Integration to migrate, modernize, and optimize data warehouses.

The position requires strong SQL/PLSQL skills, ELT/ETL architecture knowledge, and experience with cloud-native integration patterns, including Big Data connectivity.

Qualifications

• 5-9 years hands-on experience with Oracle Analytics Cloud (OAC) including KM development and topology configuration.
• Strong SQL and PL/SQL skills with Oracle databases.
• Experience with ODI 11g/12c and GoldenGate data replication.
• Exposure to OCI Data Integration and cloud-native integration patterns.

Responsibilities

• Design, develop, and support enterprise data integration solutions using OAC, ODI, and GoldenGate.
• Migrate on-premise ETL workloads to Oracle Cloud Infrastructure.
• Build and optimize ELT/ETL pipelines for large-scale data warehouses.
• Collaborate with technical and project teams for enterprise delivery.

Skills

OAC experience

SQL/PLSQL

ELT/ETL design

Data warehousing concepts

Big data connectivity

Problem solving

Tools

Oracle Data Integrator (ODI)

Oracle GoldenGate

OCI Data Integration

Job description

Job description

Oracle Analytics Cloud (OAC) Senior Associate (5-9 Years of Experience)

As an OAC Senior Developer, you will work with technical and project teams to design and deliver enterprise-grade data integration solutions for some of our Fortune 1000 clients. You will have the opportunity to contribute to work that may involve building new ELT/ETL pipelines; migrating on-premise integration workloads to the cloud; modernizing legacy Data Warehouse feeds; and integrating Oracle Data Integrator with GoldenGate, OCI Data Integration, and other Oracle data platform services. Our teams have a diverse range of skills, and we are always looking for new ways to innovate and help our clients succeed. The primary focus of this role is to design, develop, and support enterprise data integration solutions using Oracle Data Integrator (ODI), Oracle GoldenGate, Oracle Cloud Infrastructure (OCI) Data Integration/Data

Role & responsibilities

As OAC developer you will have multiple responsibilities depending on the project type. One type of project may involve migrating existing reporting applications to Oracle cloud infrastructure.Another might involve building new reporting solutions directly within Oracle Analytics Cloud (OAC) .The key responsibilities may involve some or all the areas listed below:

• 5-9 years of hands-on experience with Oracle Analytics Cloud (OAC) , including KM development and topology configuration.
• Experience with Oracle Data Integrator 11g/12c/ODI Marketplace Edition.
• Exposure to Oracle Analytics Cloud (OAC) or Fusion Data
• Strong SQL and PL/SQL skills, with experience on one or more relational databases on Oracle.
• Solid understanding of ELT/ETL architecture, data warehousing concepts, and dimensional modeling.
• Experience with Oracle GoldenGate for real-time replication and Change Data Capture (CDC).
• Exposure to OCI Data Integration / Data Transforms and cloud-native, serverless integration patterns.
• Experience migrating on-premise ETL workloads to Oracle Cloud Infrastructure.
• Working knowledge of Oracle Autonomous Database and Oracle Exadata Cloud Service as integration targets.
• Exposure to Big Data connectivity (Hadoop, Hive, Spark, Kafka) within ODI or GoldenGate for Big Data.
• Experience with job scheduling, load plans, and ODI agent (Standalone/JEE/Colocated) administration.

Preferred

• Experience with Oracle GoldenGate 21c/23ai.
• Exposure to Oracle Analytics Cloud (OAC) or Fusion Data Intelligence (FDI) as downstream consumers of ODI pipelines.
• Experience in Oracle BI Apps (OBIA).
• Exposure to one or more of the following: Python, R, or UNIX shell scripting.
• Expertise in analyzing and troubleshooting large-scale, high-volume data integration jobs.
• Systematic problem-solving approach.
• Ability to debug and optimize code and automate routine tasks.
• Exposure to ODI SDK and Groovy scripting for automation.