Get in Touch
 Duration 21 hours

Course Outline

Advanced Transformation Components

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

Parameters, Variables, and Job-Centric Design

  • Managing runtime variables and scope
  • Implementing parameterized transformations
  • Structuring parent-child job hierarchies

Database Integration and Lookup Approaches

  • Advanced lookup step configurations
  • Strategic caching techniques
  • Designing efficient joins

Integration with Files, APIs, and External Systems

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

Error Management and Data Quality Strategies

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

Essentials of Performance Optimization

  • Refining step design for efficiency
  • Considering memory usage and threading
  • Identifying performance bottlenecks

Foundations of Repository-Based Development

  • Utilizing the Pentaho repository
  • Implementing version control
  • Adopting team collaboration standards

Deployment and Migration Protocols

  • Promoting jobs across different environments
  • Managing configuration settings
  • Following operational best practices

Conclusions and Future Directions

Requirements

  • Familiarity with core ETL principles
  • Practical experience with Pentaho Data Integration
  • Fundamental understanding of data warehousing concepts

Target Audience

  • ETL developers
  • Data engineers
  • Technical specialists aiming to deepen their PDI expertise

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories