Online Data Integration Training in New Zealand

Pentaho Data Integration is a comprehensive platform for designing enterprise-grade ETL and data pipelines.

This instructor-led, live training (online or onsite) is aimed at advanced-level engineers who wish to master high-performance, enterprise-scale, and highly automated PDI solutions.

Upon completing this course, participants will be equipped to:

• Architect large-scale ETL pipelines with advanced orchestration.
• Optimise complex transformations for high performance.
• Implement scripting, automation, and hybrid integration patterns.
• Design robust, maintainable, production-ready workflows.

Course Format

• Expert-led demonstrations and architectural discussions.
• Extensive hands-on labs tackling advanced real-world ETL challenges.
• Practical development within a production-like environment.

Course Customisation Options

• Contact us if you require a customised version of this training.

Pentaho Data Integration is a data extraction, transformation, and loading platform.

This instructor-led, live training (online or onsite) is designed for intermediate-level practitioners seeking to advance their PDI skills for more complex transformation scenarios.

By the end of this training, participants will be able to:

• Design multi-step transformations with improved performance.
• Work effectively with variables, parameters, and reusable components.
• Integrate PDI with databases, APIs, and external systems.
• Apply best practices to build maintainable and scalable ETL pipelines.

Course Format

• Interactive demonstrations accompanied by instructor explanations.
• Guided exercises and scenario-based practice sessions.
• Hands-on experience within a real-world ETL project environment.

Course Customisation Options

• If you require a tailored version of this course, please get in touch with us to discuss customisation.

This instructor-led, live training in New Zealand (online or on-site) is tailored for system administrators and developers who wish to set up, deploy, and manage Oracle GoldenGate for data transformation purposes.

By the end of this training, participants will be able to:

• Install and configure Oracle GoldenGate.
• Gain an understanding of Oracle database replication using the Oracle GoldenGate tool.
• Comprehend the Oracle GoldenGate architecture.
• Configure and execute database replication and migration tasks.
• Optimise Oracle GoldenGate performance and troubleshoot any issues that arise.

Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations.

In this instructor-led, live training, participants will learn how to utilise Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle and maximise the value of data within their organisation.

By the end of this training, participants will be able to:

• Create, preview, and run basic data transformations containing steps and hops
• Configure and secure the Pentaho Enterprise Repository
• Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format.
• Provide results to third-party applications for further processing

Audience

• Data Analyst
• ETL developers

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

This instructor-led, live training in New Zealand (delivered either online or on-site) is designed for beginner to intermediate-level data analysts who wish to deepen their understanding and enhance their skills in managing and improving data quality using Talend Data Stewardship.

By the end of this training, participants will be able to:

• Gain a comprehensive understanding of the role of data stewardship in maintaining high-quality data.
• Use Talend Data Stewardship to effectively manage data quality tasks.
• Create, assign, and manage tasks within Talend Data Stewardship, including customising workflows.
• Leverage the tool's reporting and monitoring capabilities to track data quality and stewardship initiatives.

The "KNIME Analytics Platform" training offers a comprehensive overview of this free data analysis platform. The programme covers an introduction to data processing and analysis, KNIME installation and configuration, workflow creation, methodologies for building business models and data modelling. The course also explores advanced data analysis tools, workflow import and export, tool integration, ETL processes, data exploration, visualisation, extensions, and integrations with tools such as R, Java, Python, Gephi, and Neo4j. The conclusion includes a discussion on reporting, integration with BIRT, and the KNIME WebPortal.

This instructor-led, live training in New Zealand (online or on-site) is designed for system administrators, data scientists, and business analysts seeking to establish and manage Talend Administration Center for deploying and overseeing organisational roles and tasks.

By the conclusion of this training, participants will be able to:

• Install and configure Talend Administration Center.
• Understand and implement the fundamentals of Talend management.
• Build, deploy, and execute business projects or tasks within Talend.
• Monitor dataset security and develop business routines leveraging the TAC framework.
• Gain a broader understanding of big data applications.

This instructor-led, live training in New Zealand (online or on-site) is intended for technical professionals who wish to deploy Talend Open Studio for Big Data to streamline the process of reading and analysing big data.

By the end of this training, participants will be able to:

• Install and configure Talend Open Studio for Big Data.
• Connect to big data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
• Understand and configure Open Studio's big data components and connectors.
• Set parameters to automatically generate MapReduce code.
• Use Open Studio's drag-and-drop interface to run Hadoop jobs.
• Prototype big data pipelines.
• Automate big data integration projects.

In this instructor-led, live training in New Zealand, participants will learn how to use Talend Open Studio for ESB to create, connect, mediate, and manage services along with their interactions.

By the end of this training, participants will be able to:

• Integrate, enhance, and deliver ESB technologies as unified packages across various deployment environments.
• Understand and effectively utilise Talend Open Studio's most commonly used components.
• Integrate any application, database, API, or web service.
• Seamlessly connect heterogeneous systems and applications.
• Embed existing Java code libraries to extend project capabilities.
• Leverage community-driven components and code to expand project functionality.
• Rapidly integrate systems, applications, and data sources within a drag-and-drop Eclipse environment.
• Reduce development time and maintenance costs by generating optimised, reusable code.