I am not sure if this is place to post my concern.
I have an interview lined up for a manual testing position that require knowldge on SQL and data migration issues. Could any one pou some light into what kind of questionto expect in genral.
In your interview, I would be honest about never having a situation where you had performed or been a part of a data migration. Getting quick answers here is not the best way to approach your interview. An interviewer will see through your words and recognize that you do not have the experience if they decide to probe you for details.
The best way to approach would be to say something, "I haven't had direct experience with a data migration project but would love the challenge of learning."
If I were interviewing you, I would respect this approach more than you trying to use other peoples' experiences and trying to pass it off as your own personal knowledge.
For SQL Prepare all the Command which come under
Data definition Language & Data Manipulation
Concentrate more on Joins,Indexes,Triggers & Stored Procedures
Also try to google for the Interview questions on SQL you will find plenty of them
Most Favorite Question of them all is to
Find the Second Highest record from the table
sometimes they may even ask you to do it without <,>,!=, Group by etc
Speaking to data migration, the biggest concerns to me are:
Is the migrated usable or not?
What does the migrated data look like relative to new data that finds its way into the system.
The specifics of the data migration itself (is there data that is not being migrated? what kind of conversion activities are taking place as part of the migration?)
I mean even though i am going to be honest, I would just request for soe possible interview question to expect .The company doe snot care about the domain i have worked on. And i never had the chance to creata a tablebut only checked values ina table on moving between environments.
So what is it that i can expect.Any light is good!