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 Building Blocks
- Handling complex data types.
- Managing fields, metadata, and dynamic structures.
- Establishing reusable transformation patterns.
Parameters, Variables, and Job-Oriented Design
- Utilising runtime variables and managing scoping.
- Parameterising transformations for flexibility.
- Structuring parent-child job hierarchies.
Database Integration and Lookup Strategies
- Implementing advanced lookup steps.
- Applying effective caching strategies.
- Designing efficient joins.
Working with Files, APIs, and External Systems
- Processing JSON and XML data.
- Interacting with REST and SOAP services.
- Managing streaming and batch loads.
Error Handling and Data Quality Techniques
- Capturing and routing errors effectively.
- Implementing data validation patterns.
- Conducting auditing and logging activities.
Performance Tuning Essentials
- Optimising step design for efficiency.
- Considering memory usage and threading.
- Identifying and resolving bottlenecks.
Introduction to Repository-Based Development
- Leveraging the Pentaho repository.
- Managing versions of assets.
- Adopting team collaboration practices.
Deployment and Migration Practices
- Promoting jobs across different environments.
- Managing configurations systematically.
- Applying operational best practices.
Summary and Next Steps
Requirements
- A solid grasp of ETL fundamentals.
- Practical experience with Pentaho Data Integration.
- Foundational knowledge of data warehousing concepts.
Audience
- ETL developers.
- Data engineers.
- Technical professionals aiming to expand their PDI skillset.
Testimonials (1)
It's a hands-on session.
