• The various types of Data Modeling

• Learning to perform Conceptual Data Modeling

• Physical Data Modeling

• Logical Data Modeling

• Understanding the scope and benefits of Data Modeling.

• The Basic Architecture of multidimensional modeling

• Deploying cubes to perform multidimensional modeling

• Understanding the concepts of Facts and Dimensions and the differences between the two.

• The Talend Open Source data integration tool

• Working with Big Data

• Understanding the Talend Open Studio.

• Understanding the installation of Talend

• System requirements

• Troubleshooting of common errors

• Issues related to installation.

• Learning about the Talend Architecture

• Important concepts and features

• Talend components like Job

• Workspace

• Metadata

• Learning to create a Talend Job

• Working with Delimited file

• Working with Meta Data

• Schema for data integration

• Understanding propagation

• Deploying of tFilterRow and string filter for creating Jobs

• Creation of CSV file.

• Deploying Talend Open Studio for Data Management

• Data quality

• Integration

• Understanding the ETL and Data Warehousing concepts.

• Detailed understanding of Talend Job design and its features

• Learning about tMap

• Data aggregation techniques

• tReplicate for performing different operations on a Schema

• tMap for mapping input and output data.

• Working with DataSource Connection

• Deploying in the database component

• Creating a connection

• Database source and target

• Metadata and schema importing.

• Introduction to Talend Functions

• Calling and deploying the functions

• Understanding routines

• Talend Open Studio for XML data processing

• Date format function.

• Transforming Data

• Running the Job

• Combining Columns

• Duplicating a Job

• Creating Metadata

• Joining Data Sources.

• Capturing Rejects

• Correcting the Lookup

• Duplicating a Job

• Filtering Output Data

• Using Multiple Filters.

• Using Context Variables from Talend Job

• Repository as Metadata.

• Building Jobs

• Graphical Jobs

• Graphical Interface Of Talend

• Talend’s Components

• Naming Convention

• Row – Main Connection

• Row – Iterate Connection

• Trigger – On sub Job ok Connection

• Trigger – On Component OK Connection

File Management in Talend

• Deploying Talend to work with Hadoop

• Defining the ETL method

• Hive implementation with Talend

• Importing data in Hive

• Hive partitioning

• Pig in Talend

• Data loading

• Parallel data execution.