Trainings

Course Image Course Name Course Details Course Hour Course Duration
Informatica MDM SaaS and Business 360 Overview

Challenges of managing Master Data
Multidomain MDM SaaS Overview
Multidomain MDM SaaS Architecture
Key Features and Benefits
Key Concepts & User Interfaces
Business 360 Console Overview

1 Hrs 1 Day
Informatica Cloud Data Quality

Cloud Data Quality Overview
What is Data Quality?
Discussing the Data Quality Management Process Cycle
Listing and Explaining the Dimensions of Data Quality
Cloud Data Quality Services and Assets
Profiling Data
What are Dictionaries and why are they used?
Using Rule Specifications to Cleanse and Enhance Data
Lab: Reviewing Team Assets

Cloud Mapping Designer
Cloud Mapping Designer Overview
Mapping Designer Terminologies
Mappings and Mapplets
Common Transformations
Lab: Configuring a Mapping to Load Data into a SQL Table

The Labeler Asset
Standardization Overview
Introduction to the Labeler Asset
Configuring a Labeler Asset in Token Labeler Mode
Configuring a Labeler Asset in Character Labeler Mode
Lab: Creating a Labeler to Mask Non-Numeric Data

The Cleanse Asset
Introduction to the Cleanse Asset
Cleansing, Standardizing, and Enhancing Data
Building a Mapping to Cleanse and Transform Data
Lab: Configuring a Mapplet to Remove Noise from a Numeric Field
Lab: Configuring a Multi Instance Cleanse Asset to Cleanse and Standardize the Address Fields
Lab: Configuring a Mapplet to Derive a Master Contact Name
Lab: Configuring a Mapping to Cleanse, Standardize, and Enrich Data

The Parse Asset
Introduction to the Parse Asset
Parsing Data
Lab: Configuring a Parse Asset using Pre-built Mode
Lab: Configuring a Parse Asset using a Regular Expression
Lab: Updating the Load Mapping to include both datasets
Lab: Standardizing the Data

The Deduplicate Asset
Introduction to the Deduplicate Asset
Matching Theory
Identifying Matching or Related Records
Configuring the Deduplicate Asset to Consolidate Matched Data
Lab: Configuring a Deduplicate Asset to Identify Duplicate or Related Records
Lab: Creating a Mapping to Identify Duplicate Records
Lab: Updating the Deduplicate Asset to Consolidate Matched Records

The Verifier Asset
Introduction to the Verifier Asset
Verifying Address Data
Lab: Configuring a Verifier Asset to Verify and Correct US Master Records
Lab: Creating a Mapping to Verify Master Records

Data Quality Bundles
Introduction to Data Quality Bundles
Lab: Working with Data Quality Bundles

40 Hrs 5 Days
Python Programming and PostgreSQL

1. OOP Concepts

Classes and Objects
Attributes and Methods
Constructors
self Keyword
Instance and Class Variables
Instance, Class and Static Methods
Encapsulation
Inheritance
Polymorphism
Abstraction
Method Overriding
Method Overloading Concepts
Multiple Inheritance
MRO
super()
Magic/Dunder Methods
Properties
Composition vs Inheritance
Dataclasses

2. Python Fundamentals

Introduction to Python
History and Features of Python
Python Installation and Environment Setup
Python Interpreter and Execution Process
VS Code Setup for Python
Python Syntax and Indentation
Comments and Documentation
Variables and Constants
Keywords and Identifiers
Data Types
Type Conversion
Input and Output
Operators
Expressions
Basic Programming Exercises

3. Control Flow

Conditional Statements
if, elif, else
Nested Conditions
Ternary Operator
for Loop
while Loop
break, continue and pass
range(), enumerate() and zip()
Nested Loops
Pattern Programming
Lab: Building a Calculator
Lab: Student Grade Calculator
Lab: ATM Simulation

4. Python Data Structures

Strings and String Operations
Lists
Tuples
Sets
Dictionaries
Nested Data Structures
List Comprehension
Dictionary Comprehension
Set Comprehension
Sorting and Searching
Mutable vs Immutable Objects
Shallow Copy and Deep Copy
Lab: Student Management System
Lab: Shopping Cart System
Lab: Duplicate Data Cleaner

5. Python Functions

Introduction to Functions
Defining and Calling Functions
Parameters and Arguments
Positional and Keyword Arguments
Default Arguments
*args and **kwargs
Return Values
Variable Scope
LEGB Rule
Lambda Functions
map(), filter() and reduce()
Recursive Functions
Higher-Order Functions
Closures
Lab: Employee Salary Processor

6. Python Modules

Import System
Built-in Modules
Creating Custom Modules
Packages and __init__.py
Python Package Structure
pip and PyPI
Virtual Environment
requirements.txt
Environment Variables
.env Configuration
Lab: Building a Reusable Python Package

7. Exception Handling

Errors vs Exceptions
try, except, else and finally
Built-in Exceptions
Multiple Exception Handling
raise Statement
Custom Exceptions
Exception Design and Best Practices
Lab: Error-Safe Banking Application

8. File Handling

File System Concepts
Reading and Writing Files
File Modes
with Statement
Text Files
CSV Files
JSON Files
Path Handling
pathlib Module
File and Directory Operations
Lab: CSV Employee Management
Lab: JSON Data Management

9. Advanced Python Programming

Iterators
Iterator Protocol
Generators
yield
Generator Expressions
Decorators
Nested Functions
Closures
Context Managers
Custom Context Managers
Regular Expressions
re Module
Pattern Matching
Type Hints
Optional and Union Types
Dataclasses
Enums
Collections Module
itertools
functools
Logging
Debugging and Tracebacks
Python Debugger (pdb)
Lab: Log Monitoring System

10. Python Standard Libraries

os Module
sys Module
pathlib
shutil
glob
datetime
time
math
random
statistics
collections
itertools
functools
subprocess
uuid
hashlib
secrets
argparse
Lab: Python Automation Toolkit

11. Python Automation

File Automation
Directory Automation
File Renaming
File Organization
Backup Automation
CSV/Excel Automation
API Automation
Email Automation
Command-Line Applications
Task Automation
Lab: Automated File Management System
Lab: Automated Report Generator

12. SQL and PostgreSQL with Python

Database Fundamentals
Relational Database Concepts
SQL Fundamentals
CRUD Operations
Filtering and Sorting
Joins
Grouping and Aggregation
Subqueries
Indexes
Transactions
PostgreSQL Setup
Python Database Connectivity
psycopg
Database Connections
Cursors
Parameterized Queries
Commit and Rollback
Database Error Handling
Lab: Employee Database System
Lab: Banking Database System

120 Hrs 40 -60 Days