₹11L – ₹24L a year estimatetypical for IT Jobs in India, 970 posts
Posted 10 years ago Last checked 51 min ago
CoreHRx never asks candidates for money. If anyone does, .
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Gurugram, HR, India Department: Other
Job Description
Here's what we're looking for:
Prior experience with a significant consumer-facing website or service
Full-cycle PHP code development experience including debugging and performance analysis
Experience in working with MySQL database and analyzing the efficiency of queries
Worked with real time web applications and event driven architectures like Node.js or jQuery
Experience with NoSQL and distributed database like Cassandra or Redis
Building scalable and performance oriented services with caching techniques and systems like Memcache
Comfortable with search engines like Solr or ElasticSearch
Working understanding of NGINX and Apache web servers
Working knowledge of RESTful paradigms and to build API for our front services and mobile applications
Passion for products, empathy for users, and aspiration to make big impact
Strong database design and query writing skills with a commitment to performance and efficiency
Solid engineering principles and clear understanding of data structures and algorithms
Knowledge of service oriented architecture, microservices, and distributed systems
Assure quality of the solutions being developed within the team
Troubleshoot and debug support issues and code blues autonomously
Maintain technical mastery of the products being developed
Person with a track record of delivering innovative solutions in the field of algorithm development
Apply for this Job
Apply for this Job
Apply with LinkedIn
Company Description
Zomato is an online food discovery platform with presence across 20 countries including UK, Canada, New Zealand, Ireland, Turkey, India, UAE, Portugal, Czech, Slovakia, Poland, South Africa, Qatar and Sri Lanka.
We will launch in Australia (www.zomato.com) in the coming weeks providing detailed information (scanned menus, pictures, map coordinates, user ratings & reviews) for restaurants across the country.
Started in India in 2008, we now globally cater to over 30 Million visitors searching for eating out options on a monthly basis, and provide information for more than 300,000 restaurants. Zomato is funded by InfoEdge and Sequoia Capital, the same investors who funded Apple, Cisco, LinkedIn etc and the ambition for Zomato is to become the Google of food globally.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
