Software Engineer
Relevant Work Experience:
2-3 Years Skill Sets Desired Work Experience
? BE / BTech / BSc / MSc or other equivalent degrees with computer science background / knowledge
? Hands-on Experience in the following
o Working on RDBMS / NoSQL Data
o Well versed with DDL/DML/DCL commands in RDBMS
o Well versed in writing optimized SQL queries for retrieving data from large datasets having multiple tables and views.
o Ability to write custom stored procedures
o Good familiarity in writing triggers in databases
? Working knowledge of
o JSON / XML Handling in queries, where applicable
o Optimization of query performance based on query execution plan
o Knowledge of NoSQL queries, especially MongoDB queries is an added advantage
o Creating and maintaining optimal level of indexing
Desired 2-3 years overall experience with 1-2 years exposure in the identified technologies / skillsets
Must have good exposure to writing optimized SQL queries in any popular RDBMS, preferably PostgreSQL.
Should know optimization of queries by monitoring the query execution plan
Familiarity with querying on partitioned tables is preferred
Good exposure to writing optimized stored procedures and creating / maintaining indices is a must.
Should be capable of working independently/ with minimal supervision
Ability to be proactive in creatively solving identified technical challenges in the project
Good debugging and problem-solving capability is a must