Thanks

Thanks in advance

Could you send me your ETL book to me on alishareef3@gmail.com
Thanks

mpacia

i am new to etl tetsing.i moved from developmnent.before i work on project,i want complete knowledge of etl testing.can you plz send me the book to my mail id rushtoraghu@gmail.com .it would be great.

First of all, now a days interviewers are thinking that they are einsteins and some are thinking more than him,, and they are pretending as if they know whole lot of things (like data modeling, oracle, pl/sql, scripting, etl architecture, dba activities… lot more).
One of my friends brother is attending interviews and he is asking the questions which were asked in interviews.. to be frank i myself don’t know some of them….;

in most of interviews they are stressing oracle, unix and pl/sql mostly. i too strongly agree that etl developer need knowledge about these and the question is up to how far??
in one of his interview he was asked about will you take back ups in oracle? R u kidding ?? its job of DBA….what will poor etl developer do with it?
In some interviews he was asked about 10 oracle quries… first and they send him away….; i dont know why they didn’t ask single etl/data warehouse questions… by giving big ad “wanted informatica developer” if they want very strong person in oracle, take the people who worked on oracle and train them on informatica…;

one of question was “how do you tune the query” he said he told by using explain plan , and query the plan table to see how table/indexes are accessed and try to alter the where clauses….etc. (i think its more than sufficient , since generally etl developers in very rare cases do this kind of tunnings to queries…..) but interviewers was not satisfied with his answer and want to tune the query with out explain plan…. “R U in nuts??” u asked some thing and i told relevent answer…and now u want another answer for your f***** question.

another question about indexes: its must and shood etl developer needs an understanding about indexes and how they are useful, thats okay… but what about “partitioning in indexes”?? and different types in it?? –Man how can you expect a ordinary etl (3 yrs exp ) know such dept? he is not a oracle developer “remember” he is a informatica developer…

can you write a unix script to do a reverse string?? What??? r u asking man?? he is not a unix shell script writer…..;

like this our extraordinary interviewers are asking questions……. these sick fellows are thinking that etl developer need to be a SUPERMAN or SPIDERMAN to do every thing from requirement gathering to reporting….;
then wat about the others?

also regarding to informatica, ” how to pass workflow logs to db tables”? its okay to put a question like this in interview, but dont expect that every developer who is working in informatica reply to this, because in general these kind of weired things are not done in all projects; if we need some thing like this in project we can go for google..or some other site to know how to workout it,, and it wont take much time for sure….;

Interviewers are looking into the toughest questions which they even dont know until they see the answers in those sites, and firing them in interviews… pretending that they are supermen for that company…(every body know what will be the work once we are into the project) …, its not at all the good practice.

but most of them are unable to tell why some of the developers who pass the toughest questions in interviews are unable to do efficient work in project? ooops where is it going wrong?

dont guage the person on asking the toughest questions (probably he also read the same question and answers where you read)……

the professional interviewers,, will always ask the questions like the architecture of his project, issues he faced, critical/complex mappings, tunning, production issues, cache, unit testing, code migrations, bug fixing.. these kind of relevent questions and try to find out his knowlege in oracle and unix…

by the way,,, people who are reading my reply may felt why this fellow is writing all this f***; just to let you know guys how tough the informatica interviews are and how strong you need to be prepared….; also it may be a good message to the interviews to change there attitude.. and test the candidates thru right questions instead of asking f*** questions.

Interviewers should always keep in mind that ” they are just employees of the organization and they dont own the organization, and the candidate is here to discuss his project/work/experience,… it will be always healthly like that. try to give some respect to the persons who came for interview,its humanity…

ETL is a concept to move , copy or transform data from one system to another for various reasons. Informatica is a tool that implements the concept. There are many other tools like Informatica. E.g. Data Stage, Abinito, etc. You can also implement ETL without tools using PLSQL, Java, Perl…and so on.

—Sandesh
ETLGuru.com

your website helps me alot to gain knowleage on ETL.
please let me know how can i get your ETL book?
please give info about its cost & buying method

Michael

Thanks,
NB

I am learning ETL basics. Kindly send me the soft copy of e-book.

My Email-id is :- satyainf8@gmail.com

Thanks,
Satya

I am learning ETL Basics. I am unable to find this ebook in the internet.KIndly send me the soft copy to my mailid (satyainf8@gmail.com).

Thanks,
satya

Thank you very much

Regards
Indira

I got job recently as informatica developer, Am interested in knowing about your book, because the updated contents in it are very interesting and all are related to real time scenarios, which will definitely help me out for my present project. If you get a chance to read at my message, Could you please kindly give me a chance of go throughing your ETL Book

Thanks & regards
Praneetha
prnthdv@gmail.com

The topics are amazing…can u pls mail me the book

Thanks

Blog/Article on ETL Testing.

i am new to ETL field & want to work as ETL/DW tester. so please send me copy of your book . i know this will be very much helpful to me.

thanks in advance,

santosh thorat
thoratsantosh12@gmail.com

Can you please email me the book you have written or in case you cannot please let me know how I will get that book.

Thanks in advance
Jagadeesh

Thanks&regards
srinivas

I felt that we can automate in macro, stored procedure or sql script.
Please send me if you have any sample script in shell script.

http://xtremthink.blogspot.com/search?updated-max=2011-08-24T11%3A20%3A00-07%3A00&max-results=1

Regards
Norman

Thanks in advance for your help,

Regards
chandu

Can you please forwardme a copy of the ETL book please?

Regards,
Sasi

Thank you

As a QA person it will be good for you to expand your opportunities by learning new things in QA. Data Centric Project testing is not new. Bu only recently it is getting attention. However there are two things that you need to learn before you can become successful in data centric testing.
1. Basic concepts of how to test data
2. Understand the data from POV of busniness
The 2nd part means you not only learn the data warehouse, ETL concepts but also data modeling and business processes. Because this is an emerging area you can soon find yourself in a team leading position.
Sandesh Gawande
http://www.icedq.com