Sunday, December 20, 2009

Urgent requirement for " LAMP Architect" @ Nokia , Bangalore

Greetings from Prashanth Adecco Consulting , Bangalore .
We have exciting job opportunity with one of our MNC clients Nokia, Bangalore

Job Details:

Exp: 8 - 12 Yrs
Work Location: Bangalore
Role: . LAMP Architect / Lead
Skill: LAMP

Job Summary

Responsibilities:
•8-14 years of industry experience in professional services, technical support or application development on Linux/Unix and Windows platforms.
•Significant programming experience in PHP, Perl, open source or Java (preferable LAMP)
•Significant experience in architecting and designing enterprise scale applications.
•Strong understanding of XML.
•Experience in working on Ajax, JavaScript and CSS.
•Outstanding organization, follow-through and problem solving skills, resourcefulness, and attention to detail.

* Content management or database experience, XML conversion tools a plus
* Linux experience
Knowledge of XQuery/XSLT is a plus.
professional services, or software engineering 2+ years experience with
programming in Java or C#
Hands on experience
implementing, troubleshooting and supporting Internet based applications
Strong understanding of XML and XML-related technologies
such as XSLT Strong Linux and/or Windows administration skills
(e.g. shell scripting, process automation) Strong verbal,
written and interpersonal communication


please send us your updated CV to Prashanth.N@adecco.co.in along with the following details

Full Name:
D.O.B:
Current Company:
Designation:
Total Exp:
Relevant Exp:
Current CTC:
Expected CTC:
Notice Period:
Current Location:


Thanks & Regards,
Prashanth.N
Senior Recruitment Consultant
Adecco Recruitment Solutions

Adecco India
Sai Deep Shrinidhi
No.2, NAL Wind Tunnel Road,
Murugeshpalya, Bangalore - 560017
Tel : 08039897070 Extn:3988
Fax: +91 80 41119020
Email : Prashanth.N@Adecco.co.in
www.adecco.co.in

Wanted PHP, Drupal Tech Leads for MNC in Bangalore

We have an excellent opening for PHOTON INFOTECH - BANGALORE.

Skill - PHP / Drupal
Exp - 6+yrs
CTC - VERY WIDE OPEN
Job Location - BANGALORE
Candidate Location - Any
Mode - Telecon / FTF(TO YOUR CONVENIENCE)

If you are really interested please forward your updated profile at the earliest to the following mail ID - ashok.m@alpconsultants.com.

The following requirement open for PERMANENT and pls find below the Job Description.

Position: Technical LEAD / Architect.

JOB DESCRIPTION:

Please let me know your interest if not Ignore this mail.

Must have:

- Working knowledge in open source App (OS Commerce, Drupal, SugarCRM)
- Good in MySql (Query/Referential Integrity/DB model)
- PHP 4.X and 5.X
- Drupal 5.X, Knowledge in administration and Module development.
- MYSQL 4/5

Nice to Have

Twitter API integration
Multi Cart usage with IScript
Experience in E-Commerce


Contact:

Ashok Kumar. M

Recruitment Practice
Alp Management Consultants Pvt. Ltd.

Java Professionals Wanted In Chennai - 5+ Years Experience

One of Our Leading client is having openings for Java. The details are given below

Experience : 5 to 9yrs
Graduation : Any UG / PG
Work Locations : Chennai

Mandatory:

Expereince in Java with Hibernate AND Spring.
(or)
Experience in Java with oracle webservices

Send me your profile if you are Interested for Contract Positions

If your profile matching any of the above criteria, kindly reply for this email your profile with below given details

Current CTC :
Expected CTC :
Notice Period :
Current Location :
Current Company :
Mail Id :
Alternate Mail Id :
Contact Number :

Contact:
Radha
Ava Solutions Pvt Ltd,
radha@avasolutions.in

Thursday, December 17, 2009

Wanted Network Programmers For HCL in Chennai

Network Programmers

Education: B.Tech/B.E, MCA, MSC, M.Tech


Location: Chennai


Experience: 4-8 Years

  • Excellent Skills in C Programming
  • Indepth Programming experience in Unix / Linux / Vxworks Platform
  • Hands on Experience in Protocol Stack Development / Sustenance (L2/L3, Datacom)
  • Extensive experience in any of the areas like VLAN, ATM, PPP, Ethernet, RIP, Ospf, BGP…

Interview : 19th Dec 09

Venue:

HCL Technologies Ltd,

33/1, Ulsoor Road

Bangalore -42

Land Mark : Adjacent Road to Manipal Center

Pls Forward your Resume to jayakumar.as@hcl.in to get yourself Scheduled for his Tech discussion.

WALK IN INTERVIEW - CIVIL SUPERVISORS

WALK IN INTERVIEW - CIVIL SUPERVISORS

WALK IN INTERVIEW ON 18TH & 19TH DECEMBER 2009 (1030 AM – 3 PM)

CONTACT MS. LATHA – 044 4445 0013 / 12 / 14

OVERALL CO-ORDINATION & EXECUTION OF PROJECTS, TOWER ERECTION, EQUIPMENT INSTALLATION, INSTALLATION OF GSM / MICROWAVE ATENNAE.

COORDINATION WITH SUB CONTRACTORS.

CIVIL ENGINEERS (5 NOS) : DEGREE IN CIVIL ENGINEERING WITH 5+ YEARS EXPERIENCE IN TELECOM PROJECTS.

CIVIL SUPERVISORS (28 NOS) : DIPLOMA IN CIVIL ENGINEERING WITH 3+ YEARS EXPERIENCE IN TELECOM PROJECTS.

STOREKEEPER – ANY DEGREE WITH 3+ YEARS EXP IN TELECOM PROJECTS

FIBER TECHNICIANS :

TE TECHNICIANS (RIGGER + TE INSTALLER)

Wanted Mainframe Developers For L & T INFOTECH

Wanted Mainframe Developers For L & T INFOTECH

Job Description

As a Developer
Analysis,
Design
Development
Problem solving
Should be willing to work on 24/7 production support project also.


Desired Profile:


Good communication skill written and oral
Very good experience in Mainframe technology
Experience viz. Lexcel simulators, VTS, FTD ,Visa and Mastercard simulators
Good experience in COBOL,DB2,JCL,VSAM,CICS,File-Aid,endevor and Quality centre
Exposure to CMMI quality Process and PDLC.

Experience: 2 to 3 Years of Mainframe experience

Education: BE / B.Tech or Any Graduation

Skills: COBOL,DB2,JCL,CICS

Job Location: Chennai

Please walk in to L & T Infotech if your profile is suitable for this requirement.

Date and Time: 19th December 2009 from 9.00 A.M to 3.00 P.M

Venue:

L & T Infotech Park, (Near to MIOT Hospitals )
Mount Poonamallie Road,
Manapakkam – Chennai,89
HR: Amudha Ramachandran & Rajesh Pandian

Interview Process:

  1. Written test for Mainframe (COBOL, DB2, JCL, VSAM, CICS)
  2. Technical Interview for Mainframe
  3. Senior Person Interview
  4. HR Interview

Documents to Bring:

  • Latest Photograph
  • Updated CV
  • 3 Months Pay slips
  • Last revision salary details
Appointment Letter from the current Organization

HCL WALKIN in Bangalore On 19 December 2009

Criteria: 2 to 8 years of experience for the following vacancies at HCL – Chennai / Bangalore.

Position 1

The candidate should have significant level of Experience in Network / Datacom Testing. L2 & L3 protocol testing experience preferable

Position 2

The candidate should have Experience in PERL, preferably from Networking / Telecom domain.

Job Title: Software Engineer / Sr. Software Engineer / Technical Lead / Senior Technical Lead / Technical Manager.

Company’s Expectations:

Aspiring candidates should possess strong technical skills in the areas identified in the criteria above.

Good communication .

Qualification: BE / B Tech / MCA / MSc / M Tech / MS

Job Location:
Chennai / Bangalore.

Walk-In Date:
19 December 2009 | 10.00 AM to 3.00 PM

Venue:

HCL TECHNOLOGIES LTD,
No. 33/1, “THE SENATE”
Ulsoor Road,
Bangalore – 560042
Ph: 080 – 41906000

Kindly come to the venue with hard copy of your resume, pay slips of November 2009 and current pay structure.

TCS Walkin in Pune on 19th Dec 09

TCS Walkin in Pune on 19th Dec 09

TCS Walkin in Pune for multiple skills

TCS is conducting walkin interview in Pune for people with 3-7 years of experience

Skills for which walkin is being conducted

Web Technologies Java/J2EE, EJB, Struts, JDK, JSP and Servlets
Microsoft Technologies (MS) C++ with Windows
Business Intelligence (BI)
ETL Developer
* Experience on Informatica development
BO XI Developer
* Experience in BO XI R2/R3
Ab Initio
* Ab Initio Architect / Designer / Senior Programmer Profile
* Hands-on experience in Design / Architecture

Engineering and Industrial Services (EIS)

Embedded Firmware
* Hands-on experience in Embedded Firmware with knowledge of automotive domain
* Knowledge of Embedded C is mandatory
MATLAB
* MATLAB Simulink and Stateflow modeling, verification and validation
Hardware
* Hands-on experience in Electronics hardware development with experience in any of the following skills : Microprocessor / Microcontrollers, Digital / Analog Electronics, Power Electronics, Motor controls
* Knowledge of Power Electronics Domain is mandatory
* Automotive hardware knowledge will be preferable

Client Server Unix, PL/SQL

Candidates need to meet the following criteria

1. Graduates / Post Graduates in BE / BTech / ME / MTech / MSc / MCA / MCM / MS or * CA / ICWA / MBA or * PGDIT (2 years full time & approved by AICTE)
Special consideration will be given to B.Sc. / BCA / Diploma holders with 3 years of relevant functional / technical experience, subject to minimum reduction in experience, as per current TCS policy.

2. Minumium 50% marks Class X onwards (Minimum 50%)

Candidates need to carry the following documents to the walkin venue

1. A hardcopy of their CV
2. One passport size photograph
3. A photocopy of the last increment letter/offer letter, whichever is latest
4. The last drawn pay-slip

Venue of Walkin:
Tata Consultancy Services Ltd.,
Rajashree Business Park,
Off Tadiwala Road,
Behind Le Meredian,
Pune – 411 001

Time: 10:00 AM to 12:00 PM
Date: 19th December, 2009 (Saturday)

Candidates interviewed by TCS in the last 6 months or candidates having 2 years or more break in their academic or professional career need not apply

Walk in Interview Technical Writers – HCL Technologies Chennai 19th Dec 09.

Walk in Interview Technical Writers – HCL Technologies Chennai 19th Dec 09.

HCL Walkin in Chennai On 19th Dec 09

Walk in Interview Technical Writers – HCL Technologies Chennai 19th Dec 09.

Requirement: Technical Writers

Work Location: Chennai.

Interview Date: 19th Dec 09

Registration Time: 9.00am till 12.00 Noon

Eligibility: B.E / B.Tech, M.E / M.Tech ( IT,CS, ECE, EEE), MCA, M.Sc (Elect, CS, Tele, S/w, IT) or Any PG Degree

Skill Set:

Experience : 2 – 4 Years

* Excellent Verbal & writing Skills
* Hands on Experience in Technical writing / Editing
* Exposure in Tools like Frame maker, Snag it & Photoshop
* Good Analytical & Problem Solving ability
* Ability to learn new technology.
* Networking knowledge / Domain Experience will be a Plus

Interview Venue:

HCL Technologies Ltd

184-188, NSK Salai

Vadapalani

Chennai 600 026

Land Mark : Opp to Kamala Theater

Pls carry:

* 2 copies of your Hardcopy Resume
* Pay slips & Offer letter or Revision Letters
* One Passport size Photograph.

Tuesday, December 8, 2009

How will you export tables as an XML file from MYSQL?

How will you export tables as an XML file from MYSQL?

You can export any result set from MySQL Query Browser by right-clicking within the result set and choosing an option from the Export Resultset sub-menu. You can choose to export the result set in CSV XML HTML Microsoft Excel XLS or PLIST formats.
or you can use the command like
./mysql -ujon test --xml -e 'SELECT * FROM ' > .xml

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already.

CSV tables in Mysql

CSV tables in Mysql

Those are the special tables, data for which is saved into comma-separated values files. They cannot be indexed.

How can we control the max size of a HEAP table?

How can we control the max size of a HEAP table?

MySQL config variable max_heap_table_size.

HEAP tables in MySQL

HEAP tables in MySQL

HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.

advantages of MyISAM over InnoDB

advantages of MyISAM over InnoDB

Much more conservative approach to disk space management - each MyISAM table is stored in a separate file, which could be compressed then with myisamchk if needed. With InnoDB the tables are stored in tablespace, and not much further optimization is possible. All data except for TEXT and BLOB can occupy 8,000 bytes at most. No full text indexing is available for InnoDB. TRhe COUNT(*)s execute slower than in MyISAM due to tablespace complexity.

advantages of InnoDB over MyISAM

advantages of InnoDB over MyISAM

Row-level locking, transactions, foreign key constraints and crash recovery.

difference between MyISAM Static and MyISAM Dynamic.

difference between MyISAM Static and MyISAM Dynamic.

In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.

user security in MySQL

user security in MySQL

There is no user without a password. There is no user without a user name. There is no user whose Host column contains % (which here indicates that the user can log in from anywhere in the network or the Internet). There are as few users as possible (in the ideal case only root) who have unrestricted access.

mysqldump to create a copy of the database

mysqldump to create a copy of the database

mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql

How can we change a password for an existing user via mysqladmin?

How can we change a password for an existing user via mysqladmin?

mysqladmin -u root -p password "newpassword"

array_search() in PHP

array_search() in PHP

When we use array_search() function if it found the particular value than it will return index corresponding to array value.
Example:
$E_name_arr = array(0 => 'Ravi', 1 => 'Suman', 2 => 'Vijesh', 3 => 'jai');
$key = array_search('Suman', $E_name_arr);
// return $key = 1;
$key = array_search('vinod', $Emp_name_array); // return $key = 0;
?>

SAVE an image from a remote web Server to another web server using PHP

SAVE an image from a remote web Server to another web server using PHP.


$f_img = fopen(“http://website /img/image23.jpg”,’rb’);
$new_img = “/tmp/img1.file”;
$f_new = fopen($new_img,’wb’);
while (!feof($f_img)) {
$chunk_rd = fread($f_img,1024);
fwrite($f_new,$chunk_rd);
}
fclose($f_new);
fclose(f_img);
?>

time expire page in PHP.

time expire page in PHP.


header(“Expires: fri, 07 mar 2007 05:00:00 GMT”);
?>

What’s the difference between sort(), assort() and ksort?

What’s the difference between sort(), assort() and ksort?

1. sort()
Sorts an array in alphabetical order based on the value of each element. The index keys will also be renumbered 0 to length - 1. This is used primarily on arrays where the indexes/keys do not matter.
2. asort()
Like the sort() function, this sorts the array in alphabetical order based on the value of each element, however, unlike the sort() function, all indexes are maintained, thus it will not renumber them, but rather keep them. This is particularly useful with associate arrays.
3. ksort()
Sorts an array in alphabetical order by index/key. This is typically used for associate arrays where you want the keys/indexes to be in alphabetical order.

Prevent from hijacking in PHP

Prevent from hijacking in PHP

1. Make register_globals to off to prevent Form Injection with malicious data.

2. Make Error_reporting to E_ALL so that all variables will be intialized before using them.
3. Make practice of using htmlentities(), strip_tags(), utf8_decode() and addslashes() for filtering malicious data in php
4. Make practice of using mysql_escape_string() in mysql.

String Functions in PHP

String Functions in PHP

str_replace: to replace a part of a string with another string
str_ireplace: Case in-sensitive search and replace using array of strings
strlen: To find length of a string in PHP
trim: Removing empty space from both sides of a string
strrev: Reversing a string by using strrev function in PHP
stristr: Searching for a presence of a string inside another string
nl2br: Adding Line breaks inside a string in place of carriage returns
split: Breaking a string to form array using delimiters
substr: Collecting part of a string
substr_count: Counting occurrence of sub string in main string
str_repeat: Repeating a string number of times
strtolower(): function to change alphabets to Lower case
strtoupper(): function to change characters to upper case letters
strcasecmp(): Case insensitive string comparison
strcmp(): Case sensitive string comparison
str_pad(): String pad with specified length
md5(): hash of a string: encryption of a string

Escape Sequences Recognized in Double-Quoted Strings in PHP

How Many Escape Sequences Are Recognized in Double-Quoted Strings in PHP?

There are 12 escape sequences you can use in double-quoted strings:

  1. \ - Represents the back slash character.
  2. " - Represents the double quote character.
  3. $ - Represents the dollar sign.
  4. n - Represents the new line character (ASCII code 10).
  5. r - Represents the carriage return character (ASCII code 13).
  6. t - Represents the tab character (ASCII code 9).
  7. { - Represents the open brace character.
  8. } - Represents the close brace character.
  9. [ - Represents the open bracket character.
  10. ] - Represents the close bracket character.
  11. nnn - Represents a character as an octal value.
  12. xnn - Represents a character as a hex value.

difference between mysql_connect() and mysql_pconnect()?

What is the difference between mysql_connect() and mysql_pconnect()?

mysql_pconnect ? Open a persistent connection to a MySQL server

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a newconnection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'.

mysql_connect ? Open a connection to a MySQL Server

Opens or reuses a connection to a MySQL server.

PHP interview Questions

a. What’s the difference between md5(), crc32() and sha1() crypto on PHP?

The major difference is the length of the hash generated. CRC32 is, evidently, 32 bits, while sha1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions.

b. What’s the difference between htmlentities() and htmlspecialchars()?

htmlspecialchars only takes care of <, >, single quote ‘, double quote " and ampersand. htmlentities translates all occurrences of character sequences that have different meaning in HTML.

c. For printing out strings, there are echo, print and printf. Explain the differences.

echo is the most primitive of them, and just outputs the contents following the construct to the screen. print is also a construct (so parentheses are optional when calling it), but it returns TRUE on successful output and FALSE if it was unable to print out the string. However, you can pass multiple parameters to echo, like:



and it will output the string "Welcome to TechInterviews!" print does not take multiple parameters. It is also generally argued that echo is faster, but usually the speed advantage is negligible, and might not be there for future versions of PHP. printf is a function, not a construct, and allows such advantages as formatted output, but it’s the slowest way to print out data out of echo, print and printf.