Pensando Systems Interview Experience for Member of techinal staff

The interviewer asked about project-related to OOP from my resume. Thereafter, coding questions were asked.

1. Remove vowels from the string without in-build function.
2. Two linked lists merged at a point. Find that point.
3. Print Level order traversal of a binary tree in a zig-zag manner.
4. Few questions based on networking.

#interview experiences #pensando systems #interview

What is GEEK

Buddha Community

Pensando Systems Interview Experience for Member of techinal staff

The interviewer asked about project-related to OOP from my resume. Thereafter, coding questions were asked.

1. Remove vowels from the string without in-build function.
2. Two linked lists merged at a point. Find that point.
3. Print Level order traversal of a binary tree in a zig-zag manner.
4. Few questions based on networking.

#interview experiences #pensando systems #interview

System Databases in SQL Server

Introduction

In SSMS, we many of may noticed System Databases under the Database Folder. But how many of us knows its purpose?. In this article lets discuss about the System Databases in SQL Server.

System Database

Fig. 1 System Databases

There are five system databases, these databases are created while installing SQL Server.

• Master
• Model
• MSDB
• Tempdb
• Resource

Master

• This database contains all the System level Information in SQL Server. The Information in form of Meta data.
• Because of this master database, we are able to access the SQL Server (On premise SQL Server)

Model

• This database is used as a template for new databases.
• Whenever a new database is created, initially a copy of model database is what created as new database.

MSDB

• This database is where a service called SQL Server Agent stores its data.
• SQL server Agent is in charge of automation, which includes entities such as jobs, schedules, and alerts.

TempDB

• The Tempdb is where SQL Server stores temporary data such as work tables, sort space, row versioning information and etc.
• User can create their own version of temporary tables and those are stored in Tempdb.
• But this database is destroyed and recreated every time when we restart the instance of SQL Server.

Resource

• The resource database is a hidden, read only database that holds the definitions of all system objects.
• When we query system object in a database, they appear to reside in the sys schema of the local database, but in actually their definitions reside in the resource db.

#sql server #master system database #model system database #msdb system database #sql server system databases #ssms #system database #system databases in sql server #tempdb system database

Persistent System Interview experience

It was a 4 round process consisting of a written test, 2 technical and an HR interview.

Round 1 ( Written Test )

First they conducted an MCQ based test of about 50 questions. These questions were of aptitude, reasoning, Basic C language and of engineering subjects such as Computer Network, OS, Computer Architecture, DBMS.

This round requires basic knowledge of your Engineering Subjects. Results of this round were announced after 10 days and after few days of result, their officials visited campus for further rounds.

Round 2 ( Technical Interview Round 1 )

This round was basically a Problem Solving Round (Pen – Paper). They were testing problem solving approach. In my case, interviewer told me to write code and explain it. Some of the problems were:

1. To remove particular Node from a Linked List

2. Calculate number of distinct characters in a given string

They were also asking about Standard Library functions, if you use any of them in your code. In my case, I used map() in second question, so they asked how it will work during program execution.

Round 3 ( Technical Interview Round 2 )

In this Round, they were testing technical knowledge and all questions were from engineering subjects. Some of them were:

1. Deadlock prevention ( Bankers Algorithm ) { Operating System }

2. OSI model { Computer Network }

3. Port numbers { Computer Network }

4. SQL queries { DBMS }

As my whole technical interview (Round 1 + 2 in one go) was taken by one of senior faculty of interviewing team, so, he declared my result of technical round on spot and forwarded my resume for HR round.

Round 4 ( HR Round )

This was the last round of whole selection process and what I noticed that this was just to check your English. They asked general HR questions like,

1. Tell me about yourself

2. Where do you live

3. Whats your father’s profession and about your family

4. Strength and Weakness

5. What if I reject you in this round

This round was just a normal round because they rejected none of us who qualified for HR round. It means their main focus was on your technical knowledge.

And after sometime, they announced the result and I was one of them who got selected. It was the happiest moment.

Hope this will help the future aspirants… All the best…

#interview experiences #marketing #on-campus #persistent systems #interview

Wipro Elite National Talent Hunt Interview Experience 2020

Round 1 : Online Test

As you all know that Wipro conducted the National Talent Hunt exam all over the world.

The questions were mainly asked on Aptitude, Logical and verbal ability, Essay Writing.

In the technical section there were two codes open to all major languages like java, C, C++, python etc.

The coding questions were too easy and I solved both the questions and passed all the test cases

After giving the mail I received the interview Invite for further round.

Round 2: Technical Interview

The interview started by saying that, “Make yourself comfortable, by telling about yourself”.

The interviewer only asked questions based on my resume. The following were the questions asked to me.

What is Infosys Certified Software Programmer?

What was the pattern of that exam?

What was your project during the internship with persistent systems?

How many team members were there in your project?

How was the behavior of the team members?

What is your contribution during the internship period?

In how much time did you learned Ruby on Rails?

What is your final year project and why you choose the same?

What SDLC you will be using for developing the project and Why?

I hope you are relocatable, as we have offices all across India?

And Finally, He said “ I am done with the interview, Do you have any questions?

I asked Him, what is Wipro doing in the field of AI, ML?

He told the same.

At the end, He said, “Any more questions”

I replied No Sir

He then said “You are selected, you can move ahead for you HR interview”

Round 3: HR Interview

Following were the questions asked in the HR Interview

Tell me about Yourself?

What were the questions asked in Technical interview?

Which language you used to solve coding questions in Wipro NLTH exam?

Are you ready to work from anywhere in India?

What was the topic of the essay in the Wipro NLTH exam?

Note: If you know the topic then only answer the question, else say I don’t remember the topic of essay. Because if you try to fluke the topic, the interviewer may catch you and ask more questions on the same. This happened with many students on that day. Students fluked the essay topic, further, the interview asked them to describe what you have written in the essay in short.

And Finally, He said “ I am done with the interview, Do you have any questions?”

I asked him regarding the Wipro Turbo Challenge.

He replied that Wipro is working on it, you will receive the updates regarding the same through mail.

After someday, I received the Letter Of Intent for the post of Project Engineer.

#interview experiences #marketing #wipro #wipro-interview-experience #interview

BEING HONEST an essential UX interview tip

In this article, I share what I think is one of the best tips when it comes to design interviews.

As a junior UX designer, I’ve been asked a few times by my peers: what is the most essential UX interview tip I have?

Well, to this question I have a very simple answer,** just be honest**… well, this might sound like a no brainer, but it seems to me that not many junior designers know about it or want to apply it.

I had the chance to speak with a few designers and I discovered that some tend towards being a little bit insincere when going through interviews for design positions. It’s normal to be intimidated when going through an interview process and you might want to act as if you have more experience than you have to secure the job.

Well, I’m here to suggest that that’s not the right approach. I fact, recruiters know in advance that as a junior designer you won’t have many years worth of experience so instead of being insincere it’s better to show up with an open mindset and being honest.

A mindset of learning and improving is always welcomed and valued in today’s world. Simple answers like “I might not know X because I’ve haven’t had the chance to get at it but I can learn it as I’m an avid Lerner” go a long way with recruiters.

Put yourself on your recruiter’s shoes, would you rather employ someone “that answers to 90% of the requirements’’ but doesn’t show a growth mindset, or would you employ someone “that answers to 70% of the requirements’’ but shows it’s the thirst for learning and improving?

That’s not to say that you’ll show up with no qualifications at all. You still have to have a certain level of expertise. “Don’t be the guy with 30hrs of experience using Sketch and 1hr of prototyping experience calling himself a UX designer”.

Some skills can be rapidly learned with just a little bit of discipline and will so don’t be afraid to answer with a no if you haven’t had experience with certain techniques due to lack of opportunity of doing so, for example. It’s always easier to learn something new than being perceived as untrustworthy because you said you were qualified to do something but you finally weren’t.

keep in mind that being sincere is always the way… not just during job interviews but in life. Anytime you’re being insincere to achieve something, most probably, the lie will end catching you back and having the opposite effect you wanted it to have.

Anyway, I’ll stop with my “life lessons” and I’ll wish you a very successful interview.

Hopefully, this little advice does help you.

#design-interview #job-interview #system-design-interview #job-interview-tips #ux-interview