Radical Technologies

The Syllabus

Curriculum Designed by Experts

Introduction to ETL and DW Concepts
  • What is Data Warehousing?
  • Differences between OLTP and Data Warehousing
  • Why we need two separate solution for real time and warehousing

 Data Acquisition :

  • DATA EXTRACTION

How to extract data from several sources and load into same target table

  • DATA TRANSFORMATION

How to perform transformation logics on data

  • DATA LOADING

How to load data into final target table

Data Marts :

  • Need and usage of data marts and types of data marts

Dependent DM

Independent DM 

Data Warehousing Life Cycle

Types of Tables :

  • Fact Table
  • Dimension table 

Schemas :

  • Star Schema
  • Snowflake Schema
  • Fact Constellation Schema 

SCD (Slowly Changing Dimensions) :

Different types of SCD’s which developer develops and a tester has to test as per different types of data needs of clients

We implement SCD-1 and  SCD-2 in class to show the implementation part more transparently and explain SCD-3 to define how to work on limited historical data as well which is used sometimes

Types :

  • TYPE1 SCD
  • TYPE2 SCD
  • TYPE3 SCD 
ETL Tool Implementation and Testing Concepts

Basic Concepts In Sql (Select, Update, Insert and Delete) :

How  to design frequently used testing queries to validate the data in source and target for both of the reasons Data Quality and Correctness to ensure that expected data came into the final and mediator target tables or not. 

Overview of Etl Tool Architecture :

  • How ETL tool works and what is the basic need of ETL tools in the market,
  • What are the similarities between ETL tools and SQL
  • Why we use ETL Tools if SQL is the only standard which any Database or Data Warehouse can use
  • How ETL Tools work at back end
  • Different ETL Tools in the market
  • What types of tasks tester performs on ETL for testing purpose
  • Informatica PowerCenter (Leading tool in the market) 
Coding and testing process in different transformation rules
  • SAMPLE Loading from source to target
  • SORTER Transformation
  • FILTER Transformation
  • EXPRESSION Transformation
  • JOINER Transformation
  • UNION Transformation
  • AGGREAGATOR Transformation
  • SEQUENCE GENERATOR Transformation
  • SQL Transformation

We provide this practice as additional benefit to you so that you can implement jobs  by yourself to understand that what developers do in real time which you have to test. 

Testing Techniques in ETL
  • MINUS Query
  • COUNT Query
  • UNION Query
  • JOIN Query 
Informatica PowerCenter
  • How developers work on PowerCenter
  • Different components of PowerCenter
  • Tasks developed in different components 
Data Stage
  • What is Data Stage
  • Differences between Informatica PowerCenter and DataStage
  • Components of DataStage
  • Differences between ETL development process in Informatica and DataStage  
Additional Benefits
  • Interview Questions
  • Resume preparations
  • Real-time Scenarios examples and solution discussion
  • Assignments  

Enquire Now

    Why Radical Technologies

    Live Online Training

    Highly practical oriented training
    Installation of Software On your System
    24/7 Email and Phone Support
    100% Placement Assistance until you get placed
    Global Certification Preparation
    Trainer Student Interactive Portal
    Assignments and Projects Guided by Mentors
    And Many More Features
    Course completion certificate and Global Certifications are part of our all Master Program

    Live Classroom Training

    Weekend / Weekdays / Morning / Evening Batches
    80:20 Practical and Theory Ratio
    Real-life Case Studies
    Easy Coverup if you missed any sessions
    PSI | Kryterion | Redhat Test Centers
    Life Time Video Classroom Access ( coming soon )
    Resume Preparations and Mock Interviews
    And Many More Features
    Course completion certificate and Global Certifications are part of our all Master Program

    Self Paced Training

    Self Paced Learning
    Learn 300+ Courses at Your Own Time
    50000+ Satisfied Learners
    Course Completion Certificate
    Practical Labs Available
    Mentor Support Available
    Doubt Clearing Session Available
    Attend Our Virtual Job Fair
    10% Discounted Global Certification
    Course completion certificate and Global Certifications are part of our all Master Program

    Like the Curriculum ? Let's Get Started

    Global Certification

    Radical Technologies is the leading IT certification institute in Kochi, offering a wide range of globally recognized certifications across various domains. With expert trainers and comprehensive course materials, it ensures that students gain in-depth knowledge and hands-on experience to excel in their careers. The institute’s certification programs are tailored to meet industry standards, helping professionals enhance their skillsets and boost their career prospects. From cloud technologies to data science, Radical Technologies covers it all, empowering individuals to stay ahead in the ever-evolving tech landscape. Achieve your professional goals with certifications that matter.

    course certificate

    Online Classroom PREFERRED

    Discount Voucher

    "Register Now to Secure Your Spot in Our Featured Course !"

    BOOK HERE

    career services

    About Us

    At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalized resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career. Join us and let your journey to a successful future begin with the right support.

    At Radical Technologies, we ensure you’re ready to shine in any interview. Our comprehensive Interview Preparation program includes mock interviews, expert feedback, and tailored coaching sessions to build your confidence. Learn how to effectively communicate your skills, handle technical questions, and make a lasting impression on potential employers. With our guidance, you’ll walk into your interviews prepared and poised for success.

    At Radical Technologies, we believe that a strong professional profile is key to standing out in the competitive IT industry. Our Profile Building services are designed to highlight your unique skills and experiences, crafting a resume and LinkedIn profile that resonate with employers. From tailored advice on showcasing your strengths to tips on optimizing your online presence, we provide the tools you need to make a lasting impression. Let us help you build a profile that opens doors to your dream career.

    completed course section

    Radical Learning Eco-System

    Exam simulator

    Cloud Send Borey

    Hands - on Cloud Lab

    Developer Coding Ground

    Testimonials

    Our Alumni

    Online Batches Available for the Areas

    Kochi | Fort Kochi | Mattancherry | Ernakulam | Marine Drive | Kakkanad | Palarivattom | Kadavanthra | Chullikkal | Elamakkara | Kochi Port | Vyttila | Aluva | Thrippunithura | Panampilly Nagar | Edappally | Kothad | Njarackal

    ETL Testing Course Certification with Training in Kochi

    At Radical Technologies, we are committed to providing world-class Azure Data Engineer Training in Bangalore, helping aspiring data professionals master the skills needed to excel in the rapidly growing field of cloud data engineering. As the leading institute for Azure Data Engineer Course In Bangalore, we offer comprehensive, hands-on training designed to meet the demands of today’s data-driven organizations.

    Our Azure Data Engineer Training Bangalore program covers every aspect of the Azure Data Engineer Syllabus, ensuring that students receive in-depth knowledge of data architecture, data processing, and data storage on Microsoft Azure. Whether you prefer attending classes in-person or via Azure Data Engineer Online Training, Radical Technologies provides flexible learning options to suit your needs.

    Our Azure Data Engineering Training is renowned for its practical, real-world approach. Students have access to an industry-leading Azure Data Engineer Bootcamp, which combines theory and hands-on labs to ensure they are fully prepared for their certification exams. The Microsoft Azure Data Engineer Training is tailored to cover all key topics, from data integration to security, and is led by experienced professionals who are experts in their field.

    For professionals and organizations seeking Azure Data Engineering Corporate Training, we offer tailored courses that address specific business needs. Our Azure Data Engineering Corporate Training Course ensures that teams gain practical experience in building scalable, secure, and efficient data solutions on Azure.

    At Radical Technologies, our Azure Data Engineer Courses are structured to ensure that both beginners and experienced professionals alike can enhance their knowledge. The Azure Data Engineer Certification Training offered here equips students with the skills and credentials needed to stand out in a competitive job market.

    Our institute also offers the Azure Data Engineer Full Course, which provides a comprehensive pathway for mastering Azure Data Engineering concepts and techniques. We take pride in being one of the top Azure Data Engineer Institutes in Bangalore, with a proven track record of helping students achieve their Azure Data Engineering Certification.

    Whether you are looking for Azure Data Engineer Training Online or prefer our in-person classes in Bangalore, Radical Technologies is your trusted partner for career advancement in data engineering. Join us today to enroll in the Best Azure Data Engineer Course and kick-start your journey towards becoming a certified data engineer.

    ETL Testing Related Courses

    MOBILE TESTING WITH APPIUM

    Mobile testing with Appium is the process of automating the testing of mobile applications across different mobile operating systems and...

    LOAD RUNNER

    Load Runner is automate and test applications, measuring system behavior and performance under load. LoadRunner is a performance testing tool...

    MANUAL TESTING

    Manual Testing is a structured process of evaluating software applications by human testers to ensure that they meet specified requirements...

    ETL TESTING

    Informatica is not only ETL tool but also Data integrator. Informatica is one of the Best tool in current industry...

    SELENIUM USING PYTHON

    Open Source and Portable – Selenium is an open source and portable Web testing Framework. Combination of tool and DSL...

    QTP QC

    HP QuickTest Professional (QTP), an automated functional testing tool that helps testers to perform automated regression testing in order to...

    SELENIUM + CORE JAVA

    Selenium is a new generation automation testing tool to automate web based application/Mobile application.It is also the core technology in...

    JMETER

    Apache JMeter is a Java-based, versatile, and extensible performance testing tool designed to assess the performance, scalability, and reliability of...

    TOSCA

    TOSCA is an integrated test automation and continuous testing platform that offers end-to-end support for software testing across various phases...

    CUCUMBER + REST ASSURED + JENKINS

    Cucumber with REST Assured and Jenkins is a combination of tools and practices commonly used for automating and managing the...

    SELENIUM +CORE JAVA + CUCUMBER + REST ASSURED + JENKINS

    Selenium with Core Java, Cucumber, REST Assured, and Jenkins is a comprehensive test automation stack commonly used for end-to-end testing...
    Enquire Now








      X
      Enquire Now

        Enquire Now & Get 10% Off!

        (Our Team will call you to discuss the Fees)

          Get a Call Back from Our Career Assistance Team

            Enquire Now & Get 10% Off!

            (Our Team will call you to discuss the Fees)

                Get a Call Back from Our Career Assistance Team