Monday, September 7, 2009

Trainee System Administrator (0 - 1 year)

Job Description:
Installing and configuring Microsoft Windows Operating Systems
Manage and maintain system security and OS versions

Administer and implement policies and procedures for ensuring system security and integrity Support, maintain, test and troubleshoot hardware and software problems. Plan and perform appropriate procedures, documentation, inventory assessment, and other processes and procedure related to IT.
Maintain technical documentation and information pertaining to supported hardware and software
Maintenance of LAN.
Minimum 6 months relevant experience.
Candidate should be Microsoft Certified System Engineer ( MCSE) or Microsoft Certified Systems Administrator (MCSA)
Good knowledge of Microsoft Windows servers, Active Directory, DNS, IIS, DHCP and other Networking Concepts.
CCNA would be added advantage.
Knowledge of Linux Operating System• Good knowledge of computer hardware and networking.
Strong LAN/WAN Concepts
Good Troubleshooting Skills.
Good Documentation Skills.
Company Name : Net Solutions
Website:http://www.netsolutionsindia.com
Address: Net Solutions
DLF Building Chandigarh IT park
CHANDIGARH,Chandigarh,India 160101
Email Address:
careers@netsolutionsindia.com
call 91-172-4315008 for furthur information

Thursday, September 3, 2009

Dot Net developer required for Nihelent, Pune

Location : Pune
Desired Candidate Profile :

3-4 years experience in C#, .Net 3.5 and SQL Server 2005
Development of Desktop applications and products using win forms with C# .Net 3.5
Development of web services using C# .Net 3.5
Integrating applications with other existing applications
Development of stored procedures and triggers in SQL server 2005
Development smart client and LINQ using inductive UI Guidelines

Must have good communication and interpersonal skills. Should be open to travel onsite.
Must have passport.

Technical Writer required for Fidelity National Information Services, Bangalore

Location : Bangalore
Desired Candidate Profile :

4 - 8 years experience
Excellent command of English and an ability to write and edit in American English
Programming knowledge and computer skills � facility with Linux shells or administration is a better criteria than say C or C++; an ability to create or validate simple examples is very important
Familiarity with Open Office and docbook or equivalent document preparation tools (nice to have)
An appreciation for direct and straightforward approaches to writing and the work environment
Devotion to clarity
Willingness to ask questions and learn
Interest in presenting reasonably technical material to a varied set of audiences
Ability to work with independence but take direction
Familiarity with database terminology might be a plus, but we dont require a strong background

SQL BI Developer required for Collabera, Bangalore

Location: Bangalore
About Company: Collabera is a global IT services company that provides business-centric, end-to-end Information Technology solutions. With over 4000 dedicated professionals we serve global 2000 clients in the Technology, Communications & Media, Financial Services, Manufacturing and Retail industries. One of the key value drivers for Collabera clients is our Collaborative Engagement Model enabled by a global footprint of 22 locations and 7 development centers. Our engagement model leverages a multi tier service delivery model with proven engagement methodologies, SEI CMMI Level 5 processes and global resourcing to accelerate client return on investment.

Desired Candidate Profile :
Candidates having 3+ years of experience on SSRS / SSIS / SSAS.
Good at MDX , Dash Boards creation

Experience in creating Cubes and Dimensions
Experience in Performance Point server and MOSS are Added advantage.
Good Communication skills.

HCL Bangalore Windows Administrator

Location: Bangalore
Company : HCL Technologies
Candidate Profile :
5 to 6 years of experience in Administering Windows Web Servers [IIS]
Should be able to deploy Web Components [Web Services & Web Applications / Pages]

Should have good knowledge of Virtualized Environments [VMware]- Manage Patches, Releases & Product Upgrades
Very Basic Experience on SQL
This position is on cntract for minimum 6 months (extendable to more than year)

Walkin Interview in Chennai at HCL on 5th September 09

Date: 5th September 2009
Time: 9.30 am to 3.00 pm
Venue: HCL Technologies Ltd
Sapna Trade Centre,
109 Poonamalle High Road
Chennai – 600 084
Tel: 044-42207777
Landmark: Near Hotel Dash Prakash at P H road

About Company: HCL is a leading global Technology and IT Enterprise with annual revenues of US$ 4.7 billion. The HCL Enterprise comprises two companies listed in India, HCL Technologies ( www.hcltech.com ) and HCL Infosystems (www.hclinfosystems.in) The 3 decade old enterprise, founded in 1976, is one of India's original IT garage start ups. Its range of offerings span R&D and Technology Services, Enterprise and Applications Consulting, Remote Infrastructure Management, BPO services, IT Hardware, Systems Integration and Distribution of Technology and Telecom products in India. The HCL team comprises 53,000 professionals of diverse nationalities, operating across 18 countries including 360 points of presence in India. HCL has global partnerships with several leading Fortune 1000 firms, including several IT and Technology majors.
Description : HCL Technologies Ltd is conducting a walkin interview in Chennai for people with 3-6 years experience. Selected candidates may work in Chennai, Bangalore or Noida.

Walkin Interview on 5th September 09 at HCL, BANGALORE

Date: 5th Sept 09

Time: 9.30 am t0 3.00 pm

Venue: HCL Technologies Ltd
# 6, A S Chambers, 80 Feet Road
Koramangala 6^th Block,
Bangalore - 600 095 (Near Sony world Signal)
Tel: +91-080-66441000

Description : HCL Technologies Ltd is conducting a walkin interview in Bangalore for people with 3-6 years experience. Selected candidates may work in Chennai, Bangalore or Noida.

Experience: 3-6 years

Location: Bangalore

Qualifications: 3-6 years experience in Informatica, Cognos, Abinitio, Datastage, MSBI

About Company: HCL is a leading global Technology and IT Enterprise with annual revenues of US$ 4.7 billion. The HCL Enterprise comprises two companies listed in India, HCL Technologies ( www.hcltech.com ) and HCL Infosystems (www.hclinfosystems.in) The 3 decade old enterprise, founded in 1976, is one of India's original IT garage start ups. Its range of offerings span R&D and Technology Services, Enterprise and Applications Consulting, Remote Infrastructure Management, BPO services, IT Hardware, Systems Integration and Distribution of Technology and Telecom products in India. The HCL team comprises 53,000 professionals of diverse nationalities, operating across 18 countries including 360 points of presence in India. HCL has global partnerships with several leading Fortune 1000 firms, including several IT and Technology majors.

Tuesday, September 1, 2009

Honeywell Placement Paper

50 Technical questions (branch wise)
30 C questions
20 aptitude questions
For Aptitude Round simple questions from profit&loss, ratio, odd-man series, time-distance, clock...
Technical from OS, DBMS, CN, 8085, unix, DS.. some of the questions are given below.
1) Binary search tree is used in
a) sorting b)searching c)indexing d)all the above

2) Given a tree..write the preorder traversal


3) Given an infix expression..write its postfix

4) First general purpose microprocessor a) 2002 b)4004 c)8080 d)8085

5) What is 8253

6) ____flag is not used in 8085 jump instructions

7) SNMP is used in which layer

8) Banker,s algorithm is used for?

9) Belady,s anomaly is related to___

10) Which of the following is non-preemptive a) FIFO b)SJF c)Round robin d)all the above

11 )A relation in 3NF is in______

12) A question on serializability

13) One SQL query

14) Functional dependency one question

15) The first general purpose microprocessor is ____-bit

16) In a three byte instruction the second byte indicates____
17) Average case analysis for partition exchange sort

18) How the receiver knows to what service the packet to be forwarded?

19) Given a binary sign magnitude no:..write its decimal

20) The order in which data is transferred frm magnetic disk disk->main mem->cache->h/w register

21) In which layer of the network datastructure format change is done

22) Which of the following allow parallel & serial connections a)DHCP b)PPP c)IPX d)all the above

23) Given some IP addresses...identify which one is IPv6?

24) Open addressing and chaining is used in a)sorting b)indexing c)collision-resolution d)none of the above

25) Storage space requirement for diff: sorts in the descending order

26) Which scheduling policy is used in unix?

27) In database which mechanism is suitable for recovery? a)checkpointing b)indexing

28) Which of the following is not correct? a)arrays consume less space b)linked lists are more complex c)linked lists use less space

29)which of the following is not correct? a)main does not have arguments b)main can have command line arguments c)main have variable arguments

30) Which of the following is not correct? a)function can call itself b)function can have no return type c)function cannot have multiple return statements d)function can have arguments

31) When an interrupt is called control is given to.. a)interrupt vector table b)interrupt service routine c)stack

32) Which of the following is not a synchronization tool
a)semaphore b)mutex c)mutual exclusion d)message passing

33) Given a graph write the BFS for it

34) How can u increase ports of a microprocessor? a)8255 b)8259 c)8253 d)8251

35) What is 8259?

36) Which of the following maintains a constant time(best,worst,average)? a)searching b)sorting c)indexing d)none

37) In a database a table is stored not fully..it is an example of a)views b)logical data independence c)abstraction d)all the above

38) The time CPU takes to complete the execution of processes____

39) The minimum length of TCP/IP header and IP datagram header

40) Process spawning in OS is__________

41) The topology that uses a central hub is___

and few C questions i.e. questions from pointers and strings ..2 or 3 qns frm files,enum,extern..

Oracle Placement Paper for E&C(Electronics) technical

1.Range of TIL logic supply or digital supply
a.0-5 V
b.-12-+12 V
c.2-8 V

2.power diodes are basically
a.silicon
b.Ge
c.neon
d.all above

3.LED emits light when
a.forward bias
b.reverse bias

4.Solar cells are
a.photconductive
b.voltaic cell

5.Which transmission is analog
a.PCM
b.PAM
c.FM

6.Which language generates bytecodes
a.C++
b.JAVA
c.VB
d.None

7.Antenna is
a.transformer
b.refelector
c.Ampifier

8.Conductivity in photodiodes due to
a.GaAs
b.PbS
c.CdS

9.Which oscillator produces 1MHz frequency
a.collpits
b.Rcphaseshift
cWeinbridge
d.None

10.Microwave consists of which band
a.UHF and SHF
b.VHF
c.UHF,SHF & EHF
d.VLF,LF,HF

11.Which is fastest switching device
a.FET
b.MOSFET
c.BJT

12.Which kinds of devices are BJT &JFET
a.JFET is unipolar and BJT uniploar
b.JFET is bipolar and BJT uniploar
c.JFET is unipolar and BJT biploar
d.JFET is bipolar and BJT biploar

13.Lograithmic amplifiers are used in
a.ADDer
b.divider
c,.Multiplier
d.all

14.In which stage modulation is done in high power AM transmission
a.Ifstage
b.Buffer
c.Oscilator
d.RF power stage

15.FM discriminator converts modulated signal to
a.PM
b.AM
c.PCM

16.DPCM is used to
a)reduce bandwidth
b.reduce thermal noise

17.I*F P is the power of carrier maxm power transmitted in am modulated wave
a.P
b.2P
c.1.5P

18.FM bandwidth is described by
a.Shennon,s eqn
b.Bessel,s eqn c
.Hartleiz eqn. (Ans-b)

19.Front to back ratio of antenna can be improved by
a.Sacrifuying gain
b.Increasing area
c.Narow bandwidth

20.Quantization error can be reduced by
a.Sampling rate
b.Levels of sampling

21.Quantizaton error occurs in
a.PCM
b.PPM
c.PWM

22.FM is used for
a.LF
b.HF
c.VHF
d.UHF

23.In demodulation of PCM it is first converted to
a.PPM
b.PWM
c.PAM
d.None

24.If the IF mixer tuned to a frequency of 1200 KHz and if IF frequency is 450 Hz.then image frequency is
a.750
b.1659

25.Which of the following refers to FET
a.hfe &hie
b.gm &rp
c.none

26.If the cross section of target is changing RADAR then scans through?

27.Low freq. Response of RC coupled amplifier r can be improved by
a. lowering coupling capacitor
b.grate r biasing
c.reducing load
d.none

28.A dc supply voltage increases with
a. increase in load & decrees in capacitance

29.If shift resisitor is of 4 bit how many stages
a.16
b.8
c.7
d.4

30.Tracking of RADAR is done by
a.duplex scanning
b.duplex switching

Oracle Placement Paper for Freshers(0 - 6 months)

There are two sections
1. Aptitude Test
2.Technical test

1)find the range of x*x -5x+6>0
X=3

2)if 5x*x+14*x+k=0 having two reciprocal roots find the value of k.

3&4)two sentence are given ,in between four sentence are given in change order. (like between 1 & 6 ,abcd four sentence are given 1 a b c d 6)
Find the correct order?

5)if first term of AP is 5 .16th term is 45.find the sum of first 16 terms.

6)x,y and z are odd no. not necessarly in sequence.then y=?
(1)mean of x and z is 114.
(2)mean of y and z is 113.
Ans: 115

7)Ram is 27 year old then mohan.after 7 year ram age is thrice as mohanage .find ram age?

8)if three tapes are filling a tank of capacity of 500lit with speed of30lit/sec,48lit/sec and 36lit/sec. Find after how long time tank willfill?
Ans : 500/114

9)find the root of given eq x-2/(x-1)=1-2/(x-2) if possible.
Ans : x = 0

10)find the point of intersection of \15x+9y=155x+3y=21

11)suppose in a pot 20 cards are there label 1-20 on that. find theprobability of getting two prime.:
8/20 = 2 / 5

12)in an island three persons are there Jam ,Dam and Sam .sam havingpencil,dam having cap and Jam having book .we have find who is authoramong them if.
(1)Sam says ,Jam is author but author wearing cap.
(2)Dam says ,I am author ,but author not having cap.
(3)Sam says, I am author ,but author having note book.Find who is author?
Ans : jam

13)Jo ,Do and So are three person.
(1) So says Jo is football player, I also football player.
(2) Do says Jo is football player, I also football player.
(3) Jo says Do is football player, I also football player.Find the football player player among them.
Ans : jo

14-16)question based analogy . like LION:CUB find the pair in given choice.

17)in a basket 3 mangos,4 apples and 4 bananas are there. Find no of ways we select randomly 3 fruit from basket?

18) if a^x=b^y=c^z and b^2=ac then find x+z/xz=?
Ans : 2/y

19)(loga)^2-(logb)^2 = ?
ans :- logab-loga/b

20)In a 60 liters of mixture of spirit and water is 7 %. in order to make water 19%,how much water should be added?

21-25)A passage will be given and 4 to 5questions will be asked based on this passage.

Technical Round :
1.what is not a c- storage class
Ans.stack


2.if dba creates one user what are the privilages the user will get?

3. which keyword is used to const in java
Ans. final

4.char *array[4]={”some string”}printf(”%d”,&array[4]-(array));Ans.4

5. Which remote object will be in the package?

6.#define sq(a) (a*a)printf (”%d”,sq (3+2));
Ans.11

7.#define max 20printf (”%d”, ++max);

8.printf (”%d”,sizeof (2>3?4?:4:3?4:2));(some thing like this)Ans.syntax error

9. what is important of free().

10.property of constructor in java program.

11.impotance of macro.

12.underfolw condition of stack.(1)empty,2)push,3)pop,4)none)

Monday, August 31, 2009

Call Center Executive (0 - 2 Years )

Experience:0 - 2 Years
Location:Jaipur

Job Description :
International Call Center Executive, BPO, Back Office job with day night shifts.
Graduates with good english and computer knowledge willing to work in shifts are required.
Company Name:VKALP BPO Services
Website:http://www.vkalp.com
Address:

VKALP33-36, Ist Avenue Rd
Lal Bahadur Nagar West
JLN MargJAIPUR,Rajasthan,India 302018
Email Address:jobs@vkalp.com
Contact :141-91-4005922

HR Executive-Telerecruitment

Experience : 0 - 2 Years
Location : Delhi
Job Description :
We are looking for dynamic HR Executives to augment Lead Generation Process for our placement Office based in Shakarpur,VikasMarg- East Delhi.
Candidate Profile :
Fresh Graduates/ MBA's/Grads with prior experience of working in Placement Consultancy.
Genaration of Leads. Fluency in English and excellent communication & Persuasive Skills is a prerequisite for the job.
Company Name : Shaambhavii Global Links (SGL)
Website:
http://sglinks.co.in
Contact Vivek Pratap on 9818803468
Address:
Shaambhavi Global Links
R-54 2nd/3rd Floor Shakarpur VikasMarg
NEW DELHI,Delhi,India 110092
Email Address: jobsatsgl@gmail.com

Technical Support officer for Convergys (0 - 2 Years )

Experience:0 - 2 Years
Location:Pune

Job Description :
Should have knowledge of desktop troubleshooting.
Interface with customers via inbound calls or internet for the purpose of resolving routing problems with products or services.
Principle duties and responsibilities:Greet customers in a courteous, friendly and professional manner using agreed upon procedures.Listen attentively to customer's needs and concerns, demonstrate empathy.Clarify customer's requirements, probe for and confirm understanding of requirements or problem.
Position on contract basis.Comfortable to work 24 by 7.
Company Name:Convergys India Services Pvt Ltd
Website:
http://convergys.com
Call Silvina Silvina Lobo on 9923000637
Please forward your Resumes on ccopune@convergys.com, silvina.s.lobo@convergys.com or Walk in directly at Convergys, RMZ Westend, near Parihar Chowk, DP Road, Aundh, Pune between Mon-Fri at 11a.m. to 8 p.m. You can also contact on 9923000637/644/655

Process Associate for GENPACT (Voice) (0 - 2 Years )

Experience:0 - 2 Years
Location:Jaipur

Job Description
*Solving Customer Queries *Maintain accuracy of information given and documented. *Adhere to standard operating procedures required by the process. *Should be able to work in UK shifts. *Ensuring Better Customer Experience

Candidate Profile
*Excellent Communication skills(English) *Logical reasoning and analytical skills *Ability to work with speed and accuracy *Prioritizing and organizing skills *Team working *Ability to work in UK Shifts(12:30-3:00 am)

Company Name:GENPACT
Website:
http://www.genpact.com
Contact Shubhalakshmi Mishra on 01414092385

Process Advisor (0 - 3 Years )

Experience:0 - 3 Years
Location:Delhi, Delhi/NCR, Faridabad, Ghaziabad, Noida

Candidate Profile :If you’re an excellent communicator who loves challenges, has a flair for Customer Service and meets the criteria below
Excellent Communication Skills
Good analytical skills
Willing to work in a 24/7 Environment
Graduates (Except B.C.A / B.IT / B.Tech/B.E.)
then call the HR Department
Company Name:Barclays Shared Services Pvt. Ltd
Telephone:9899067192,9711099543,9999499288

Technical Support Executives (0 - 5 Years )

Experience:0 - 5 Years
Location:Hyderabad / Secunderabad

Required Candidate Profile :
Basic Knowledge in PC Hardware & Networking
Good communication skills
Willing to work in shifts
Company Name : Websol Solutions
Email Address : bestresumesit@gmail.com

Search Engine Optimizers (SEO) (0 - 5 years)

Experience:0 - 5 Years
Location:Ernakulam / Kochi/ Cochin, Kozhikode / Calicut

Job Description :
WANTED SEARCH ENGINE OPTIMIZERS (SEO) having experience in Site Analysis Site Optimization Keyword Analysis etc and with knowledge of Web Designing with html / Php willing to work as full time job from office of K P O Research Company

Company Name:Websol Solutions
Email Address:bestresumesit@gmail.com

Sunday, August 30, 2009

Telecaller position (0 - 2 years)

Experience : 0 - 2 Years
Location : Chennai

Job Description : Excellent Communication in Tamil/Average in English
6 months- 2 yrs in Insurance sales
Below 30 years
Salary : 8-10 K
Shift:- DayShift ( Office Work )
Company Name : Client of VT Manpower
Website :
http://www.vtmanpower.com/
Executive Name : Malini
Address :
VT Manpower Consultancy Services Private Limited
4E, Mandira Apartments
23A, North Boag Road
T.Nagar
Chennai,Tamil Nadu,INDIA 600017
Telephone : 91-44-64548802-05

WALK-INs FOR Customer Care Reps

Experience:0 - 1 Years
Location:Navi Mumbai
Job Description

Min 6–9 months of Outbound/Inbound Insurance expGood communication Skill is mustGraduates/Under Graduates can apply(Also require Malayalam speaking candidates)Dealing with General Enquiries related to process/products
INTERESTED CANDIDATES CAN WALKIN DIRECTLY FOR INTERVIEWS FROM 29TH AUGUST 09 AT THE BELOW MENTION ADDRESSVCUSTOMER, BUILDING NO2, SECTOR 2, MILLENIUM BUSINESS PARK, MAHAPE, NAVI MUMBAI

Company Name:
VCustomer Services India Pvt. Ltd.
The company is US incorporated Global Services Company, headquartered at Kirkland & specializing in delivery of outsourced, customer care services,transaction processing, Business Process Outsourcing & support through voice,e-mail & web-based applications.
Website : http://www.vcustomer.com

Software Engineer / Infrastructure Engineer (0 - 1 years)

Experience : 0 - 1 Years
Location : Delhi

Job Description :
This is a training-based placement program offered by CMC Ltd. It is a paid certified program for candidates interested in getting trained on cutting edge technologies besides gaining the real-time work experience on the Job. On successful completion of the training program, the trainee will work with CMC Ltdor its Client-Companies. He/She would be awarded the prestigious CMC Certification along with Work Experience Letter . Please contact the below mentioned contact numbers for your Interview date.

Fresher/ 1 year Experinced with 1st / 2nd class from 2007/2008/2009 batches.For walkin interviews kindly refer address/phone nos. below.
CMC is integral part of TCS. CMC Limited is a leading IT solutions company and a subsidiary of Tata Consultancy Services Limited (TCS Ltd ), and is one of the world's leading information technology consulting, services and business process outsourcing organization. We are a part of the Tata group, India's best-known business conglomerate.
Company Name : CMC Limited
Website:http://www.cmcltd.com
Address:

CMC Limited
9th Floor ,Shahpuri Tower
C-58,Community Centre,
Janakpuri
New Delhi,
Delhi,INDIA 110058
Telephone : 1800-22-8890

Customer Care (IBM BPO) Freshers can also apply

Experience : 0 - 2 Years
Location : Bengaluru/Bangalore

Job Description :
Dear Candidate,IBM Daksh (BPO Division) is hiring for Various INTERNATIONAL VOICE PROCESSES.
PLEASE READ THIS ENTIRE MESSAGE.
PROCESS DETAILS:1. This is an international voice process.

2. This is either a customer service or collections based process.
3. Candidates will be required to communicate with customers in the UK, AUSTRALIA OR THE US.
4. Candidates will be required to make outbound calls or receive inbound calls from UK AUSTRALIA OR THE US. Based customers.
5. This is NOT a non voice process.
6. This is NOT a tech support process.
7. Process Name: Gold-Standard, Prydz, Star-Fence
8. We are hiring Customer Care Executives at the entry level ONLY.
9. These positions are only for Bangalore based candidates.
TRAINING DETAILS: Candidates will be given comprehensive pre-process and process training before they are deployed on the production floor.
APPLICABILITY CRITERIA 1. Be / B. Tech do not apply

.2. Mba/ MCA / Pgdbm / Pgdba / do not apply.
3. People looking for Non-Voice / Tech support do not apply.
4. Age Limit: 35 years only.
REQUIREMENTS: 1. Candidates must be willing to work in any.
2. Candidates must have excellent oral skills.

3. Candidates must be either Graduates or Undergraduates.
4. Undergraduates need to have 6 months of work ex (preferably in an INTERNATIONAL BPO).

5. Freshers can apply. (Preferably 2009 Graduates)
6. Freshers must have graduated in the following streams (Ba, B.Com, Bbm, Bba, Bsc, Bca)
We are looking for IMMEDIATE JOINEES ONLY.
SALARY: 1, 60,000 - 2, 30,000
WEEKLY OFFS: 1. Candidates will be given two days off a week (not necessarily Saturday and Sunday)

2. Candidates will be deployed in any shift.
TRANSPORT: Candidates will be given free transport by the IBM transport Service.
INTERVIEW DETAILS: 1. Candidates will be assessed on their communication ability.

2. Therefore there will be only one round of interview.
3. If the candidate can communicate in fluent English he/ she will be issued an offer letter.
INTERVIEW TIMINGS: Monday – Friday 11amWe do not conduct interviews on Saturday and Sunday.
INTERVIEW DATES: 20TH AUG, 2009 – 30TH SEP, 2009
INTERVIEW REQUIREMENTS If you are interested in this profile, please come down for an interview at with the following papers:

1. Two copies of your UPDATED resume.
2. A copy of this e-mail stapled to your resume(s)
3. Original copies of your 10th, 12th and degree marks card, relieving letters if any.
INTERVIEW VENUE: Address:IBM Daksh Business Process Services Pvt. Ltd.

Block Number D4,
1st Floor,Manyata Embassy Business Park,
Rachenahalli,Nagawara Outer Ring Road,
Bangalore - 560 045, India
If you have any doubts please call Kabir MONDAY - FRIDAY 10 AM - 4 PM ONLY.
DO NOT CALL AFTER 4PM.DO NOT CALL ON SATURDAY AND SUNDAY.
Cell: +91-96323-77006.

CSE/Sr.CSE openings at Intelenet-Walk-in interview(0-5 years)


Experience:0 - 5 Years
Location:Chennai
Job Description :Graduate (Fresher) with good communication skills are welcome for positions for UK/US processes for : Data Process (for Banking, Credit Card, Travel & Mortgages processes) Attractive timings for UK processes, Flexible transport facilities Openings at Ascendas( Taramani) Walk-in interview every Mon-Fri 11 am to 6 pm Location : Intelenet Global Services Pvt. Ltd. 5th Floor , Ascendas IT Park, Taramani. Chennai.
Customer Service Executives ( Data) Good communcation and analytical skills, Graduates with Commerce Background.
Company Name:Intelenet Global
Website : http://www.intelenetglobal.com/career_index.html

Telephone:91-044-66786035

Walk-in @ BA Continuum for a Banking Process, Team Member

Experience : 0 - 2 Years
Location:Gurgaon
Job Description : BA Continuum Solutions Pvt. Ltd., a non banking subsidiary of Bank of America is conducting Walkin for a Banking Process, Team Member at its Gurgaon office from
31st Aug’09 till 4th Sep’09 (Monday to Friday) .

In GHR process, associate would be responsible for catalog administration for learning management Systems. This will include support and administration for functions such as course instance creation, setting up web based trainings, opening/closing rosters, reserving instruction rooms, creating course attributes including audience restrictions, enrollments including batch enrollment, wait list management, and add/drop management.
Interested candidates may walk-in with a copy of their resume at the following venue.
Company Name:
BA Continuum Solutions Pvt. Ltd.

VENUE : BA Continuum Solutions Pvt. Ltd
4th Floor, Tower - B, DLF Infinity Tower
DLF City, Phase-II, Gurgaon - 122 002
Walk in Date : 31st Aug’09 till 4th Sep’09 (Monday to Friday)
Time: 11:00am – 4:00pm
Any graduate with 0 to 24 months experience and willing to work in shifts (24/7) and good communication skills.

HR Recruiter (0 - 1 Years )

Experience : 0 - 1 Years
Location : Hyderabad / Secunderabad
Job Description : Handling recruitments both IT & Non-IT across the levels.Sourcing from online job portals.Screening candidates and making them attend interviews.Responsible till they join the company. Candidates with MBA –HR (Females) with good communication skills required.

Company Name : Jeevan Softech Limited
Website : http://www.jeevansoftechltd.com
Executive Name : Padma
Email Address : archana.a@jeevansoftechltd.com
Telephone : 040-40173064

Administrative Assistant

Experience : 1 - 3 Years
Location : Delhi/NCR

Job Description : Performing a variety of administrative tasks that include managing the following day-to day office activities: House KeepingOffice Supplies managementOrganizing Local and International Travel Arrangements Vendor Management. Your higher education/specialized training/certification should be complemented by 1-3 years' relevant experience, where you've developed excellent organizational skills, a working knowledge of word processing software.
Company Name : Fortune 500 MNC - Client of Career Dimensions
Email Address : apply@careerdimensions.net
Telephone: 91-11-23387793

Tele Sales Executive (0 - 5 years)

Experience: 0 - 5 Years
Location: Delhi
Job Description :
1. Calling Customers to Sell different Financial Products.
2. Cross Selling to Existing Customers.
3. Preparing MIS on Daily/Monthlly/Weekly basis
Candidates with good communication skills,
Candidates from Delhi, NOIDA, Faridabad, Ghaziabad can apply
Interested candidates send their resume to atsjobs1@gmail.com
Freshers can also apply.

Company Name : ATS Services
Website:http://www.servicesats.com
Telephone:01141678933( Shivani Nath )
Company Profile : A Leading Domestic BPO
Recruiter wants you to directly approach the venue with your profile details

Content Writer required - (Fresher)

Experience : 0-2 years

Location : Mumbai

Company Name : IOMX

Email Address: iomxmail@gmail.com

Job Description :We are looking for content writers to work on a permanent basis with our team. The candidate will be required to conduct online research, generate content for various portals and write creative content. Should be Mumbai resident, preferably below the age of 25 but not a compulsion.The candidate should have a stronghold on English with good knowledge of computers and Internet. The person should be enthusiastic, willing to work hard.Fresher may apply.

Company Profile :We are a web publishing company based in Mumbai. The company creates content for various online portals and websites. IOMX also deal in Internet Consulting and Web Development Services.

Wednesday, August 26, 2009

Huawei Placement Paper - 2

1. Can you introduce yourself?

2. For E&C Engineers they ask questions related to Fourier Transformations, Signals and Systems,optical,Networks,Communication, Wireless, mobile, analog and digital.Just have good basic knowledge.

3. wat is modulation? types of modulkation?.

4. Wat is PCM(Pulse Code Modulation)?

5. How many pins do u find in 8085 mp?

6. Describe gsm, cdma with one of advantage?

7. Explain your project and the software used for your project?

8. Any questions for me?

9. Are you ready to work till 10 pm if need arises?

Tip: You go for any interview, prepare a suitable question to ask the interviewer.
If this post has helped you Click on the google ads

Huawei C programming Interview questions

Find the Output of the following programs.
1.
void checkA()
{
int a=2;
if(a=3!=3)
printf(" 3 ");
else
printf(" 2 ");
return;
}


2.
main()
{
char P[]={"Hello World"};
printf(" %s \n",p);
main();
}


3.
#define TRUE 0
main()
{
int i=0;
while(TRUE)
{
printf(" %d \n",i);
i++;
}
printf(" %d \n",i);
}


4.
CHAR j;
for(j=0;j<2000;j++);


5.
main()
{
int a[5];
a[0]=0;
a[1]=1;
for(i=2 ; i<4>

6.
INT i,j;
i = j = 0;
i = ( i++ > ++j ) ? i++ : i--;


7.
# define D 10
# define Y D+10
# define D 30
main(int argc, char *arc[])
{
printf(" %d \n",D);
}


If this post has helped you Click on the google ads

HUAWEI PLACEMENT PAPER - 1


HUAWEI PLACEMENT PAPER 2005
Total Question: 140 Time: 120 min (2 hrs)
Section I : 60 [General Aptitude] (from RS Agarwal, GRE, IAS questions, Verbal & Non-Verbal)
Section II : 60 [Teshnical] (Data communication, Data Structure, Automata Theory, etc)

1. Following some pattern, understand the table and find the answer?
Jan 20
April 10
May 5
November 15
July ?
2. Find the missing number: 1 10 3 9 5 8 7 7 9 6 ?
3. If it was two hours later, it would be half an hour as long until midnight as it will be if it were an hour later. What is the time now?
4. In a city, 80% speaks English, 70% speaks Hindi and 10% do not speak both. It was found that 162 people talk both. How many are there in the city?
5. Find the missing number: 0 6 24 X 120
6. Which is not 'leap year': 1900 2000 1952 1980
7. Find the missing number: J, ?, M, ?, M, J, ?, A, S, O, N, ?
8. There are 27 pearls in a bag. One among them is less in weight. You have been given 2 pan weight machine. In how many trials, you will be able to find the defected one? 4 3 11 13
9. Direct distance between A & B is 200. Direct distance between B & C is 200. Direct distance between C & A?10. There are 30 socks in a bag. 30% is in blue color. What is the probability to take two blue socks?
11. In a ground, there are two poles in 7 ft & 12 ft respectively. They are 12 ft apart from each other. What is the distance between the edges of two poles?
12. You need to print an document of the area 216 sq cm. Condition is 3 cm margin is to be left at both top & bottom and 2 cm at the sides. What 'd be the optimized size of your paper?
13. In a party, every man has his dog with him. There are 22 heads and 72 legs all together. How many men & dogs are there?
14. Ram writes a number between 1 to 1000. Raja wants to know the number, knowing Ram can answer only yes & no and always speaks truth. What will be the minimum number of questions Raja finds the answer.a. 999 b.10 c.500 d.none
15. How many ways a section of four letter word can be made in complete alphabet?
16. Find the missing number: 0, 0.577, 1, 1.732, ?a. 0.656 b.2 c.2.743 d.none
17. 17171717171.....(101 digits) is divided by 625. What is the answer?
18. Synonym for ZENITH: ridge trough nadir crecent
19-25 RS Agarwal questions from frequetly asked topics (time & dist., work done, problems on numbers, ratio, mixture, calender).
26. June 30, 2004 is wednesday. What is June 30, 1974?
27. Two different types of tea are mixed, at 6 Kg of type 1 and 4 Kg of type 2. One Kg of type 1 is Rs. 6 and that of type 2 is Rs. 7. The seller get 10% profit, by this action. Find at what price, he 'd have sold the mixture/Kg?
28. There are 10 people in a party. "How many other people, you met?" is the question asked to everyone. First person says 1, Second says 2, Third says 3..........ninth says 9. Now what tenth person 'd have answered?
29. Find the missing number: 24 : 15 :: 63 : ?30. A metal ball weighing 10 gm is droped from 20 meter height tall point. What will be the time to reach ground?

Tuesday, August 25, 2009

Infosys HR Interview questions and Tips

Whenever preparing for an interview for infosys work hard, solve as many puzzles frm shakuntala devi and previous papers coz most of the questions come from previous papers.
Most of the HR questions are asked to figure out your teamwork spirit, your attitude and positive thinking.
They ask you about yourself, your project, whether you are ready to relocate, why should they select u, what is your ideal job, why have you chosen this particular email id, have you tavelled in plane anytime and some personal questions also.But make sure you resemblance in the photo is very much required.
If this post has helped you Click on the google ads

Infosys HR Interview Questions

Why should Infosys take you?
Any extra curricular activities?

Just leave this resume. Tell us something personally about your self.
Any questions for me ?
How did u enjoy ur college life?
What do u think about relocating to Orissa?
In all these days what did you learn related to software?
What do u feel about this trainer job?
With what kind of questions your students have approached you?
A Car travels 15 m/hr from A to B and 10m/hr from B to A find the average speed.
When did u start wearing glasses?
Why no glasses in photo?
Any other field other than software that interests you?
Can u plant 4 trees equidistant from each other in a piece of land ?
You look so different in photo than in person, why?
If this post has helped you Click on the google ads

Monday, August 24, 2009

Core Java Interview Questions -3


Q. What is the difference between the paint() and repaint() methods?
Ans. The paint() method supports painting via a Graphics object. The repaint() method is used to cause paint() tobe invoked by the AWT painting thread.

Q. What is the Collections API?
Ans. The Collections API is a set of classes and interfaces that support operations on collections of objects.

Q. What is the difference between the prefix and postfix forms of the ++ operator?
Ans. The prefix form performs the increment operation and returns the value of the increment operation. The postfix form returns the current value all of the expression and then performs the increment operation on that value.

Q. What is the difference between an Applet and an Application?
Ans. 1. Applets can be embedded in HTML pages and downloaded over the Internet whereas Applications have no special support in HTML for embedding or downloading.
2. Applets can only be executed inside a java compatible container, such as a browser or appletviewer whereas Applications are executed at command line by java.exe orjview.exe.
3. Applets execute under strict security limitations that disallow certain operations(sandbox model security) whereas Applications have no inherent security restrictions.
4. Applets don't have the main() method as in applications. Instead they operate on an entirely different mechanism where they are initialized by init(),started bystart(),stopped by stop() or destroyed by destroy().

Q. Is there any way in java to find of size of an object ?
Ans. There is no particular command to find of size of an object in java (like sizeof() operator of C/C++ ) but you can check Runtime r = Runtime.getRuntime() ;r.freeMemory() ;before and after the creation of the new Object.By subtraction u can get the used memory.

Q. Can u kill thread manually. What is the disadvantage?
Ans. You can stop (kill) a thread by calling the method 'stop()' on the thread object. But it is not preferable to kill a thread, because it may cause system failure when writing to important data structures.

Q. What is casting?
Ans. There are two types of casting, casting between primitive numeric types and casting between objectreferences. Casting between numeric types is used to convert larger values, such asdouble values, tosmaller values, such as byte values. Casting between object references is used to refer toan object by acompatible class, interface, orarray type reference.

Q. Does a class inherit the constructors of its superclass?
Ans. No, A class does not inherit constructors from any of its superclasses.

Q. What is transient variable?
Ans. A transient variable is not stored with its Object; therefore, it is not serialized when the method writeObject( ) is invoked.

Q. Can the abstract class be final?
Ans. No the abstract class cannot be final, coz the main purpose of the creating abstract class is to inherit them and override there methods. If it is made final then the main purpose of the creating the abstract class is violated. i.e we can't inherit those classes.

Q. In How many ways we can request the System for the garbage collection to cleanup the memory?
Ans. There are 2 ways -
1) System.gc();
2) RunTime r = RunTime.getRunTime();r.gc();

Q. What happens when a thread cannot acquire a lock on an object?
Ans. If a thread attempts to execute a synchronized method or synchronized statement and is unable to acquire an object's lock, it enters the waiting state until the lock becomes available

Q. Can a lock be acquired on a class?
Ans. Yes, a lock can be acquired on a class. This lock is acquired on the class's Class object.

Core Java Interview Questions -2


Q. What is static variable?
Ans. A static variable is one that is not removed from memory after creation, even when it goes out of scope. The concept is very similar to that of a global variable, except that while a global variable is accessible from anywhere, a static variable is only accessible within certain parts of the program code.

Q. How will you pass values from HTML page to the Servlet?
Ans. We can pass values from HTMLpage to servlet using "request.getParameter(string);" method, which is a method in the HttpServletRequest interface.

Q. What is the difference between Hashmap and Hashtable?
Ans. HashMap is not Synchronized where as Hashtable is.
HashMap allows null as both key and value, where as Hashtable does not allow null.
HashMap retrieval is not in order (random) while Hashtable provides ordered retrieval.

Q. Can a lock be acquired on a class?
Ans. Yes, a lock can be acquired on a class. This lock is acquired on the class's Class object.

Q. What is the difference between yielding and sleeping?
Ans. When a task invokes its yield() method, it returns to the ready state. When a task invokesits sleep()method, it returns to the waiting state.

Q. What value does readLine() return when it has reached the end of a file?
Ans. The readLine() method returns null when it has reached the end of a file.

Q. How does multithreading take place on a computer with a single CPU?
Ans. The operating system's task scheduler allocates execution time to multiple threads. By quickly switching between executing tasks, it creates the impression that tasks execute sequentially.

Q. What is the differences between script language and programming language?
Ans. Generally scripting languages can be used to validating the client side,it means reducing the burden on the server side and ruducing network traffic in order to facilitating the higher performance for client who will access application.It has some limitations when compared to programming languages.These limitations as follows:1.Scripting languages cannot support File operations.2. It does not support Database connections.3.It is not suited for network environment.

Q. Can we make construtor STATIC?
Ans. A constructor can never be declared as static, because the role of a constructor is to initialize the object variables and static is never involved with the object so constructor cannot be static

Sunday, August 23, 2009

Java Interview Questions with Answers

Q. What is the difference between ArrayList and Vector?
Ans. Vector is Synchronized ie we can change the size of that array But Array list is not synchronized ie once we declare the size of the array we can,t change during run time.


Q. Can an exception be rethrown?
Ans. Yes exception be re thrown by using throw keyword like throw new Exception type("message ");
If this site has helped you please click on the google ads below.

Q. How many different types of JDBC drivers are present? Discuss them.
Ans. Type 1: JDBC-ODBC Bridge plus ODBC Driver: The first type of JDBC driver is the JDBC-ODBC Bridge. It is a driver that provides JDBC access to databases throughODBC drivers. The ODBC driver must be configured on the client for the bridge to work. This driver type is commonly used for prototyping or when there is no JDBC driveravailable for a particular DBMS.
Type 2: Native-API partly-Java Driver: The Native to API driver converts JDBC commands to DBMS-specific native calls. This is much like the restriction of Type 1 drivers.The client must have some binary code loaded on its machine. These drivers do have an advantage over Type 1 drivers because they interface directly with the database.
Type 3: JDBC-Net Pure Java Driver: The JDBC-Net drivers are a three-tier solution. This type of driver translates JDBC calls into a databaseindependent network protocolthat is sent to a middleware server. This server then translates this DBMSindependent protocol into a DBMS-specific protocol, which is sent to a particular database. Theresults are then routed back through the middleware server and sent back to the client. This type of solution makes it possible to implement a pure Java client. It also makesit possible to swap databases without affecting the client.
Type 4: Native-Protocol Pur Java Driver: These are pure Java drivers that communicate directly with the vendor's database. They do this by converting JDBC commandsdirectly into the database engine's native protocol. This driver has no additional translation or middleware layer, which improves performance tremendously.

Q. Name four Container classes?
Ans. Dialog, FileDialog, Panel, Applet.

Q. What is Singleton class?
Ans. Singleton class is a class whose only one object can be created at a time. - To achieve this one method is that we make its constructor private and provide a static method that returns its instance.
When a Singleton class is garbage - collected and then reloaded, a new Singleton instance is created.


Q. What is synchronization and why is it important?
Ans. With respect to multithreading, synchronization is the capability to control the access of multiple threads to shared resources. Without synchronization, it is possible for one thread to modify a shared object while another thread is in the process of using or updating that object's value. This often causes dirty data and leads to significant errors.

Q. Are constructors inherited?Can a subclass call the parent's class constructor?When?
Ans. You cannot inherit a constructor. That is, you cannot create a instance of a subclass using a constructor of one of it's superclasses. One of the main reasons is because youprobably don't want to overide the superclasses constructor, which would be possible if they were inherited. By giving the developer the ability to override a superclassesconstructor you would erode the encapsulation abilities of the language.

Q. What are wrapped classes?
Ans. Wrapped classes are classes that allow primitive types to be accessed as objects.

Q. What is the disadvantage of threads?
Ans. The Main disadvantage of threads is : Threads is operating system dependent.


Q. How to make application thread-safe ?
Ans. Using synchronized keyword you can make thread safe application and you can also use wait(), notify(), notifyall(). All these methods are of Object class.
Q. Why Java is case sensitive?
Ans. Java is multi platform-> Platform Independent Language, so its used widely in very big softwares or games where multiple variables needed. To Differentiate among that huge no of variables,,Java is Case Sensitive.

Q. What is JVM?
Ans. Java Virtual Machine is the one which change the source code in to the code that is executable through the system so that this helps in making the Java Platform independent as this coude is accessible in any of the operating system

General Interview Questions -2

Q. When the hr ask us tell me some thing about you then what should we include in what not plz help me by giving some examples.
Ans. This is a common question asked in the interview.You should be confident when answering this question.Follow this pattern:

1.Name and qualification
2.If you have work experience then tell about you job profile.
3.your intrests related to your subject
4.future plans
5.Family detailsand hobbies.

Q. What motivates a person?
Ans. A person is motivated by his own achievements ,to achieve new milestones in his career the person keeps striving for better and better performance.....this is the case at least with me.
Q. Why we should hire you ?
orWhat makes you suitable for this job?
Ans. Trick to this question is that u mention ur single quality that place u all above other candidates.

for example :in time of distress i tend to become more careful.

Q. What are the soft skills training?
Ans. Soft skills are the personal quality that is to be present in all the human beings. for example attitude, team work, presentation skills, listening skills, etc. These are the skills related to everyone soul and to train to develop that soft skills is that training.
If the posts have helped you pls click on the google ads

Q. What salary you are expecting from company?
Ans. If you are fresher than you dont have to tell any definete amount to interviewer.you have to say as Sir I dont considor the package rght now.i want to expose my technical skills.i am getting such a platform so its more important for me than salary.....if you are experienced you can negotiate about salry......

Q. Can you work under pressure?
Ans. Yes i worked late nights and go home and i worked on sundays also if required.

Q. What do you think about the college you studied?
Ans. Do not say any bad things about the college. Put forward a positive point.
example: sir, no institution is perfect, but yes, my college provided me all that, which is required for the all round development of an individual.

Q. Why did you leave your job at company ?
Ans. Because as i am interested in the field(the company which u r are attending)n there was not much satisfaction in the previous company which i was working and i want to excel in one field without deviating in others.
If this post has helped you please click on the google ads...

Thursday, August 20, 2009

Important Testing Interview Questions


Q. Which is the best way to solve defects - requirements, plan, design, code / testing phase?
Ans. In any phase, the sooner we see a defect, the less is the cost spent on rectifying the defect. It becomes a costlier affair in later stages. The best phase is Requirements phase. When the defect is found in later phases, it costs more for its correction.

Q. Cost of solving a bug from requirements phase to testing phase - increases slowly, decreases, increases steeply or remains constant?
Ans. In any Life Cycle, defects in the later stages increases Cost because the amount of work needed to do, the resources needed to complete the additional task, the time spent on it, meetings and of course amount. let me tell you an example, assume if 3 different critical issues with respect to Design/functionality of the application are found in these 3 different stages lets say 1st critical defect found in design, 2nd and 3rd critical defects found Coding Phase and Testing phase.
So to fix the 1 defect, in design phase it is obvious that by this time not all the documents are finalized or else i can say coding stage is just started, so BA or High level management can fix it with some effort by doing changes according to the need, as they have lots of time for the release of first build, but for the issues found in coding and testing phase, changes has to be done in Requirement documents, Design documents, specifications, Application Design, Code written to develop application etc., by the respective members and also all the related and effected documents with respect to Testing like Test plan, Test objectives, traceability matrix, test cases, raising or closing the bugs that are linked with the defect etc., needed to be change by test team, and more over assume the situation if such kind of defects were found when major release is nearby (in a week's) when build release dates gap is decreasing drastically build after build due to the issues.


Q. What is the purpose of software testing's - Bug removal, System's functionality working, quality or all?
Ans. The main purpose of Software testing, I think is not to remove the bug but to find the bug. Also ensuring the application works correctly as per the requirements and thereby increasing the quality of the product and increasing the confidence in the product.

Q. Define Quality - bug free, Functionality working or both?
Ans. Quality: The degree to which a product performs as advertised without flaws and without unnecessary complications Also for finding bugs and making sure they (bugs)get fixed and stay fixed.


Q. How do we measure the given project is risk based project?
Ans. Risk can be found based on many factors some of the common factors are1. Amount of testing work to be done X time remaining2. No.of. important open bugs3. Areas untested X time remaining (change in requirements/scope of AUT/functionality comes under this category)4. Anticipation of high priority/severity bugs exisiting in system (concluded by tester based on historical data)5.Anticipated regression bugs.

Q. What are upgrade and new versions of project? what is the difference between them?
Ans. A version is a number assigned to a software package having a particular set of functionalities. The authors of the software or application keep on removing previous bugs & adding new features to the applications and the newer application is marked with a newer number called version. If there is a small change the version number is increased by a decimal point. If there is a larger change in the application the version number is incremented by the whole number. Most of the applications have the feature to check if the higher version of that application is available on the internet. If the higher version of application is available on the internet we can uninstall the lower version & install the higher version of the application. At times we need not uninstall the lower version of the application and some patch or driver is available installing which the application acquires the functionality of higher version & the application shows the version number of the higher version application. So a complete version of application is a complete software package which can be installed independently. An upgrade is not a complete software package which can work on its own.

Wednesday, August 19, 2009

Important General Interview Questions asked frequently

Q. Do you know anyone who works for us?
Ans.Be aware of the policy on relatives working for the organization. This can affect your answer even though they asked about friends not relatives. Be careful to mention a friend only if they are well thought of.

Q.What might make you leave this job?
Ans. This is one of those trick questions well but it has a simple answer,firstly u need to avoid the extreme ans like DEATH,PERSONAL ,REASONS,ETC..,but also at the same time not be minimul in your ans that is BETTER JOB OFFERS,etc,but the ans is ,"I would leave this job only if it tries or restricts my creativity and makes my working area restricted to old meathods i.e if i wanna get some new ideas in my job and i have no one to hear them or give me their advice then i wud leave this job".
Q. What is your long-term employment or career objective?
Ans. Job Satisfaction is the only means where in I can put myself in long term career objective. If I am satisfied with the job then there is no question of quiting or changing the career objective. But ofcourse this is always associated with the horizantal and vertical growth in the career.

Q. What do you know about this organization?
Ans. This question is one reason to do some research on the organization before the interview.Find out where they have been and where they are going. What are the current issues and who are the major players.

Q. Do you have any questions for me?
Ans. Always have some questions prepared. Questions prepared where you will be an asset to the organization are good. How soon will I be able to be productive? and What type of projects will I be able to assist on? are examples.


Q. Where do you want to be, in 3-5 years time?
Ans. Although it's certainly difficult to predict things far into the future, I know what direction I want to develop toward. Within five years, I would like to become the very best _____ your company has. In fact, my personal career mission statement is to become a world-class _____ in the _____ industry. I will work toward becoming the expert that others rely upon. And in doing so, I feel I will be fully prepared to take on any greater responsibilities that might be presented in the long term.

Q. Why u have low percentage in ur first year,while good marks in other years?
Ans.Franklly to tell, i was not that much aware about how exams pattern was?& also not having proper time management for study,but next year i changed my realisation & star study seriously...deciding that it will never happen again..


Q. I'm filling out an application. They want to know what are my weaknesses. I don't really know my weaknesses. I know my strengths. Can you give me some examples of weaknesses?
Ans.You tend to analyze yourself and find your weakness but you should also mention how you are trying to overcome it.You can answer something like:I used be quite unorganized and always had last moment tasks but now I have become more disciplined and always use a pocket planner.

Q.If you have to start working at this project tomorrow, what would you do tonight?
Ans.If i have to start working on this project tomorrow ,tonight i'll think about the ideas to give the project a best start and have a good night sleep after that because to start fresh i have to be give it a fresh start.

Q.Why should we hire you?
Ans. Irealize that there are many other college students who have the ability to do this job. I also have that ability. But I also bring an additional quality that makes me the very best person for the job--my attitude for excellence. Not just giving lip service to excellence, but putting every part of myself into achieving it. In _____ and _____ I have consistently reached for becoming the very best I can become by doing the following . . .
Q. why do you want to join our company?
Ans. To seek a fruitful career in the field of I.T and to apply my knowledge in the I.T field I want to serve myself in your esteemed company.
What are your positive and negative qualities
My +ve qualities I believe 3 works

Home work ,Team work and Hard work.
I don't know My -ve qualities If i know, i would have corrected them already.
Q.Tell me about yourself
Ans. You need not tell ur name os it will always be in ur CV or resume mention what educational qualification u have , ur year of study , branch ,how many years of work experience(if any )name of the colleage 4m where you are perusing your degree (if u are attending an off-campus else u need not tell that too)Also do specify your achievements if any (either in educational field or extra-activities field)u need not mention ur strengths & weaknesses but if u really want to speak on just tell your strengths & hobbies don't ever tell ur weaknesses untill asked !!!enough probably if u are confident & expressed all these things confidently u will be placed !!!

Monday, August 17, 2009

Datawarehousing Interview Questions 2


Q.What is Surrgate key?
Ans.Surrogate key is a substitution for the natural primary key.
It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table.Data warehouses typically use a surrogate, (also known as artificial or identity key), key for the dimension tables primary keys. They can use Infa sequence generator, or Oracle sequence, or SQL Server Identity values for the surrogate key.It is useful because the natural primary key (i.e. Customer Number in Customer table) can change and this makes updates more difficult.Some tables have columns such as AIRPORT_NAME or CITY_NAME which are stated as the primary keys (according to the business users) but ,not only can these change, indexing on a numerical value is probably better and you could consider creating a surrogate key called, say, AIRPORT_ID. This would be internal to the system and as far as the client is concerned you may display only the AIRPORT_NAME.
Q.What are the steps to build Data Warehouse?
Ans. The steps to build Datawarehouse are
Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios
Q.What is incremental loading, batch processing, cross reference table, aggregate fact table?
Ans.Incremental loading means loading the ongoing changes in the OLTP.Aggregate table contains the [measure] values ,aggregated /grouped/summed up to some level of hierarchy.
Batch Processing means executing more than one session in single run at the same time. We can execute these session in 2 ways :
linear: exececuting one after another.
parallel: executing more than one session at at time.
Q.What is Hybrid slowly changing dimension?
Ans. Hybrid SCDs are combination of both SCD 1 and SCD 2.It may happen that in a table, some columns are important and we need to track changes for them i.e capture the historical data for them whereas in some columns even if the data changes, we don't care.For such tables we implement Hybrid SCDs, where in some columns are Type 1 and some are Type 2.
Q.What is the main difference between Inmon and Kimball philosophies of data warehousing?
Ans. Both differed in the concept of building teh datawarehosue..According to Kimball ...Kimball views data warehousing as a constituency of data marts. Data marts are focused on delivering business objectives for departments in the organization. And the data warehouse is a conformed dimension of the data marts. Hence a unified view of the enterprise can be obtain from the dimension modeling on a local departmental level.Inmon beliefs in creating a data warehouse on a subject-by-subject area basis. Hence the development of the data warehouse can start with data from the online store. Other subject areas can be added to the data warehouse as their needs arise. Point-of-sale (POS) data can be added later if management decides it is necessary.
Inmon---First Datawarehouse--Later----Datamarts
Kimball--First DataMarts--Combined way ---Datawarehouse.

Data Warehousing Interview Questions and Answers

Q1.What is a CUBE in Data Warehousing concept?
Ans.Cubes are logical representation of multidimensional data.The edge of the cube contains dimension members and the body of the cube contains data values.
Q2.What is the Datatype of Surrgate key?
Ans.Datatype of the surrgate key is either integer or numeric or number.
Q3.What is Data Warehousing Hierarchy?Hierarchies Hierarchies are logical structures that use ordered levels as a means of organizing data. A hierarchy can be used to define data aggregation. For example, in a time dimension, a hierarchy might aggregate data from the month level to the quarter level to the year level. A hierarchy can also be used to define a navigational drill path and to establish a family structure.Within a hierarchy, each level is logically connected to the levels above and below it. Data values at lower levels aggregate into the data values at higher levels. A dimension can be composed of more than one hierarchy. For example, in the product dimension, there might be two hierarchies--one for product categories and one for product suppliers.Dimension hierarchies also group levels from general to granular. Query tools use hierarchies to enable you to drill down into your data to view different levels of granularity. This is one of the key benefits of a data warehouse.When designing hierarchies, you must consider the relationships in business structures. For example, a divisional multilevel sales organization.Hierarchies impose a family structure on dimension values. For a particular level value, a value at the next higher level is its parent, and values at the next lower level are its children. These familial relationships enable analysts to access data quickly.LevelsA level represents a position in a hierarchy. For example, a time dimension might have a hierarchy that represents data at the month, quarter, and year levels. Levels range from general to specific, with the root level as the highest or most general level. The levels in a dimension are organized into one or more hierarchies.Level RelationshipsLevel relationships specify top-to-bottom ordering of levels from most general (the root) to most specific information. They define the parent-child relationship between the levels in a hierarchy.Hierarchies are also essential components in enabling more complex rewrites. For example, the database can aggregate an existing sales revenue on a quarterly base to a yearly aggregation when the dimensional dependencies between quarter and year are known.
Q4.What is Bus Schema?
Ans.BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.
In a BUS schema we would eventually have conformed dimensions and facts defined to be shared across all enterprise data marts. This way all Data Marts can use the conformed dimensions and facts without having them locally. This is the first step towards building an enterprise Data Warehouse from Kimball's perspective. For (e.g) we may have different data marts for Sales, Inventory and Marketing and we need common entities like Customer, Product etc to be seen across these data marts and hence would be ideal to have these as Conformed objects. The challenge here is that some times each line of business may have different definitions for these conformed objects and hence choosing conformed objects have to be designed with some extra care.
Q5.What is fact, dimension and measure?
Ans.Fact is key performance indicator to analyze the business.Dimension is used to analyze the fact.Without dimension there is no meaning for fact.
Fact:It is a measure,EX:Sales,Accounts etc.Dimension:It deals with the details of the data.EX:Geography,Time etc.Measure:I deals with the quantity of the data.
Fact is the Key performance Indicator which handles the Numerical Value,Dimension concerned about the subjective areas of the data,Measure is the quantity we create to process
Q6.What is Dimensional Modelling?
Ans. Fact is the Key performance Indicator which handles the Numerical Value,Dimension concerned about the subjective areas of the data,Measure is the quantity we create to process
Q7.what is the difference between view and materialised view?
Ans. View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized view - stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Pros include quick query results.
Q8.What is the difference between star and snowflake schemas?
Ans. Star schemaA single fact table with N number of DimensionSnowflake schemaAny dimensions with extended dimensions are know as snowflake schema
Star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.It looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.The dimension model is hence called a star schema
SNOWFLAKING is a method of normalizing the dimension tables in a star schema