Post your need
Rajnees

Rajnees

162 Hopkins Avenue, Jersey City, NJ
Mode: Online Inclass
  • Placement, 
  • Visa Assistance, 
  • Accommodation
    •   Claimed Profile
    • IT Training
    Get consultation
        Get free quotes from expert trainers
        Verification code has been sent to your
        Mobile No: Edit
        Submitloader

        (00:30)

        If you do not receive a message in 30 seconds use call me option to verify your number

        162 Hopkins Avenue, Jersey City, NJ, Jersey City, NJ

        Some amazing things about us you should know.

        • 0+
          Students
        • 4+
          Courses
        • 8+
          Total Instructors
        • 3+
          Services offered

        About Rajnees

        Informatica

        We offer a 6 Week intensive Informatica Training followed by

        • Interview guidance and technical support during the 1st project.

        • Instruction will be both in class and online. Students will be given 24/7

        • Access to Informatica Software (Power Center 8.6, Power Exchange 8.6).

        • LimitedAccommodation is available*

        Eligibility: Preferably BS/MS in CS/ IS/ IT, IT Professionals. Candidates from Non-IT background are also welcome if they are willing to devote at least three (3) hours a day.

        Module : ETL Developer Target Audience: IT aspirants and IT Professionals looking to switch fields Topics Data Warehousing Concepts, SQL, PL/SQL, Informatica 8.6, Live Project Total Hours 54 ( Approx 6 weekends)

        Course Details

        Week 1:

        Data Warehousing

        Introduction to Data warehousing: Types of Systems, OLTP, DSS, Maintenance of Data warehouse, Data warehousing Life Cycle, Datawarehousing Testing Life Cycle, Data warehousing Architecture,Source, Integration Layer, Staging Area, Targets, Analysis & Reporting, ODS.

        Data Modeling

        Introduction, Different phases of Modeling, Multi Dimensional Modeling , Dimensions, Facts, Multi Dimensional Model Hierarchies,OLAP, MOLAP, ROLAP, HOLAP, Cubes and their Functions, Star Schema, Fact Table, Dimensional Tables, Snow flake Schema, Factless Fact Table, Confirmed Dimensions

        Week 2:

        Day 1: SQL Basics

        Day 2: Informatica

        Day 3: SQL Continued

        Introduction to Relational Database Systems: ORACLE, DB2, SQL Server Introduction to SQL:Basic SQL commands, the SELECT Statement,Ordering the output, Conditional retrieval of data , Working with variables Pseudo columns and functions, character functions, date functions , Using non-character function multiple tables, Different type of Joins, Writing Outer Joins ,Using the SET operators Aggregating data using group functions

        Introduction to Informatica, Overview, Basic Definitions, Informatica Products, Informatica Architecture, Tools and their roles, Folders Sub Folders Power center, Differences between 7x and 8x

        Creating Subqueries Enhancing groups function ,Transaction Control Language, Rollback, Commit, Processing hierarchies , Creating the Tree structure, Data Manipulation Language Data Definition Language, Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null

        Week 3:

        Day 1: Informatica Designer

        Day 2, 3: Transformations

        Introduction to designer, Designer interfaces, Designer tools, Defining Sources, Database as a source, Defining Targets, Importing from database, Creating a new target Creating target database objects Mapping Introduction, Ports, Mapping Table to Table, Mapping flat file to Table

        Expression Transformation, Aggregator Transformation, Joiner Transformation, Homogeneous, Heterogeneous, Sequence Generator Transformation, Rank Transformation, Router Transformation,Union Transformation, Source Qualifier, Source Qualifier Transformation, SQL override in Source Qualifier Transformation,Mapping Source Qualifier as Filter Source Qualifier to join data, Flat Files sources & targets, Delimited Fixed width, Debugger

        Week 4:

        Day 1, 2:

        Day 3:

        Lookup: Static, Dynamic, Unconnected, Cached & Uncached,Customized Named Cache use technique from static & dynamic lookup Flat file lookup, Handling sub second precision for a Lookup transformation, Filtered lookup Mapping Wizards, Implementing of SCDs (Each types by at least by five Methods), Type-I, Type-II, Type-III

        SQLT, Normalizer, Transaction Control, Stored Procedure Transformation, XML Transformation, Custom Transformation Informatica Workflow Manager Workflow Introduction, Tasks, Workflow Tools, Connections Defining Tasks, Command Task, Email Task, Session Task Link Conditions,Event Wait & Event Raise, Setting properties of Session Task ,Creating Workflow, Starting Workflow, Monitoring Workflow,Workflow Parameters

        Week 5 (day 1,2):

        Advanced Topics Incremental Aggregation, Mapping Analyst for Excel (MAE), Push-down Optimization Mapplet Implementation, Meta Data Backup & Restore,Copying Repository, Sending Notification Messages, Informatica Tuning,User Defined Function, Version Control, Copy folder and Deployment,Shortcut, pmcmd commands

        Week 5 / 6:

        PROJECT

        The project will be conceived and developed by the group from scratch,right from gathering requirement to final mappings. Various persons will assume various roles and the roles will be interchanged as the project progresses. The project may be based on Insurance/ Financial/Pharmaceutical industry

        Support during the 1st project

        • Technical Support will be provided to Individuals throughout the 1st project/1st Year

        • Certification Guidance

        • Individuals interested in Preparing for Certification in Informatica will be given the required material and guidance

         

        Unix

        Summary

        We offer a 4 week intensive course in POSIX with a concentration on UNIX ( SOLARIS & HP ) and Enterprise Linux to train IT professionals and students followed by extensive interview preparation by industry experts to enable the students reach an industry-demanding expertise in System Admin and related work.

        Course Detail

        Week1 Day 1

        Week 1 Day 2,3

        UNIX Overview, UNIX File structure, Basic Commands

        UNIX Shell, Editor, UNIX Man Pages, Basic UNIX commands

        Week 2 Day 1

        Week 2 Day 2,3,4

        UNIX Shells and Shell Commands
        Bash and Korn Shell
        UNIX commands Vs Built-in Shell Commands

        UNIX Editors VI, VIM, EMACS and Others
        UNIX Shell Scripting
        Regular Expressions ,AWK ,SED

        Week 3 Day 1

        Week 3 Day 2,3

        The root and users
        File Permissions
        Creating /Removing Users
        Installing OS/Software Patches

        Networking, Adding/Removing Hardware
        Backup Strategies and Tools
        Remote Administration Tools

        Week 3 Day 3,4

        Week 3 Day 5

        Advanced Sheel Programming

        UNIX Utilities

        Week 4 Day 1,2

        Week 4 Day 3,4,5

        Installing the UNIX OS, File Partitioning,
        Project

        Developing Applications in C/C++,
        Project

        Business Object

        Summary

        Intensive Five weeks training (In-class and online) in Business Objects including Real-Time Project to help achieve expertise in the industry leading reporting tool followed by a full scale preparation for interview with mock interviews by our panel of experts.

        Course Detail

        Week: 1
        Day 1:

        • Business Objects Overview
        • Business Objects Architecture
        • Tools and their roles
        • Business Intelligence/DWH concepts

        Day 2:

        • Business Objects Introduction
        • Documents
        • Reports
        • Blocks
        • Universes, Classes and Objects
        • Data Providers

        Day 3 :

        • User Interface:
        • Toolbars and Menus
        • Help
        • The Data/Properties Zone
        • The Status Bar

        Week: 2
        Day 4-6:

        • Reports and Analyzing Data
        • Editing Blocks to Manipulate Data
        • Adding Blocks to an Existing Report
        • Creating Sections in Reports
        • Adding New Reports to a Document
        • Using the Query Panel
        • Editing a Query, Building a Query
        • Running a Query
        • Simple Query Filters
        • User Defined Single Value Conditions
        • Pre-Defined Query Filters
        • Filtering, Sorting, Ranking Data
        • Using Alerts
        • Inserting Simple Calculations

        Day 7

        • Report presentation styles
        • Tables, Crosstabs, Charts and Forms
        • Formatting Blocks
        • Formatting Pages
        • Formatting Breaks
        • Special Fields
        • Using Headers and Footers
        • Adding Logos and Pictures
        • Creating Templates

        Week: 3
        Day 8-9

        • Using Multiple Data Providers
        • Understanding the concept of a Data Provider
        • Multiple Queries (Data Providers) from a Single Universe
        • Naming Data Providers
        • Querying Multiple Universes in a Single Document
        • Using Personal Data Files (Eg. Microsoft Excel spreadsheets) as Data Sources
        • Synchronizing Data Providers by Linking

        Day 10

        • Defining and Using Variables
        • Creating Variables
        • Resetting Calculations across Breaks
        • If..Then…Else Variables
        • The Group Function
        • Creating a Variable Using the Group Function
        • Understanding Calculation Contexts

        Day 11

        • Using Slice and Dice
        • The Slice and Dice View
        • Converting Tables to Crosstabs
        • Converting Table Blocks to Charts
        • Adding Breaks, Totals, Filters and other Functions

        Day 12

        • Drilling
        • Understanding Hierarchies
        • Setting the Scope of Analysis
        • Pre-Defined Hierarchies
        • Drilling on Single Hierarchies
        • Drilling on Multiple Hierarchies
        • Creating Custom Hierarchies
        • Drilling on Charts
        • Displaying the Drill Information
        • Saving Snapshots

        Week: 4
        Day 12

        • Semantic Layer (Universe) creation

        Day 13-16

        • Real-Time Project

        Week: 5
        Day 17-20

        • Real-Time Project

         

        TeraData

        Summary

        We offer a five weeks intensive training in Teradata covering from the very basics to advanced level to meet with the current and future industry demands of database management. training involves Real-time project, interview preparation and mock interviews by a team of subject experts.

        Course Detail

        Week: 1

        Introduction to TERADATA

      • UInique Features of Teradata
      • Teradata System
      • Node component
      • SMP & MPP
      • BYNET Hardware &SoftWare
      • Communication between Nodes
      • Teradata Maximums
      • TERADATA Architecture

      • Architecture Flow
      • Shared Nothing Acrhitecture
      • PE with Explain
      • Visual Data Layout
      • Primary Index

      • Purpose of Primary Index
      • Non unique Primary Index
      • unique Primary Index
      • Secondary Index

      • Purpose of the Secondary Index
      • Unique Secondary Index
      • Non Unique Secondary Index
      • Week: 2

        Teradata SQl

      • SQL Basics
      • Teradata Punctuation
      • HELP,show,Explain
      • Working With Nulls
      • And ,OR,Not, Between & like
      • Aggregation
      • Subqueries & Co-related Sub Queries
      • Aliasing,Title,cast &format
      • Interrrogating Data
      • Types of Tables

      • Set and Multiset Tables
      • Volatile Tables
      • Derived Tables
      • Global Tempory Tables
      • Teradata Spaces

      • Perm Space
      • Spool Space
      • Term Space
      • Performance Tunning with Space
      • Joins

      • Join Types
      • Join strategies
      • Join Index
      • Week: 3

        Set Operators

      • Union/Union all
      • Intersect
      • Except or minus
      • Views

      • Purpose Of view
      • Create View Syntax
      • Usage
      • Macros

      • Purpose of Macros
      • Create Macro Syntax
      • Data and Times

      • Teradata Key words
      • Storage of dates on Disk
      • DateForm
      • ADD_Months Command
      • Extract Command
      • System Calender
      • System Calendar with Date Comparision
      • Intervel Processing with Date And Time
      • Rank Function and Qualify Usage

      • Rank Functions
      • Qualify Usage
      • Rank with OLAP functions
      • OLAP Function

      • CSUM
      • MSUM
      • MAVG
      • Week: 4

        Teradata Utilites

      • MLOAD
      • FLOAD
      • FAST EXPORT
      • BTEQ
      • Locks

      • Exclusive
      • Write
      • Read
      • Access
      • Protection Features

      • Fallback
      • Raid
      • Clique
      • Stores Procedure

        Performance Tuning

        Project

        Week: 5

        Project

        Contact us@
        rajnees@gmail.com
                    1-201-993-3798     

        Rajnees Training Courses

        • -
        • DW BI

        • 3
        • +
        • Linux Unix

        • 1

        Business highlights

        • IT Professionals as Trainers

          Learning a technology with a professional who is well expertise in that solve 60% of your needs.

        • Hands-on Training

          We support any training should be more practical apart from theoretical classes. So, we always give you hands-on training.

        • Affordable Fees

          We are dead cheap in fees. We are having options to make the payment in instalments as well if needed.

        • 10000+ old students to believe

          We satisfied 10000+ students from the day we started GangBoard

        • Counselling by Experts

          We have every course material to understand which is prepared by our trainers and we will share with you after session completes.

        • Own Course Materials

          We have every course material to understand which is prepared by our trainers and we will share with you after session completes.

        Services offered

        • Online Training
        • Classroom Training
        • Placements
        • Visa Assistance
        • Accommodation
        • H1B Transfer

        Write a Review for Rajnees

        We value your time

        Become a prime member and teach what you love in your free time, because can pick their desired time to teach their trainers