Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/content/77/8880177/html/ipartner/db.php on line 2
Testing Training (ETL, Selenium, Software, Hadoop) - Combo Course -iPartner

Testing Training (ETL, Selenium, Software, Hadoop) - Combo Course

  1. Testing Training (ETL, Selenium, Software, Hadoop) - Combo Course
92 hr / 830*
(* including all taxes.)

Key Features

Course Agenda

  • Overview of ETL testing
  • Concepts of Business Intelligence
  • Lifecycle of ETL testing
  • Core concepts of Database
  • Difference between OLTP and OLAP
  • Concepts of Data Warehousing
  • What is RDBMS?
  • Concepts of relational databases
  • Data Types
  • Integrity Constraints
  • Comparison between Database Testing and Data Warehouse Testing
  • Workflow for Data Warehouse
  • Various Scenarios in ETL Testing
  • Data Warehouse Testing
  • ETL Mapping
  • Data Loss/Mismatch Testing
  • Testing Scenario Matrix
  • Constraint Testing
  • Source to Target Testing
  • Business Rules Testing
  • Negative Scenarios Testing
  • Dependency Testing
  • Error Handling Testing
  • Database Structure
  • SQL for Testers
  • Data Checks using SQL
  • Examples of SQL Scripts
  • Check List – ETL Tester
  • Key responsibilities of the Tester
  • SCD Testing
  • CUBE Testing
  • BI testing and its scope
  • Concept of automation testing
  • Significance of automation testing
  • Purpose of automating
  • What is Selenium?
  • Benefits of using selenium
  • Selenium vs. QTP
  • Introduction to Selenium IDE (Integrated Development Environment)
  • What is Selenium Remote Control (RC)?
  • Concept of Selenium Grid
  • Working with Selenium Web Driver
  • Recoding a selenium test case
  • IDE Features
  • General Selenese commands
  • Adding assertions to the script
  • Running your first selenium script and Options
  • Test suite in IDE
  • Sample project using IDE / Sales Force
  • Limitations of selenium IDE
  • Selenium web driver architecture
  • Selenium web driver
  • Download and Installation
  • Java program (Write and execution)

  • Scripting using web drivers
  • HTML Tags and Elements
  • Form Elements / Table Elements
  • Fire bug/Fire Path
  • Installation of fire path
  • Searching elements by name
  • Searching elements by link text
  • Searching elements by XPath
  • Searching elements using CSS
  • Web Element Properties
  • Switch to Frame, Alert and Window
  • Advanced User Interactions : Double Click, Drag and Drop , Keys and Context
  • Cross Browser Testing using WebDriver
  • Installing TestNG plugin in Eclipse
  • Sample Script of TestNG
  • Learn how to write Selenium test script
  • How to create test suites with TestNG?
  • Generating reports using TestNG
  • Annotations
  • Parameters
  • Groups- Include and Exclude
  • Test Result
  • DataProviders
  • TestNg Data Providers
  • Screenshot on failed Test cases
  • Wait statements of Web Driver
  • Testing History
  • Testing description
  • Need for testing
  • Defect description
  • principles of Testing
  • Quality Assurance and control
  • Scope
  • Occurrence of Testing
  • Constraints of Testing
  • Software Tester Roles
  • SDLC Overview
  • Life Cycle models
  • STLC Overview
  • AGILE Testing
  • Test Strategy and Planning
  • Customizing Test Process
  • Budgeting Overview
  • Scheduling
  • Risk and configuration management
  • Test Scenarios, cases and Data
  • Test Case and Scenario Difference
  • Test Case creation for application
  • Traceability Matrix and Sample description
  • Dynamic Techniques
  • Experience-based techniques
  • Static Techniques

  • Overview on Build and Release
  • Release Notes
  • Pre QA Checklist
  • Entry and Exit criteria
  • Test Execution, Hands on
  • Need for Automation
  • Overview of Different Automation Tools – QTP and Selenium
  • Quality Center Overview
  • FAQs
  • Big Data, Factors constituting Big Data
  • Hadoop and Hadoop Ecosystem
  • Map Reduce -Concepts of Map, Reduce, Ordering, Concurrency, Shuffle, Reducing, Concurrency
  • Hadoop Distributed File System (HDFS) Concepts and its Importance
  • Deep Dive in Map Reduce – Execution Framework, Partitioner, Combiner, Data Types, Key pairs
  • HDFS Deep Dive – Architecture, Data Replication, Name Node, Data Node, Data Flow
  • Parallel Copying with DISTCP, Hadoop Archives
  • Installing Hadoop in Pseudo Distributed Mode, Understanding Important configuration files, their Properties and Demon Threads
  • Accessing HDFS from Command Line
  • Map Reduce – Basic Exercises
  • Understanding Hadoop Eco-system
  • Introduction to Sqoop, use cases and Installation
  • Introduction to Hive, use cases and Installation
  • Introduction to Pig, use cases and Installation
  • Introduction to Oozie, use cases and Installation
  • Introduction to Flume, use cases and Installation
  • Introduction to Yarn
    How to develop Map Reduce Application, writing unit test
  • Best Practices for developing and writing, Debugging Map Reduce applications
  • What Is Pig?
  • Pig’s Features
  • Pig Use Cases
  • Interacting with Pig
  • What Is Hive?
  • Hive Schema and Data Storage
  • Comparing Hive to Traditional Databases
  • Hive vs. Pig
  • Hive Use Cases
  • Interacting with Hive
  • Automation testing using the OOZIE.
  • Data validation using the query surge tool.
  • Test plan for HDFS upgrade
  • Test automation and result

Learn & Get

  • Understand the use of Object Repository and Maven
  • Understand Action Class and write common functions
  • Understand the need for Software Testing and related Terminology
  • Create Test Cases and learn Techniques of Testing
  • Deep dive into Hadoop Distributed File System (HDFS)
  • Understand Hadoop main components and Ecosystem

Payment Method

You need to pay through PayPal. We accept both Debit and Credit Card for transaction.
We subsidize our fees by 10% for military personnel, and college students with exceptional records. To apply for a scholarship, email
In our iPartner self-paced training program, you will receive the training assessments, recorded sessions, course materials, Quizzes, related softwares and assignments. The courses are designed in such a way that you will the get real world exposure; the solid understanding of every concept that allows you to get the most from the online training experience and you will be able to apply the information and skills in the workplace. After the successful completion of your training program, you can take quizzes which enable you to check your level of knowledge and also enables you to clear your relevant certification at higher marks/grade where you will be able to work on the technologies independently.
In Self-paced courses, the learners are able to conduct hands-on exercises and produce learning deliverables entirely on their own at any convenient time without a facilitator whereas in the Online training courses, a facilitator will be available for answering queries at a specific time to be dedicated for learning. During your self-paced learning, you can learn more effectively when you interact with the content that is presented and a great way to facilitate this is through review questions and quizzes that strengthen key concepts. In case if you face any unexpected challenges while learning, we will arrange a live class with our trainer.
All Courses from iPartner are highly interactive to provide good exposure to learners and gives them a real time experience. You can learn only at a time where there are no distractions, which leads to effective learning. The costs of self-paced training are 75% cheaper than the online training. You will offer lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24*7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Please send an email. You can join our Live chat for instant solution.
We will provide you the links of the software to download which are open source and for proprietary tools, we will provide you the trail version if available.
You will have to work on a training project towards the end of the course. This will help you understand how the different components of courses are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the class.
Yes, we do keep launching multiple offers that best suits your needs. Please email us at: and we will get back to you with exciting offers.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
Sure! Your feedbacks are greatly appreciated. Please connect with us on the email support -