BetterNepal: Hi Friends ,Hope this is helpful. If you..

Posted by: BetterNepal December 23, 2008

Full Time Job -Questions

Login in to Rate this Post: 0

?

10 more flags than likes deactivates post.

Hi Friends ,

Hope this is helpful. If you are applying for full time job. ( Business/Data analyst)

Application Process - ISQ

Initial Screening Questions

	* Required Field
* 1.	This position is based in San Francisco, CA. Regarding this location:
		I live within a reasonable daily commute distance of San Francisco, CA and am willing to commute on a daily basis
		I do not live within a reasonable daily commute distance of San Francisco, CA but I am willing to relocate at my own expense
		I do not live within reasonable daily commute distance of San Francisco, CA and expect StarMine to pay my relocation expenses
		I am already in the process of relocating to the San Francisco Bay Area and could start within a month of today's date

* 2.	The highest level of education I have attained is:
		A high school diploma
		Some college experience without obtaining a BS/BA degree
		An undergraduate or master's degree in business, accounting, engineering, computer or the physical sciences
		An undergraduate or master's degree NOT in business, accounting, engineering, computer or the physical sciences
		A Ph.D. Degree in any topic

* 3.	Over the last three years, I've written reports and/or emails:
		Daily - in a financial business context (customer support, documentation, sales)
		Daily - in a non-financial business context (customer support, documentation, sales)
		In an academic context for at least one business writing class
		In an academic context for at least one creative writing class
		I would be new to writing reports and/or e-mails but look forward to this new opportunity

* 4.	Which is higher, the mean U.S. household income or the median U.S. household income and why:
		The mean because of the high standard deviation of the US household incomes
		The median because of the high standard deviation of the US household incomes
		The mean because the wealthiest households have extremely large incomes
		The median because there are more poor households than wealthy

* 5.	My level of experience with Microsoft Excel is:
		I would be new to Excel but would be interested in learning more
		I have a basic working knowledge of Excel and can create simple reports
		I would consider myself to have an above average knowledge of Excel and am adept at V lookups, H lookups, if/then formulas and statements, and macros
		I would consider myself to have an above average knowledge of Excel and am adept with VBA
		I would consider myself to be a power user in Excel with proficiency in advanced functions and VBA

* 6.	Which financial statement calculates EPS?
		Balance Sheet
		Income Statement
		Statement of Cash Flow
		Shareholders Equity Statement
		I don't know

* 7.	What statement would the Current Ratio be found in?
		Income Statement
		Statement of Stockholder's Equity
		Balance Sheet
		Cash Flow Statement
		I don't know

* 8.	What is a synonym for "earnings"?
		Revenue
		Operating Margins
		Dividends
		Profit
		Sales

* 9.	In choosing a delimiter (field separator) for a text file containing company names, what would be inadvisable to use?
		A comma (,)
		A pipe (\|)
		A tab
		A semi-colon (;)
		I don't know

* 10.	I am most interested in this pursuing this opportunity because:
		I am interested in learning about stocks and finance but have more background in technical areas (e.g. databases & software)
		I am interested in the technical aspects of the job but have more background in finance, business, or accounting
		I have experience in both areas
		The nature of the business does not matter, as long as I get to use my technical or finance skills
		I would be new to the finance and/or technology industry but I look forward to gaining more experience in these areas

* 11.	Regarding mathematics and classes in mathematics:
		I took math only because it was a requirement in my major
		I took mathematics because I enjoyed math classes
		I took mathematics because I knew it would help me in my career; but it's a tool not a love affair
		I have not had any college level classes in mathematics
		I've been out of school for at least 5 years but I still am advancing my skills in mathematics through outside activities or my job

* 12.	If I do not know the answer to a customer's question by phone, and am unsure if my colleagues could help, I would:
		Give the customer my best answer, though it may be wrong. After hanging up, I would find out if it was right. If so, I would not call the customer back. If it was wrong, I would be sure to call them back with the right answer
		Give the customer my best answer, though it may be wrong. After hanging up, I would find out if it was right and call back either way to confirm with the customer
		Inform the customer that someone at the firm knows the answer and that I will get back to them within 10 minutes
		Inform the customer I want to make sure they get the right answer and then ask if I could research the answer and call them back
		Put the customer on hold and look for one of my co-workers to help while the customer waits

* 13.	If an irate customer calls and starts yelling at me, I:
		Immediately escalate the customer to a supervisor who has experience handling such situations
		Calmly ask the customer to call back when they can communicate in a polite manner
		Let the customer vent, then ask questions to try to figure out the root concern
		Ask the customer to calm down so that I can better help them. If they don't calm down, ask if they can write their issues out in an email
		Wait until the customer calms down so that I can better help them. If they don't, escalate to a supervisor right away

* 14.	Sometimes clients ask for requests or favors that are outside the scope of what is possible or reasonable. What is the best answer to give?
		Yes, but I've got to talk to my supervisor
		Sorry, itâ€™s not company policy that we doâ€¦
		I donâ€™t think that will be possible, but hereâ€™s what I can doâ€¦
		I canâ€™t do this, but my colleague should be able to help youâ€¦

* 15.	A sell-side analyst has been scored unfavorably against his/her peers and writes to challenge their score. You have verified that the data is correct and that their score is valid. While you recognize that this should be clear to the analyst by viewing the product, you must respond to their e-mail. Which of the following phrases would be the MOST appropriate to include in your response? Keep in mind that we value direct, active sentences and a respectful tone.
		It appears that your score on this stock is correct. We apologize for any misunderstandings if theyâ€™ve occurred.
		Please note that your scores are correct. This can clearly be seen on the product.
		We have investigated this issue and found your scores to be valid. Please let us know if you have any questions.
		StarMineâ€™s scoring systems are highly tested and accurate, therefore the scores reflected will be correct. Please let us know if you have any questions.
		I investigated this and found your scores are right on this security. Please let us know if you've got any questions.

* 16.	What is the best way to write an equation to average 20 cells, say A1 through A20?
		Mean(A1..A20)
		Sum(A1..A20)/Count(A1..A20)
		Average(A1..A20)
		Sum(A1..A20)/20
		I don't know

* 17.	When writing SQL:
		I prefer to get another person to write SQL for me
		I prefer to use a GUI tool to generate SQL automatically
		I can manually write medium difficulty SQL including joins
		I can manually write complex SQL queries including outer joins and sub-selects
		I have not written SQL statements or queries but look forward to the challenge

* 18.	In SQL, what is a "group by" used for:
		Grouping of data
		Sorting of data
		Aggregate functions
		Finding "natural" groups
		I don't know

* 19.	If you have an "Employee" table with many fields including "LastName" and "Status", how do you get all of the employees with a status of "Active" sorted alphabetically by "LastName":
		Select * from Employee where Status = 'Active' order by LastName
		Select * from Employee where Status is 'Active' order by LastName
		Select * from Employee where Status = 'Active' sort by LastName
		Select * from Employee where Status is 'Active' sort by LastName
		I don't know

* 20.	Following the pattern shown in the number sequence below, what is the missing number? 1 - 8 - 27 - ? - 125 - 216
		36
		45
		46
		64
		99

* 21.	My realistic annual base compensation goal is:
		Up to $50K
		$50K to $60K
		$61K to $70K
		$71K to $85K
		More than $85K

* 22.	My work eligibility status is:
		I have a legal right to work in the United States without restriction or sponsorship
		I am an alien authorized to work in the United States who must transfer an H-1B visa in order to work for a new employer
		I can obtain a TN visa
		I am an alien who will need a new H-1B visa in order to be authorized to work in the United States

* 23.	I referred to outside sources (book, web site, colleague, etc.) the following number of times in order to answer the questions above:
		1 to 2 times
		3 to 4 times
		5 or more times
		I did not refer to any outside sources

* 24.	I confirm that my answers to questions in this on-line submission are complete and accurate and that Thomson Reuters may rely on my answers. Permission is granted to the company to verify all statements in this employment application:
		Yes
		No

Read Full Discussion Thread for this article