Pentaho Data Integration Fundamentals Training Course

This course is designed for software engineers looking to accelerate Data Engineering Integration. You will learn how to handle large-scale data ingestion, incremental loading, complex transformations, file processing, dynamic mappings, and Python development. The curriculum explores how to repurpose application logic for Data Engineering scenarios, alongside essential monitoring, troubleshooting, and best practices.

Objectives

Upon successful completion of this course, students will be able to:

• Mass ingest data into Hive and HDFS
• Execute incremental loads within Mass Ingestion
• Carry out initial and incremental loads
• Integrate with relational databases using SQOOP
• Perform transformations across multiple engines
• Run mappings in Spark mode via JDBC
• Implement stateful computing and windowing
• Process complex files
• Parse hierarchical data using the Spark engine
• Run profiles and select sampling options on the Spark engine
• Execute Dynamic Mappings
• Create audits on mappings
• Monitor logs via the REST Operations Hub
• Monitor logs through Log Aggregation and troubleshoot issues
• Run mappings within the Databricks environment
• Create mappings to access Delta Lake tables
• Tune the performance of Spark and Databricks jobs

The "KNIME Analytics Platform" training offers a comprehensive overview of this free data analytics platform. The program covers an introduction to data processing and analysis, installation and configuration of KNIME, building workflows, methodologies for business process modeling and data modeling. The course also discusses advanced data analysis tools, workflow import and export, tool integration, ETL processes, data mining, visualization, extensions, and integrations with tools such as R, Java, Python, Gephi, and Neo4j. The conclusion covers reporting, integration with BIRT, and KNIME WebPortal.

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

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

• Install and configure Oracle GoldenGate.
• Understand Oracle database replication using the Oracle GoldenGate tool.
• Understand the Oracle GoldenGate architecture.
• Configure and perform database replication and migration.
• Optimize Oracle GoldenGate performance and troubleshoot issues.

Pentaho Open Source BI Suite Community Edition (CE) is a comprehensive business intelligence solution offering data integration, reporting, dashboarding, and data loading capabilities.

Through this instructor-led live training, participants will discover how to fully leverage the capabilities of Pentaho Open Source BI Suite Community Edition (CE).

Upon completing this training, participants will be able to:

• Install and configure Pentaho Open Source BI Suite Community Edition (CE)
• Grasp the core concepts of Pentaho CE tools and their features
• Create reports using Pentaho CE
• Integrate third-party data sources into Pentaho CE
• Leverage big data and analytics within Pentaho CE

Audience

• Programmers
• BI Developers

Course Format

• A blend of lectures, discussions, exercises, and intensive hands-on practice

Note

• To request customised training for this course, please contact us to make arrangements.

Pentaho Data Integration serves as a robust platform for constructing enterprise-grade ETL processes and data pipelines.

This instructor-led live training, available both online and onsite, is designed for advanced engineers looking to master high-performance, enterprise-scale, and heavily automated PDI solutions.

Upon completing this course, participants will be able to:

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

Course Format

• Demonstrations and architectural discussions led by experts.
• Extensive practical labs addressing advanced real-world ETL challenges.
• Hands-on development within a production-like environment.

Customization Options

• Reach out to us if you need a customized version of this training.

Pentaho Data Integration serves as a robust platform for data extraction, transformation, and loading.

This instructor-led live training, available either online or on-site, is designed for intermediate practitioners looking to elevate their Pentaho Data Integration (PDI) skills to handle more complex transformation scenarios.

Upon completing this training, participants will be equipped to:

• Design multi-step transformations that deliver improved performance.
• Effectively utilize variables, parameters, and reusable components.
• Integrate PDI seamlessly with databases, APIs, and other external systems.
• Apply industry best practices for creating maintainable and scalable ETL pipelines.

Format of the Course

• Interactive demonstrations accompanied by detailed instructor explanations.
• Guided exercises and scenario-based practice sessions.
• Practical, hands-on work within a real-world ETL project environment.

Course Customization Options

• If you require a tailored version of this course, please contact us to discuss customization.

This instructor-led, live training in Nigeria (online or onsite) is aimed at system administrators, data scientists, and business analysts who wish to set up Talend Administration Center to deploy and manage the organization's roles and tasks.

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

• Install and configure Talend Administration Center.
• Understand and implement Talend management fundamentals.
• Build, deploy, and run business projects or tasks in Talend.
• Monitor the security of datasets and develop business routines based on the TAC framework.
• Obtain a broader comprehension of big data applications.

This instructor-led, live training in Nigeria (online or onsite) is aimed at technical persons who wish to deploy Talend Open Studio for Big Data to simplifying the process of reading and crunching through Big Data.

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

• Install and configure Talend Open Studio for Big Data.
• Connect with Big Data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
• Understand and set up Open Studio's big data components and connectors.
• Configure 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.

This instructor-led live training in Nigeria (online or onsite) is designed for beginner to intermediate data analysts looking to deepen their skills and understanding in managing and enhancing data quality using Talend Data Stewardship.

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

• Develop a comprehensive understanding of the role data stewardship plays in upholding data quality.
• Use Talend Data Stewardship to manage data quality tasks.
• Create, assign, and manage tasks within Talend Data Stewardship, including customising workflows.
• Utilise the tool's reporting and monitoring capabilities to track data quality and stewardship efforts.

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

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

• Integrate, enhance, and deliver ESB technologies as single packages in various deployment environments.
• Understand and utilize the most frequently used components of Talend Open Studio.
• Integrate any application, database, API, or Web services.
• Seamlessly integrate heterogeneous systems and applications.
• Embed existing Java code libraries to extend projects.
• Leverage community components and code to extend projects.
• Rapidly integrate systems, applications, and data sources within a drag-and-drop Eclipse environment.
• Reduce development time and maintenance costs by generating optimized, reusable code.