CapitalIQ Interview Question for Software Engineer / Developers






Comment hidden because of low score. Click to expand.
1
of 1 vote

Ok, so you've said you're using a database. Can you do it without using a database? In general, what's the advantage / disadvantage to using a database? How does that apply here?

- Gayle L McDowell July 12, 2005 | Flag Reply
Comment hidden because of low score. Click to expand.
1
of 1 vote

If the rolled-up data is what that is required, we wouldn't want to store all the information in a database. We can compute the roll-up data on the fly and just push that information into the database. For example, if we have 5000 companies and the feed for each company has quotes reported every minute. We would have to process something like 5000*8*60 lines. Which can be accomplished using a simple perl script.

- sb July 13, 2005 | Flag Reply
Comment hidden because of low score. Click to expand.
1
of 1 vote

Assuming this is a real scenario:

1. Must validate all inputs, could be done automatically
by use of contraints in the DB. Since this is crtitical
data, I would create a seperate DB just for this step to
make sure the data is AOK before going in. This DB would
only hold a days' worth.
2. Since this is a comma delimted file can do a bulk load
into the DB.

Since there is no mentioned of an aggregation we'll skip
this and just mention it to the interviewer!

- tariq February 12, 2006 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

Please explain me an answer for this...I got a similar questionare too

- Kevin July 12, 2005 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

There's no one, single, correct answer. Brainstorm a bit. What are the different ways you could do this? What are the advantages and disadvantages of each?

- Gayle L McDowell July 12, 2005 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

I believe we cud write a small python application to download the file from the FTP site, format it correctly and dump it into a database.I'd set that up to be run as a scheduled task and make sure the computer was always ON.
Cud u help a bit more on this...any comments on various methds we cud use.

- Kevin July 12, 2005 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

its end of day stock price.. not minute by minute info.. so there are just 5000 rows..

I can just serve them right from a cache built by parsing the files directly. every time new feed is available i will just swap the cache with a new one.

- asim.ghaffar February 15, 2013 | Flag Reply


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More