Get in Touch

Course Outline

Advanced Transformation Building Blocks

  • Handling complex data types
  • Managing fields, metadata, and dynamic structures
  • Implementing reusable transformation patterns

Parameters, Variables, and Job-Oriented Design

  • Understanding runtime variables and scoping
  • Parameterizing transformations
  • Constructing parent-child job structures

Database Integration and Lookup Strategies

  • Utilizing advanced lookup steps
  • Applying caching strategies
  • Designing efficient joins

Working with Files, APIs, and External Systems

  • Processing JSON and XML formats
  • Invoking REST and SOAP services
  • Executing streaming and batch loads

Error Handling and Data Quality Techniques

  • Capturing and routing errors
  • Implementing data validation patterns
  • Establishing auditing and logging protocols

Performance Tuning Essentials

  • Optimizing step design
  • Addressing memory and threading considerations
  • Identifying bottlenecks

Introduction to Repository-Based Development

  • Leveraging the Pentaho repository
  • Managing version control
  • Adopting team collaboration practices

Deployment and Migration Practices

  • Promoting jobs across different environments
  • Managing configurations
  • Following operational best practices

Summary and Next Steps

Requirements

  • A solid grasp of ETL fundamentals
  • Prior experience with Pentaho Data Integration
  • Foundational knowledge of data warehousing concepts

Target Audience

  • ETL developers
  • Data engineers
  • Technical professionals looking to expand their PDI expertise
 21 Hours

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 3900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (2)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories