Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Advanced Transformation Constructs
- Handling complex data types effectively
- Managing fields, metadata, and dynamic structures
- Establishing reusable transformation patterns
Parameters, Variables, and Job-Centric Design
- Managing runtime variables and scope definition
- Parameterizing transformations for flexibility
- Structuring parent-child job relationships
Database Integration and Lookup Methodologies
- Utilizing advanced lookup steps
- Implementing efficient caching strategies
- Designing optimized join operations
Interaction with Files, APIs, and External Platforms
- Processing JSON and XML data formats
- Consuming REST and SOAP services
- Managing streaming and batch loading processes
Error Management and Data Quality Assurance
- Capturing and routing error events
- Applying data validation patterns
- Implementing auditing and logging mechanisms
Performance Optimization Basics
- Refining step design for speed
- Considerations for memory usage and threading
- Identifying and resolving performance bottlenecks
Overview of Repository-Based Development
- Leveraging the Pentaho repository
- Managing version control
- Facilitating team collaboration workflows
Deployment and Migration Workflows
- Promoting jobs across different environments
- Managing configuration settings
- Adhering to operational best practices
Recap and Path Forward
Requirements
- A solid grasp of ETL fundamentals
- Practical experience with Pentaho Data Integration
- Foundational understanding of data warehousing principles
Target Audience
- ETL developers
- Data engineers
- Technical professionals aiming to expand their PDI skillset
Testimonials (1)
It's a hands-on session.
