Talend Data Integration

Module 1: Talend Open Studio Overview

• Talend portfolio: Open Studio, Cloud, Data Fabric
• Talend Studio interface: Repository, Design workspace, Palette
• Component-based design philosophy
• Creating a Talend project and first job
• Running jobs locally and in debug mode
• Talend certification pathway

Module 2: File & Database Connectivity

• tFileInputDelimited: reading CSV files
• tFileOutputDelimited: writing output files
• tDBInput: JDBC database query component
• tDBOutput: insert, update, delete, upsert operations
• tDBConnection and connection pooling
• tFileList: iterating over multiple files

Module 3: Core Data Transformation Components

• tMap: the central transformation component
• Expression editor: Java expressions in tMap
• Filter rows: WHERE-like filtering in tMap
• Lookup: joining with reference data in tMap
• tAggregateRow: GROUP BY aggregation
• tSortRow: data sorting component

Module 4: Data Quality & Cleansing

• tFilterRow: rule-based row filtering
• tReplaceList: bulk value replacement
• tNormalize and tDenormalize for row restructuring
• tSchemaComplianceCheck: data validation
• tDataMasking: PII masking in Talend
• Data profiling with Talend Data Profiler

Module 5: Job Orchestration & Control

• tRunJob: calling child jobs from parent
• tLoop: iterating with counter and list loops
• tFlowToIterate: sequential row processing
• tIterateToFlow: collecting iterated output
• tSetGlobalVar: sharing data between jobs
• OnComponentOk / OnComponentError routing

Module 6: Big Data & Cloud Integration

• Talend Big Data: Hadoop and Spark components
• tSparkConnection and running Spark jobs from Talend
• tS3Put / tS3Get: Amazon S3 connectivity
• Snowflake components: tSnowflakeInput and tSnowflakeOutput
• Azure Blob Storage and Azure Synapse components
• Google BigQuery connector

Module 7: Job Design Patterns & Reusability

• Subjobs and job design patterns
• Reusable routines: Java utility functions
• Context variables: environment-specific configuration
• Built-in and custom metadata management
• Git integration for version control
• Talend job export and deployment

Module 8: Monitoring, Logging & Production

• tLogRow and tLogCatcher for debugging
• tStatCatcher: execution statistics collection
• Talend Administration Centre (TAC): job scheduling
• Job execution via command line and REST API
• Error file handling and reject routing
• Performance optimisation: parallelism and bulk loading

Our Talend Data Integration instructors are Talend-certified data engineers who have built Talend data pipelines for enterprise data warehousing, cloud migration, and big data lake projects. They bring Java development knowledge essential for Talend's expression engine and hands-on experience with Talend's cloud and big data components.