Etl Certification Course

ETL Testing Online Training

Course Duration

The training comprises of 30 hours of training sessions that are accommodated in convenient batches (weekday or weekend sessions)

Training Materials

1. Helps with real time scenario based training designed by certified industry experts and working professionals with vast experience on ETL testing projects
2. Advanced training built on latest tools, innovative teaching methods and real time exercises
3. Live hands on practice sessions
4. Lucid, clear, up to date and easy to understand course content for each module in the curriculum

What’s Needed To Join This Course?

Candidates should have good logical and reasoning abilities; willingness and exploring capabilities that would help in excelling in this field.

Who Are Ideal Candidates?

Anyone with IT or non IT background can enroll for this course. Knowledge of programming skill is not necessary for this course. This course is for beginner to advance level professionals who wish to build a sound career in ETL testing.

Course Info

A detailed knowledge is provided on various topics that includes Data Warehousing concepts, Data Acquisition, extraction, Transformation and Loading, Database design, Star schema, types of software testing, ETL testing concepts, ETL testing workflow process, ETL test plan, ETL test cases, reporting bugs in ETL testing, etc.

Why KEYLINESOFT?

ETL testing online training course at our institute is designed by software testers with nearly 15 years of working knowledge in some of the country's best software firms. Some of the benefits offered by our training institution are:

1. Live, real-time and interactive training sessions. Non self-paced or pre-recorded sessions to give you a feel of in-person classroom training.
2. Live chat, discussions and online collaboration features allows smooth flow of information between students, peers and trainers.
3. Reasonable course fee
4. 100% job placement guarantee offered post successful completion of the training

ETL and Report Testing Course Details

What is Data Warehousing?

Differences between OLTP and Data Warehousing

DATA ACQUISITION

1. DATA EXTRACTION
2. DATA TRANSFORMATION
3. DATA LOADING

Data Marts

1. Dependent DM
2. Independent DM
3. Data Warehousing Life Cycle
4. Database Design
5. Star Schema
6. Snowflake Schema
7. Fact Constellation Schema

SCD (Slowly changing Dimensions)

1. TYPE1 SCD
2. TYPE2 SCD
3. TYPE3 SCD

Basic concepts in SQL

Overview of ETL Tool Architecture

Components in ETL Tool

Coding and Testing process in different transformation rules:

1. SAMPLE Loading from source to target
2. SORTER Transformation
3. FILTER Transformation
4. ROUTER Transformation
5. EXPRESSION Transformation
6. JOINER Transformation
7. UNION Transformation
8. AGGREAGATOR Transformation
9. RANK Transformation
10. STORED PROCEDURE Transformation
11. SEQUENCE GENERATOR Transformation
12. Flat File
13. SQL Transformation

Training & Placement in USA

Keylinesoft

• SAP All Modules
• Tableau
• Sharepoint
• Selenium
• Sap HCM
• SalesForce Administration
• QA Automation Testing
• Linux Administration
• CCNA
• Oracle Database 12c
• OBIEE
• WebLogic
• PeopleSoft DBA
• PeopleSoft HRMS
• MS SQL Server
• MS SQL Server DBA
• SAS Clinicals
• TIBCO
• Ruby On Rails
• Qlikview
• Linux
• Java
• .Net
• Salesforce
• Oracle DBA
• Crystal Reports
• Data Modeling
• Informatica
• SAS
• Microstrategy
• Cognos

Welcome to All OPT/ CPT/ H1B/ H4/F1/GreenCard Citizens for bright Career USGlobalIT OFFERS REGULAR, WEEKEND AND FASTTRACK TRAININGS

Keylinesoft provides professional training services in Software QA Testing, Business Analysis(BA), Ruby, Rails, Selenium, Watir, JAVA/J2EE, Microsoft .Net technologies (C#, VB,ASP, Crystal Reports etc..), Business Objects, SharePoint, Informatica, Oracle DBA, SQL Server DBA, ASP, BRIO, Advanced Quick Test Pro, Advanced Loadrunner. IBM/Rational Test Manager, Robot, SAP (Basis, Security, XI, CRM, SD, MM, PP, HR, BI/BW, Fi/Co, SEM, SCM,) Software Training, etc. for every one everywhere in the world.

Keylinesoft is committed to delivering a thoroughly satisfactory experience with every recruitment project. We hold ourselves to extremely high standards of professionalism, integrity and accuracy, and we invite you to put us to the test!

Our services as a career placement agency extend far beyond lining up an interview. Once we've identified an opportunity that suits you, we make sure that you're equipped to land the job, and to impress your new employer from day one.

Why Keylinesoft?

1. Rigorous training and interactive sessions with real time scenarios

2. Availability of faculties every day evening in weekdays for doubts clarification

3. Customized Training Packages / Crash Courses if required.

4. Just right class size for balance between community learning and individual attention from Instructor

5. Repeat courses at no additional charge.

6. Instructors with extensive experience in teaching and IT industry as well.

7. Material will be provided for training and interview preparation.

8. Live project applications will be discussed.

9. Interview point exercises will be discussed.

10. Assistance will be given for excellent Resume Preparation

11. Talented and committed marketing team for Placement assistance

12. Professional environment driven by values and friendly relations

13. Assisting you in finding a Real time project experience if needed after finishing of training

---

More Courses, More flexibility, Scheduled More Often

Keylinesoft.

We pride ourselves on making mutually beneficial matches between job seekers and our corporate clients, and go to great lengths to ensure that each satisfies the needs and expectations of the other. We do so by taking the time to thoroughly understand the specific needs of each of our clients, and then using proprietary recruitment techniques to pinpoint the most suitable job candidates.