Sunday, September 23, 2018

Personality interview questions

Fit Questions from Goldman Interviews 

A team member isn't contributing. You confront them. They still don't contribute. What next?
Walk me through you CV?
Which was your preferred class at university?
Your professor accidentally sends you confidential information intended for another student. What do you?
You are working on a secret project. Your previous manager asks about it. He says he wants information on the project to help with an important decision. What do you do?
What are your strengths?
What are your weaknesses?
Which of your skills and experiences make you appropriate for this job?
What motivates you in life?
What would make you satisfied?
Why Goldman Sachs?
What makes Goldman Sachs different to its competitors?
Why do you want to work for this division of Goldman Sachs?
Why do you want this job at Goldman Sachs?
How do you know you want this job at Goldman Sachs?
Have you ever had any issues with work/life balance?
What skills do you think are required to do this job?
Can you talk about a mistake you made in the past, and how you overcame it?
Who is the most famous and influential person you would like to meet and why?
Can you talk about a challenge you faced in the past? How did you overcome it?
Can you talk through a time you worked with a co-worker? How did you build that relationship?
Can you tell me a time when you failed to meet a deadline?
What's more important- deadlines, or the quality of work?
Can you tell us about an episode where you were short of time for delivering a large project? How did you overcome that?
Can you give an example of a time you streamlined a process?
Talk to me about your previous jobs.
What are you strengths?
What are your weaknesses?
Which role do you usually play in a team?
What would your team mates say about working with you?
Why would your team mates choose to work with someone else instead of you?
Would you rather be captain of a losing team or the regular member of a winning team?
Why did you choose your college/university? Why did you choose that subject?
Give an example of a time you acted as a leader.
Describe a time when you worked in a team where there were disagreements.
Describe a time you research a subject of interest to you. How did you go about that?
Would you say you're a perfectionist?
What's been the most important experience of your career? Why?
Can you talk us through a time when you had to decline a client's request? How did you approach that?
Your friend is cheating in a test. He's on his last warning. You're the only one who knows he's cheating. What do you do?
Tell me about yourself. You have three minutes.

Sunday, June 17, 2018

Sql Server Performance issue : unexpected inconsistent

We faced an inconsistent performance issue with Sql Server due to which a Sql SSIS Job was taking inconsistent time sometimes 25 minutes sometimes 1hour 35 minutes sometimes 2 hours and everybody was confused why this is happening and there was nothing in the logs or other logging software we were using.

So, then suddenly we got an email from a Database Developer that they have applied an emergency patch on the production server and we monitored the issue for a week and wow to my surprise the problem was actually resolved.

When i went to database developer and asked about it she told that she changed two settings

Cost Threshold for Parallelism from 0 to 30 
                         
                             (Each Query or Stored procedure has complexity so Sql server will try to apply Parallelism in Queries with Complexity more then 30 and not below that.


Degree of parallelism from 0 to 4. 
                       
                            (mind it Sql Server automatically spans as many thread it assumes machine can support and clearly it way more and hence the process taking too much time which it taken by complexity involved in thread switching. the best bet is (for example for 4 core and 8 thread machine is to use only 4 as value which will do throtelling on the number of thread it can use for Parallalism.)

Thursday, May 24, 2018

Mobile First Approach Are you serious

Today I was surprised by a Angular Video I was listening regarding Form.IO. I was surprised to find out that Mobile first approach is old now. The new Approach is API First. And forms are generated at client side on the fly from the same schema which API uses. bit of a surprise. for details Please trying registering to form.io website.

Wireframing the webapplication pages

In my previous experience in Smartline. I got an opportunity to work on Wireframing new webpages for the development team. I found it extreamely difficult to fix a design which the customer or Buissness needed because everytime i think it's final buissness will come back and ask some changes. i was confused how to go about it. Other challange was to identify the Javascript technologies avialabe to provide that UI changes that can be easily slipped into the Asp.net MVC infrastructure which was used by the develpment tool.

Below is one good wireframing tool i found out

https://balsamiq.com/ and nice youtube video for training on this. https://www.youtube.com/watch?v=IrpXjcpCf_k