ETL Testing / Data Warehouse Testing – Tips, Techniques, Process and Challenges

This is a guest post by Vishal Chhaperia. If you want to publish your article please read our article guidelines.

Today let me take a moment and explain my testing fraternity about one of the much in demand and upcoming skills for my tester friends i.e. ETL testing (Extract, Transform, and Load). This article will present you with a complete idea about ETL testing and what we do to test ETL process.

It has been observed that Independent Verification and Validation is gaining huge market potential and many companies are now seeing this as prospective business gain. Customers have been offered different range of products in terms of service offerings, distributed in many areas based on technology, process and solutions. ETL or data warehouse is one of the offerings which are developing rapidly and successfully.

ETL testing

Why do organizations need Data Warehouse?
Organizations with organized IT practices are looking forward to create a next level of technology transformation. They are now trying to make themselves much more operational with easy-to-interoperate data. Having said that data is most important part of any organization, it may be everyday data or historical data. Data is backbone of any report and reports are the baseline on which all the vital management decisions are taken.

Most of the companies are taking a step forward for constructing their data warehouse to store and monitor real time data as well as historical data. Crafting an efficient data warehouse is not an easy job. Many organizations have distributed departments with different applications running on distributed technology. ETL tool is employed in order to make a flawless integration between different data sources from different departments. ETL tool will work as an integrator, extracting data from different sources; transforming it in preferred format based on the business transformation rules and loading it in cohesive DB known are Data Warehouse.

Well planned, well defined and effective testing scope guarantees smooth conversion of the project to the production. A business gains the real buoyancy once the ETL processes are verified and validated by independent group of experts to make sure that data warehouse is concrete and robust.

ETL or Data warehouse testing is categorized into four different engagements irrespective of technology or ETL tools used:

  • New Data Warehouse Testing – New DW is built and verified from scratch. Data input is taken from customer requirements and different data sources and new data warehouse is build and verified with the help of ETL tools.
  • Migration Testing – In this type of project customer will have an existing DW and ETL performing the job but they are looking to bag new tool in order to improve efficiency.
  • Change Request – In this type of project new data is added from different sources to an existing DW. Also, there might be a condition where customer needs to change their existing business rule or they might integrate the new rule.
  • Report Testing – Report are the end result of any Data Warehouse and the basic propose for which DW is build. Report must be tested by validating layout, data in the report and calculation.

ETL Testing Techniques:

1) Verify that data is transformed correctly according to various business requirements and rules.
2) Make sure that all projected data is loaded into the data warehouse without any data loss and truncation.
3) Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data.
4) Make sure that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability.

Apart from these 4 main ETL testing methods other testing methods like integration testing and user acceptance testing is also carried out to make sure everything is smooth and reliable.

ETL Testing Process:

Similar to any other testing that lies under Independent Verification and Validation, ETL also go through the same phase.

  • Business and requirement understanding
  • Validating
  • Test Estimation
  • Test planning based on the inputs from test estimation and business requirement
  • Designing test cases and test scenarios from all the available inputs
  • Once all the test cases are ready and are approved, testing team proceed to perform pre-execution check and test data preparation for testing
  • Lastly execution is performed till exit criteria are met
  • Upon successful completion summary report is prepared and closure process is done.

It is necessary to define test strategy which should be mutually accepted by stakeholders before starting actual testing. A well defined test strategy will make sure that correct approach has been followed meeting the testing aspiration. ETL testing might require writing SQL statements extensively by testing team or may be tailoring the SQL provided by development team. In any case testing team must be aware of the results they are trying to get using those SQL statements.

------------

Difference between Database and Data Warehouse Testing
There is a popular misunderstanding that database testing and data warehouse is similar while the fact is that both hold different direction in testing.

  •  Database testing is done using smaller scale of data normally with OLTP (Online transaction processing) type of databases while data warehouse testing is done with large volume with data involving OLAP (online analytical processing) databases.
  •  In database testing normally data is consistently injected from uniform sources while in data warehouse testing most of the data comes from different kind of data sources which are sequentially inconsistent.
  • We generally perform only CRUD (Create, read, update and delete) operation in database testing while in data warehouse testing we use read-only (Select) operation.
  • Normalized databases are used in DB testing while demoralized DB is used in data warehouse testing.

There are number of universal verifications that have to be carried out for any kind of data warehouse testing. Below is the list of objects that are treated as essential for validation in ETL testing:
- Verify that data transformation from source to destination works as expected
- Verify that expected data is added in target system
- Verify that all DB fields and field data is loaded without any truncation
- Verify data checksum for record count match
- Verify that for rejected data proper error logs are generated with all details
- Verify NULL value fields
- Verify that duplicate data is not loaded
- Verify data integrity

ETL Testing Challenges:

ETL testing is quite different from conventional testing. There are many challenges we faced while performing data warehouse testing. Here is the list of few ETL testing challenges I experienced on my project:
- Incompatible and duplicate data.
- Loss of data during ETL process.
- Unavailability of inclusive test bed.
- Testers have no privileges to execute ETL jobs by their own.
- Volume and complexity of data is very huge.
- Fault in business process and procedures.
- Trouble acquiring and building test data.
- Missing business flow information.

Data is important for businesses to make the critical business decisions. ETL testing plays a significant role validating and ensuring that the business information is exact, consistent and reliable. Also, it minimizes hazard of data loss in production.

Hope these tips will help ensure your ETL process is accurate and the data warehouse build by this is a competitive advantage for your business.

This is a guest post by Vishal Chhaperia who is working in a MNC on a test management role. He is having extensive experience in managing multi technology QA projects, Processes and teams.

Have you worked on ETL testing? Please share your ETL/DW testing tips and challenges below.



The Best Software Testing Training You'll Ever Get!

software testing QA training

145 comments ↓

#1 Nitin Tike on 05.16.12 at 7:15 pm

further simplified —
In simple words it is collection of data from different departments of a company or from different technologies to one warehouse.
Extract from source, transform in a suitable format and then load into destination data warehouse.

thanks for sharing this resource..

#2 kishore on 05.17.12 at 5:05 am

Informative post.
How to get into this profile? As no matter what exp or knowledge one has it requires exp of ETL testing.

#3 Aarthi on 05.17.12 at 5:18 am

Hai frnds, I am new to testing.Did any one know best coaching center for learning ETL testing in chennai.PLZ reply me asap.

#4 Pravin on 05.17.12 at 5:48 am

Very informative post on ETL testing. Specially the section which talks about the difference in DB Testing and DW Testing. Thanks.

#5 Sanjay on 05.17.12 at 6:16 am

Hi Bishal its very useful info shared by you, I was looking for some docs related to ETL testing got them here. I just checked by Anindita di in Lotus notes the link that u shared and goin thru same, would like to learn more about ETL testing.
Thanks
Sanjay

#6 Alok on 05.17.12 at 8:57 am

Its a very good information shared by you .

Thanks for sharing this .

#7 rajani on 05.17.12 at 5:07 pm

Super article.
very helpful

#8 bhavya on 05.18.12 at 12:36 pm

Please let me know any coaching center in bangalore.
I have around 6 months of exp in ETL testing .I want to learn more in this area.

#9 chaitu on 05.20.12 at 3:08 pm

I think to Start with ETL Testing One Need a Very Hands On SQL concepts specially Conversion Funcions as like when you want to change date in different format or Numeric to string etc

#10 Vishal on 05.20.12 at 6:39 pm

@Kishore: There is no prerequisite as such, may not be one need to have knowledge of any ETL tool still fair understanding of SQL concepts are much desirable.

@Aarthi & Bhavya: I believe there is no institute which provides training on ETL testing, still you can check with institutes those are proving training in ETL tools.

@Chaitu: Yes absolutely, one need to be very conversant in SQL as to map the SQL vs actual business transformation rule that applies. Clear Understanding of Conversion Functions are also much required.

#11 Pavan kumar on 05.23.12 at 3:57 pm

Hi

Thanks for sharing such a useful information..
i am very confused about the difference between the database testing and data warehouse testing..now it is clear..Thanks..

Coming to challenges the major thing is to create a test data for the scenarios which we found in planning phase …….

#12 Purna on 05.24.12 at 1:53 pm

Thanks for sharing the more info of DWH TESTING
and could please share the oracle queries in general asked ,
anyway thanks for sharing the info..

Thanks,
Purna,

#13 JD on 06.07.12 at 3:21 am

hello friends,

can someone explain any example , Backend Testing using SQL queries??

Thanks
JD

#14 Kaushik Srinivas on 06.07.12 at 6:15 am

Hi,
S this is a good study on a warehouse testing. I feel it parallel o my approach on testing a warehouse

#15 lakshmi on 06.28.12 at 7:51 am

HI,

I have a good understood with this information.

#16 lakshmi on 06.28.12 at 7:53 am

HI,

This is lakshmi, Please tell me about execution of ETL Testing.

#17 Prakash on 06.28.12 at 9:21 am

Hello Frns,
There is an institute in HYD for ETL testing:

Naresh Technologies

#18 Kiran on 07.04.12 at 8:29 am

this is really informative and appreciate Vijay’s crisp explanation about ETL testing and really liked the way he gave the difference between Database testing & Data Warehouse testing.

#19 Kiran on 07.04.12 at 8:31 am

sorry to provide wrong name of author as Vijay whereas it should be VISHAL in my earlier post

#20 megha on 07.04.12 at 3:53 pm

The problems generally found in ETL testing comprising the graphics transformations is the unavailability of tools or language(symbol) gap. The article however gives a detail of ETL testing.

#21 Vishal on 07.04.12 at 6:26 pm

@ Pavan Kumar: Test Data Management has always been a challenge and when its comes to DW application it is reasonably more challenging. Its very tough to get correct, clean and secure data considering the fact that data is coming from multiple sources.
On contrary there are many good Test Data Management tools which are potentially capable to overcome these problems.
@Purna: Talking about SQL that are asked in any QA interview are mostly from Joins, Referential Integrity concepts, some basic SQL like sorting, grouping and query related to where clause.
@JD: Could you please make your question more precise? Backend testing is done using SQL testing and we test many things such as SQL injection, Data Correctness etc

#22 Mallikarjun Gadagin on 07.05.12 at 4:56 am

Data warehouse — information delivery system of an organization.

Testing of data warehouse the process of making sure data acceptance of end business users(Report generators)

#23 Jagadish on 07.05.12 at 5:45 am

Please reach me on my email if you want to learn ETL testing.

#24 Jagadish on 07.05.12 at 5:46 am

my email is Jagadish_happy18@yahoo.com

#25 Sreenivas Reddy on 07.10.12 at 5:26 pm

Hi , I am working in ETL project since 4 years and having overall 9 years experience. Currently working in one of Top MNC in India and presently working from client place(London) since 2.5 years in banking project. If you have any questions on ETL or any banking domain then you can reach me at sreenivasulu.borra@gmail.com

Best Regards
Sreenivas Reddy

#26 Ravikiran on 07.12.12 at 7:29 am

Hi,

Can You Please explain landing area, staging area and workflows

#27 jjj on 07.12.12 at 3:17 pm

waste

#28 Durga on 07.13.12 at 2:08 pm

Hi All,

I provide online trainings. I cover Database Testing and ETL Testing.

To get good amount of knowledge in both Database Testing and ETL Testing, one should have sufficient knowledge in SQL Queries.

Please do contact me for more information.

Thanks,
Durga.
9848805111

#29 Jagadish on 07.15.12 at 5:42 am

Hi.. very informative and clear.
I am working on ETL testing and i do provide training on ETL testing.. please reach me on jagadish_happy18@yahoo.com if anyone interested.Thanks.

#30 Sanjay on 07.24.12 at 11:05 am

I am currently in manual testing.I want to learn informatica and move to datawarehouse testing. how feasible is it. Will I have any opportunity to move.

#31 Jagadish on 08.01.12 at 9:22 am

As you are currently working in Manual testing, its very easy for u to learn ETL testing and it would be easy for u to work on ETL testing projects. but going to informatica development may not be a good idea. this is just my opinion.

#32 Kumar on 08.03.12 at 4:22 pm

Hi. I have 12 months of experince in manual testing.I know the basics of JAVA and SQL.
Now i got opprtunity in 1.ETL Testing and 2.Automation testing ( SELENIUM ).
Please advice which one to choose for better career growth.

#33 vasu on 08.06.12 at 10:48 am

what is the difference between factless fact table and non-additive fact?

#34 Sivakumar on 08.09.12 at 5:55 pm

Very good information and detailed diff between DB and DW testing. Appriciate your efforts in doing this one and Thanks a lot for sharing such a nice post.

#35 Sirisha on 08.13.12 at 1:12 pm

Can anyone please tell me which is best institute for ETL testing. I’m new to this tool.

#36 Neer on 08.14.12 at 11:22 am

Very informative article

#37 Bala on 08.19.12 at 1:22 pm

i wanna to know the list of data warehouse products (like db2, ibm data stage2…) if u know the latest products for this means pls rply….

#38 priya on 08.31.12 at 7:57 am

i have been offered a part time trainer position in a company for DWH testing.. what is the pay they generally offer per session?

#39 virag on 09.03.12 at 6:59 am

Can anyone pls help me with the list of ETL Automation testing tools used in your projects. open source or commercial both will be fine. Thanks.

#40 sangit 9480321532 on 09.03.12 at 1:56 pm

Hi,
I am looking for a part time software testing job in bangaore or full time testing in chennai with 2 years of experence.
Do let me know ,if you have the same
Email : sangit.kumar93@gmail.com
Mobile no: +91-9480321532.

#41 Ankit on 09.18.12 at 3:10 am

I have 3 year of Experience in Java and Oracle and i want to work in ETL tools. Can anyone help me to know its future prospects and salary.and where i get the good knowledge of ETL tools.
+91-9250110356

#42 Rahul on 09.19.12 at 12:59 pm

Very nice article, and very informative too..Thanks

#43 Steven on 09.20.12 at 1:48 pm

Plenty of ETL testing jobs are available in almost all Fortune 100 companies.

#44 Ravi on 09.30.12 at 10:51 am

Hi,

I am working in ETL Testing. Please do not always go for tools like Informatica, Web Intelligence 11 etc. First and foremost thing that comes into action is “Writing the queries”. In case to know more please do contact :

meet16ravi@gmail.com

#45 Kiran on 10.03.12 at 9:53 am

ITs very good one thanks fopr ur post… :)

#46 nandy on 10.03.12 at 8:07 pm

Thanks for information

keep on sharing

#47 Nesma H on 10.25.12 at 3:02 am

Thank you for sharing your knowledge. You have helped me understanding ETL testing.

#48 Bill on 10.26.12 at 12:37 am

A very good article. Also check out on Youtube the video “What is a data warehouse and how do I test it?”

#49 Souvik on 10.31.12 at 6:28 am

This article is nice one . I just want to know is it in scope of testing if different short of data loading method testing .

as my project experience delta data loading and bulk data loading these two have generate two separate scenarios and corresponding issues mainly data loss and duplicate data and null value .

Does ETL testing has any proper path to solve this case ?

#50 DILIP on 11.01.12 at 7:43 am

Thank you for sharing your knowledge. You have helped me understanding ETL testing.

#51 Wayne Yaddow on 11.04.12 at 11:54 am

I have written a book on the subject of data warehouse testing… available at Amazon and others as well as an ebook. Let me me know of any questions.

#52 Aman Wadhwa(Muktsar) on 11.23.12 at 4:55 am

I’m Working in a software company in Chandigarh as a DotNet Developer. Someone suggested me to change the profession and go for ETL or WareHousing. As i don’t know anything about ETL and WH also.
And i found lots of people here who having knowledge about both terms.So anyone can please guide me.
aman_wadhwa88@yahoo.com

#53 suneel on 11.23.12 at 6:32 am

Thank you Vishal, really its very useful information.

#54 Rudragouda on 11.28.12 at 12:07 pm

Hi All,

At present I am as a manual test engineer in one of the MNC, Bangalore. I want to change my domain from manual to ETL testing, so can anyone suggest me that what are the basic skills required to switch from manual to ETL.
Also are there any centres or institutes that provide training on ETL. Incase there are no such centres how to prepare myself.
Please suggest me.

Thanks in advance.

+91 9008078349

#55 Rudragouda Desai on 11.28.12 at 12:13 pm

My Mail ID:

rsdesaiglb@gmail.com

#56 Rudragouda Desai on 11.28.12 at 12:31 pm

Anyone please suggest on my above post.

#57 etl testing trainer on 12.05.12 at 2:50 pm

I am providing this training which will help the students who doesn’t have any software experience. We will take scenarios and execute them and guide them when they get into job.
I have experience of 12+ years in the industry. I worked as a Test manager, Business Analyst, project manager.
I Worked with the companies like ITC Infotech, Honeywell, Accenture, TCS.
I provide corporate training also.
After this training the student will scale up to 3+ years experience level.
Contact: 9886991978
Syllabus:
DWH/Datawarehouse Concepts.
Manual Testing.(Web Applications Architecture)
Why ETL Testing.(Datawarehouse Architecture)
Difference between manual/automation and ETL Testing/BI testing.
SQL required for ETL Testing – Easy and only required SQL s for interviews.
ETL Transformations.
ETL test case documentation
TOAD.
Quality Center.
ETL Test Life Cycle.
Realtime Scenarios of Interaction between Business Analyst, Developers and Testers.
Test Planning(Useful for people trying for lead Level)
Discussion of Interview Questions.
Resume Preparation.
How to Accept and handle the work after joining the company.

#58 Preeti on 12.06.12 at 6:02 am

Hello Friends ,
IBM openings for ETL Testing & QTP
If anyone willing to join kindly send me ur resume on
preetideshmukh08@gmail.com
Desired Skills & Experience

Total & Relevant 3 to 4 Years of Experience for ETL Testing & QTP ( NO Contractual Employee )

16 Years Education Mandatory ( BE, B.Tech, or 16 Year Education )

Interview & Joining Location for ETL TESTING — Bangalore.

Interview & Joining Location for QTP — Chennai.

Interview Date : 8 Dec 2012

#59 Hemanth on 12.14.12 at 10:56 am

Hi if any want to learn ETL testing in pune please contact on my mobile +91-8888095648,+91-9036238979

#60 Hemanth on 12.14.12 at 10:57 am

Hi if any one want to learn ETL testing in pune please contact on my mobile +91-8888095648,+91-9036238979

#61 Vijay on 12.16.12 at 6:43 am

Hi,

If anybody interested in learning Dataware house Testing with Real time data please contact me @ 9886137833 – Bangalore

#62 Teja on 12.21.12 at 7:23 pm

Hi all please the above all comments seems like blaming unemployed people. i am not understanding why people coming to etl testing side. you should go development side

#63 Siraj on 12.23.12 at 5:45 pm

Hi,

I had seen that many persons wanted to learn ETL Testing. I am not aware about the institute but i can teach each and everything about ETL testing or you can mail me your questions if you stuck somewhere, i will reply to all the answers. This will help me also to gain knowledge. I am having 6 years exp in this technologies and working for No. 1 product based (database) organization.

Thanks
Siraj

#64 Ramgopal on 12.28.12 at 8:42 am

@Siraj:- Thanks for giving some assurance for me to master ETL Testingconcepts.If you don’t mind can I know your email id inorder to contact you?My email id is ramgopalcse2009@gmail.com

Thanks
Ramgopal

#65 Yogesh on 12.28.12 at 9:23 am

this is really useful material..to learn ETL testing

#66 Venu on 01.02.13 at 2:39 pm

Very helpful and accurate information. Thanks for sharing.

#67 Krishna on 01.03.13 at 6:41 am

Hi if any body wanted to learn Practical ETL testing online please contact on my mobile +60-107767499 (Malaysia) .
I have experience of 8+ years in the industry and worked in various domains as ETL test lead.

Regards
Krishna

#68 mani on 01.04.13 at 7:03 pm

Hi i would like to say my self maniteja working as a Etl and Bi testing in wipro pune. if any body want to learn Etl and Bi testing contact me. classes available only weekends(pune) and Online.

#69 sherif on 01.15.13 at 6:19 pm

Could you plz support me to find ETL testing tool to :-

- Verify that expected data is added in target system
- Verify that all DB fields and field data is loaded without any truncation
- Verify data checksum for record count match
- Verify that for rejected data proper error logs are generated with all details
- Verify NULL value fields
- Verify that duplicate data is not loaded
- Verify data integrity

#70 RKD on 01.16.13 at 2:08 pm

Quite informative

#71 SANDEEP on 01.21.13 at 6:48 am

Hi,only by knowing etl testing doesn’t make sense because you need to know atleast one etl tool to understand and to work on etl testing.So make sure to learn etl tool as well.If any body wants to learn etl testing with etl tool through ONLINE we are giving ETL testing training and we give support untill you got the job.

Base on batch schdules we are giving etl testing and etl tool traing on daily basis as well as weekend batches.

We have successfull track record.call @ +91-8237320101

#72 Rakesh on 01.23.13 at 9:30 am

Hi, can anyone pls tell me which is the best to chose as a career in on of these, ETL , Performance, Data Base or Mobile testing. I feel performance testing is the best because it has lot onsite opportunity, well paid and less resources in market. I would like to here from some experienced teters. Pls help me to choose the right career for my life, ur comments n replies are very impt to me, pls guide me properly…. thanks…..

#73 Indu on 02.06.13 at 6:21 am

@ etl testing trainer : I am interested to learn. Can you let me know in which location r u based in?

#74 Vinay on 02.06.13 at 12:43 pm

I am taking training on ETL tool..DW Testing..I ll post the doughts and clarifications ..

#75 Bunny on 02.06.13 at 2:04 pm

Hi,
I Provide Online Training on ETL Testing.
I am working in a MNC in Hyderabad.
ETL TESTING
============================================

what is Testing ?
what is the need for Testing?
Testing Methodologies
Software development life cycle
software Testing life cycle
Types of Testing

Data Ware Housing Concepts:
• What is Data Ware House?
• Difference between OLTP and Data Ware Housing
• Data Extraction
• Data Transformation
• Data Loading

Data Marts
• Dependent Data Mart
• Independent Data Mart

Data ware housing Approaches
Top Down Approach
bottom up Approach

Data Base Design
• Star Schema
• Snow Flake Schema

SCD(slowly changing dimension)
• Type-1 SCD
• Type-2 SCD
• Type-3 SCD

Basic Concepts in SQL
• SQL Concepts(A-Z) – execute the pl/sql procedures,functions….
• Overview of ETL Tool Architecture
• Testing Functionality on Different Transformation Rules

Data Ware House Life Cycle
Different Types of Testing Techniques in ETL
ETL Testing Introduction
• What is use of testing
• What is quality & standards
• Responsibilities of a ETL Tester

Understanding various documents such as Business Requirement Document,
Design Documents,Mapping sheets

• ETL Testing Work Flow Process
• How to Prepare the ETL Test Plan
• How to design the Test cases in ETL Testing.
• How to reporting the Bugs in ETL Testing ?
• ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
• How to detect the bugs through database queries
• ETL Performing Testing & Performing Tuning

ETL Test Cases
etl testing life cycle
day to day process

UNIX

Thanks,
Bunny(bunny.friendly@gmail.com,(HYD-+91-9550580658)

#76 Nisha on 02.07.13 at 8:18 am

eKnowledge Infotech, a Leading providers of ETL Testing Training in Pune, Qlikview Training Institute in Bangalore. People can have benefit of this.

Thanks,
Nimisha

#77 Nancy on 02.15.13 at 10:27 am

Good to read as a beginer.

#78 Meher on 02.21.13 at 7:49 pm

Good Artcile for testers who want to advance their levels in ETL.

#79 Mehdi Poorsorkh on 02.26.13 at 7:45 am

My questions is:

The differences between manual and automated testing, inkl. some examples. Is there practical example of test strategies?.

Thanks

#80 Chris on 02.26.13 at 9:24 pm

If you are using source and target SQL to do your manual testing then you are more then likely using the minus function to aggregate the results. If this is the case then there is a new tool on the market to automate the testing process for you. Google ‘QuerySurge’

Thanks

#81 randy on 03.06.13 at 4:52 am

ok this is a great info thanks or sharing but i need a guide on how to get a job by learning this and the step by step procedure thank u :)

#82 Hari on 03.18.13 at 3:55 am

Hi all,am in production support from 3 years and I am desparate for a move..Know the concepts of manual testing and sql queries…will I be able to get into ETL testing,can anyone guide me.

#83 Divyesh on 03.23.13 at 5:53 pm

Hi

Anyone know, who can teach ETL class in Vadodara(Gujarat).

#84 saikrishna on 03.30.13 at 12:39 pm

Hi,
which is the best institute for trainig etl testing.

#85 Sugadev on 04.14.13 at 2:01 pm

Friends,
Let me know any ETL/DW testing opening in Singapore/Malaysia. Please reach me @ +91-9840219089 (india-mobile).

#86 Prasad on 04.15.13 at 12:46 pm

Good article.

#87 Diwakar Nukala on 04.17.13 at 8:09 am

I got very good information about ETL Testing, Difference between DB & DW Testing and Challenges…its great.

#88 khr on 04.25.13 at 11:36 am

Any good training institutes for learning etl testing in Bangalore.

If any body is looking for group preparation or search then contact me.

#89 khr on 04.25.13 at 11:53 am

Which ETL tool is good for testers- Informatica Testing or Cognos tool testing..

Pls suggest

#90 chandu on 04.27.13 at 6:32 pm

Hi all,

I am working as a manual tester in a MNC.
Which one is better among QTP and ETL testing.
Career wise and job security wis.

Thanks in advance

#91 Swetha on 04.30.13 at 9:34 am

Hi,

Can any one advise me ETL is best or Selenium is best.
Which tool have more openings in Market. Plz advise me ASAP…….

#92 Maaz on 04.30.13 at 12:08 pm

Reply for #91 Chandu

I suggest you to learn QTP as automation
Know SQL to work in ETL Tool

#93 Maaz on 04.30.13 at 12:09 pm

Thanks a lot for the information
I came to know a lot.
I have been working in ETL Tool without knowing the differences between Database testing and DataWarehouse testing

#94 Venkat on 05.03.13 at 6:57 am

Thanks a lot for the info that you had given very useful info for the ETL testers.

#95 khr on 05.20.13 at 12:32 pm

Any good training institutes to learn ETL Testing in hyderabad.pls help.

#96 Srinivas on 05.22.13 at 2:03 pm

Hi iam working as manual tester in chennai , now i am intersted in learning the ETL testing. please help me how to go ahead with ETL testing. Now i am in chennai , trainer in chennai please contact to my mobile number.
Ph:9962850556

#97 Sourabh on 05.23.13 at 12:17 pm

Hi, This is a very nice and Informative post. Currently I am working as a manual tester and testing a BI application. I am pretty much interested to learn DWH testing. Please lemme know if anyone is willing to teach this in Pune (Near Wakad).

My mail ID is – chourasiasourabh@gmail.com

#98 shiva on 05.25.13 at 6:02 pm

Hi, THis is Shiva
how to autoamte datawarehouse testing and etl testing…?

pleasse suggest notes ASAP

#99 Sandeep on 05.25.13 at 6:47 pm

Hi All,
If anybody wants online training /offline training / corporate training on ETL testing,Informatica,Sql with realtime project and job assistance in bangalore,pune and hyderabad pls contact @ 8237320101

Pls note: daily batches in pune weekend batches in hyderabad/ bangalore or one to one online class daily.

#100 Sandeep on 05.25.13 at 6:52 pm

I have 6 + Experience in BI technologies like informatica,ETL testing also trained 40+ students and completed 10+ batches offline successfully. 90% students already placed in top mnc’s.

Contact: 8237320101

Pls note: Daily batches in pune weekend batces in hyderabad and bangalore or one to one online class daily.

#101 venkat on 05.26.13 at 10:37 am

Hi,

This is venkat .can anyone help me for etl testing qestions and answers or else send me at VENKATADDAGATLA.SP@GMAIL.COM

#102 Reddy on 05.27.13 at 6:19 am

If anybody learn ETL testing ,Database Testing,BI Testing in Pune

pls contact +91-9885320101

#103 Shonali on 05.31.13 at 5:45 am

Nice Article.Thanks, Now i got basic idea abt DWH.But i want to knw some ratcial tips also, as in interview, they are asking for hands on experience. Also in SQL what all i need to learn.Please guide

#104 rajesh on 06.04.13 at 8:23 am

hi friends this is rajesh i have knowledge on java and 3 frame works past 8 months i am searching job in banglore
. Someone suggested me to change the profession and go for ETL or WareHousing. As i don’t know anything about ETL and WH also.

compare to java and etl testing which is the best in future salary and secure.please suggested me

thank u

#105 Anmol on 06.06.13 at 6:23 am

Hi,
I do have an excellent opening for Database Test Lead.
Database Testing Test Analyst with minimum 4 year(s) experience at Gurgaon location. Location- Gurgaon , Telephonic Interviews on this saturday i.e 8th June 2013

Job Description:

Experience required 2 to 5 years Domain: Investment Baking (Preferred) Essential Experience: (Must have skills) • 2 to 5 years of experience in a Software organization on testing (Web technologies, Client/ Server, Database). Some experience in development may also be considered. • Expertise in database testing and should be well versed with complex SQL queries. • Good experience of manual/database testing throughout the testing life cycle. • Understand the application and write test scripts/conditions using a tool (e.g. Test Director) and its review. • Experience to carry out Test execution, logging of defects, preparation of daily test logs, updating Requirements Traceability Matrix. • Should be well versed with UNIX commands and knowledge in shell scripting is preferred. • Experience of using tools such as Test Director for test planning and defect management. • Experience in adapting to testing processes and provide inputs for test process improvements. • Experience in the financial services industry would be an added advantage. Desirable : • Experience in the financial services industry would be an added advantage. • Domain Knowledge in investment banking preferred.(Bonds & Equities, Credit, Collaterals , Exotics) etc • Certifications like ISTQB will be an added advantage.

#106 khr on 06.10.13 at 12:58 pm

Any good training centers for etl testing in hyderabad or bangalore . pls let me know

#107 bunny on 06.16.13 at 4:13 pm

Hi,
I Provide Online Training on ETL Testing.
I am working in a MNC in Hyderabad.
ETL TESTING
============================================

what is Testing ?
what is the need for Testing?
Testing Methodologies
Software development life cycle
software Testing life cycle
Types of Testing

Data Ware Housing Concepts:
• What is Data Ware House?
• Difference between OLTP and Data Ware Housing
• Data Extraction
• Data Transformation
• Data Loading

Data Marts
• Dependent Data Mart
• Independent Data Mart

Data ware housing Approaches
Top Down Approach
bottom up Approach

Data Base Design
• Star Schema
• Snow Flake Schema

SCD(slowly changing dimension)
• Type-1 SCD
• Type-2 SCD
• Type-3 SCD

Basic Concepts in SQL
• SQL Concepts(A-Z) – execute the pl/sql procedures,functions….
• Overview of ETL Tool Architecture
• Testing Functionality on Different Transformation Rules

Data Ware House Life Cycle
Different Types of Testing Techniques in ETL
ETL Testing Introduction
• What is use of testing
• What is quality & standards
• Responsibilities of a ETL Tester

Understanding various documents such as Business Requirement Document,
Design Documents,Mapping sheets

• ETL Testing Work Flow Process
• How to Prepare the ETL Test Plan
• How to design the Test cases in ETL Testing.
• How to reporting the Bugs in ETL Testing ?
• ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
• How to detect the bugs through database queries
• ETL Performing Testing & Performing Tuning

ETL Test Cases
etl testing life cycle
day to day process

UNIX

Thanks,
Bunny(bunny.friendly@gmail.com,(HYD-+91-9550580658)

#108 Simhadri on 06.20.13 at 4:01 pm

Want to join in this network..

#109 ksdjakdjks on 07.03.13 at 12:04 pm

no

#110 kishore on 07.07.13 at 9:58 am

Swetha,
ETL is not a tool its a process to test DWH domain. As it explains as Extract, Transform and Load. Extract data from multiple sources like system at various OS, flat files etc.. apply business logic to such extracted data to transform and than load those transformed data into the system for generating reports and analyzing.

Whereas, Selenium is a functional automation tool. That requires to have knowledge of JAVA specially javascript and not and easy tool to master as compared to QTP.

#111 IT EyeOpener on 07.15.13 at 12:44 pm

Development is better than testing in IT. So,for a long time career prospect ,growth and for stable job,development is far better. Development in Java is one having many opportunities.

#112 kranthi on 08.03.13 at 4:58 pm

Looking for an ETL Testing opportunity anywhere in India..I already have worked on ETL Related Projects and I have around 7 years of Experience.

Kindly let me know for any openings

Thanks
Kranthi
9676016000

#113 SANDEEP on 08.14.13 at 6:53 am

Hi All,
I’m working for a Top MNC in PUNE and if any one is interested in learning ETL Testing, BI testing, DB Testing through ClassRoom Training or Online. Please feel free to contact on the below numbers.
I have a good track record on ETL testing training. I will be teaching the real time scenarios and how to play with the tools. Will provide the demo session on weekends.Interested people can call me on +91-8237320101 for online or class room trainings .
Note : Class Room training will be conducted on daily & weekend basis
Drop me a mail if you have any queries : SANDEEPREDDY.MANEM@GMAIL.COM
call me on +91-8237320101
If any one is interested to ETL testingin PUNE please contact me on the above mentioned number

#114 Raghu on 08.14.13 at 8:02 am

Hi,
I am looking for ETL Testing Training in Hyderabad.
mail id:gangiraghu4u@gmail.com

#115 Sarayu on 08.14.13 at 9:47 am

Hi,
I am looking for ETL Testing Training in Hyderabad.
Please let me know the good institutes in hyd…..

#116 Ravali on 09.04.13 at 5:19 pm

Hello Guys,

I heard most of the people looking in to ETL These days..People dont know where they need to grasp knowlege.It is the platform to those who really want to learn What going on in ETL..

#117 Ravali on 09.04.13 at 5:21 pm

I heard most of the people looking in to ETL These days..People dont know where they need to grasp knowlege.It is the platform to those who really want to learn What going on in ETL..furthur details:dwbi.qa@gmail.com

#118 pandu on 09.06.13 at 5:45 am

hay give me the etl projects interview queations with answers

#119 Nilofar on 09.06.13 at 11:11 am

Hello, i want to learn ETL testing. IF any one knows best institute in Bangalore, please let me know.

#120 Sia on 09.09.13 at 6:28 am

Contact through mail if want to know best training providers in Chennai for ETL Testing

#121 gsr on 09.09.13 at 12:44 pm

hai pls give me the etl projects interview questions with answers

#122 rekha on 09.13.13 at 9:11 am

can you plz send me the interview questions and answers for etltesting and database(Teradata)

#123 Akshatha on 09.23.13 at 8:16 pm

Any suggestions on free data validation tools? Data in my case is being dumped from source db to a flat file from which it is loaded to the interim db. From here data is transformed to a xml file readable by the destination system which loads it back in to the db.

#124 Adithi on 10.08.13 at 5:00 am

I want more detailed about etl testing i.e how the process with be going on banking domain using cognos tool

#125 amarnath on 10.27.13 at 4:37 pm

i want best institute for etl testing in bangalore

#126 Soumya BN on 10.28.13 at 5:17 am

Can anyone give solution to the problem as soon as possible

2) Analyze the below business scenario and design an ETL process from source systems all the way to STAR schema.
a. Business users maintain/insert customer master records in source_system1, customer data will them get propogated onto source_system2, source_system3 and source_system4.
b. Vendor/supplier data is maintained/inserted in source_system2 and this information is then propogated onto source_system1, source_system3 and source_system4.
c. Promotion details is maintained on source_system2.
d. Material details is maintained on source_system3 and it is then propogated onto system_system1, source_system2 and source_system4.
e. Sales information is captured on Source system4.

#127 prashant tiwari on 11.01.13 at 9:18 am

I am looking for a training institute to learn ETL testing with some ETL tool in Chennai. Could you any one suggest me any good institute here. I have 2 years exp. in testing and also have good knowledge of SQL

#128 prashant tiwari on 11.01.13 at 9:19 am

my email id is: prashanttiwari2102@gmail.com and contact no is: 8015495931

please reply ASAP

#129 chandra on 11.18.13 at 6:15 am

Iam looking for a ETL testing freshers job any one plz inform to my mail:chandrareddy.marri@gmail.com

#130 chandra on 11.19.13 at 5:44 am

any one can send the ETL testing material and real time etl process we are doind and how to check the data by using queris

#131 chandra on 11.19.13 at 5:46 am

plz send the etl material how to validate data using queris.
chandrareddy.marri@gmail.com plz send asap

#132 Jeeva on 12.09.13 at 7:39 am

Hi,

I am currently working as a manual tester having 3+ years of experience. I want to learn ETL testing with ETL tool. So I am looking for a training institute to learn ETL testing with ETL tool. Could anyone please suggest me any good training institute in chennai?

Please reply me to this Mail Id – mailwithjeeva@gmail.com

Contact Number – 9994179578

#133 Keerthi on 01.13.14 at 4:45 am

Hi All,
I have an experience of ELT tetsing for past 2.5 yrears. Well skilled in Informatica, Oracle and OBIEE testing. Please contact me incase of any help needed @ your work.
Email Id: learnetltesting@gmail.com

#134 Prabhu on 01.18.14 at 6:33 pm

I need to Learn ETL/DWH Testing and Informatica Tool, kindly suggest me any Best Training Centre in Chennai.. ? am expecting Full Time Class Room Training n assistance till the Placement.

#135 Mukul Singh on 01.25.14 at 12:10 pm

Hi,
I am interested to learn ETL and make my carrier in the same. Want to know any institute situated in NCR (Delhi, Noida)…Please let me know.

Mukul Singh
+91-9717933844

#136 Amit Sharma on 01.25.14 at 12:12 pm

Hi,
I am interested to learn ETL and make my carrier in the same. Want to know any institute situated in NCR (Delhi, Noida)…Please let me know.

Amit Sharma
+91-9997891385 / 9891210017

#137 lata on 01.29.14 at 10:44 am

Its really usefull.I am working as manual tester in Health care domain .I want o know where i can get hands of information in SQL comands .

#138 Teja on 01.31.14 at 6:18 pm

Hi This is Teja working as a Testing Team Lead in top most mnc company in pune,
I have 5 + Experience in ETL and BI(Reports) Testing if any one interested to learn course please contact me.
daily and weekends batches available in pune Technologies: Oracle,Unix,Informatica,Testing Concepts and dwh Concepts
Course duration: 45 days
Fee: 6000 (Phone: 8149173089 )
(Email Id: tejaetltester9@gmail.com)

daily mock interviews with real time scenarios…only limited students in each batch..

#139 Prem kumar on 02.01.14 at 4:23 am

Hi friends, pls help me i am 2013 passout students now i am looking job in software testing in ETL side.pls help me. i don’t know anything in ETL testing, anybody having study material pls send the material to in this mail id prem.reh@gmail.com.

#140 Prem kumar on 02.01.14 at 4:28 am

I am from chennai if you know any good course center in near to DLF IT park please let me know to this mail id prem.reh@gmail.com.

#141 Lavneesh Goel on 02.07.14 at 7:09 pm

Hi All

I have been working in DWH project since last one year.
I am working as a QA in the project.
ETL testing is quite challenging but good job to do.
we run various jobs and make sure that data is getting loaded to our DWH properly and if not we investigate the cause. in simple words i love being an ETL tester

#142 prashanth on 02.13.14 at 5:32 pm

Can you send information about
“Role of ETL in Banking domain”
Or
“How does ETL works?”
Urgent
Mail id:prashanth.rock9@gmail.com

#143 Uttam on 02.20.14 at 3:09 am

Hi All,

If anybody wants to go through ETL testing , unix and sql interview questions then follow the below link :

http://techloverforum.blogspot.com/?view=magazine

Thanks!

#144 Uttam on 02.20.14 at 3:12 am

Hi All,

I have been working in DWH project for 6 years. I have gone through so many interviews and taken also..

If anybody wants to go through ETL testing , unix and sql interview questions then follow the below link :

http://techloverforum.blogspot.com/?view=magazine

Hope you will like the posts.

Thanks!

#145 sandeep kumar on 03.19.14 at 6:47 pm

Hi
I am working in a mnc as a etl tester.
Having a good knowledge of etl testing,SQL writing, report testing and test data creation(most critical task) in data warehouse project.
For any help you can reach me out at ksandeep.srm@gmail.com