Serverless ETL using OCI Data Integration

Course Description

Serverless ETL using OCI Data Integration develops practical capability in oci data integration architecture, workspaces, assets, connections, and security and data flows, operators, expressions, parameters, transformations, and data quality. The course connects Oracle architecture, configuration, development, or functional processing to ownership, security, data quality, controls, and measurable acceptance criteria.

The later modules cover integration tasks, pipelines, scheduling, dependencies, and error handling and publishing, monitoring, performance, cost, governance, and etl troubleshooting. Learners use workspace configuration, connection tests, data-flow previews, transformation output to distinguish configuration defects from data, access, integration, performance, or operational failures.

By completing the learning path, participants can support a serverless ETL pipeline ingesting source data, applying governed transformations, loading a target, and recovering failed runs. They also produce an improvement plan covering validation, exception handling, rollback, ownership, monitoring, and production support.

What You Will Learn

• Assess readiness for OCI Data Integration Architecture, Workspaces, including ownership and prerequisites.
• Establish Assets, Connections, Security and demonstrate success with workspace configuration.
• Carry out Data Flows, Operators with recorded inputs, controls, and outputs.
• Reduce exposure to credential failure by validating Expressions, Parameters, Transformations at the correct stage.
• Develop hands-on capability in Integration Tasks, Pipelines using representative data.
• Measure Scheduling, Dependencies, Error Handling with pipeline history and explain any variance.
• Support Publishing, Monitoring through diagnostics, recovery planning, and operational documentation.
• Troubleshoot partial target updates by reviewing Performance, Cost, Governance without introducing an unverified production change.

SkillDynamo Training Approach

Delivery combines Oracle-specific demonstrations, guided hands-on exercises, scenario analysis, validation checklists, structured troubleshooting, peer review, and a final improvement plan. Learners document assumptions, settings, data, outputs, exceptions, corrective actions, rollback needs, approvals, evidence, and operational responsibilities.