Associate Software Engineer (Database Programmer) Fresher Full Time

## This position is based in Bangalore. Remote working is not an option, so please don’t apply if you’re not willing to relocate ##

izmocars (www.izmoltd.com / www.izmocars.com) is a leading Interactive Media and Internet Solutions company with a strong presence in the Automotive industry. With Interactive Media studios in Long Beach, CA & Brussels, Europe, we are the largest producers of automotive content in the world. Our products include Interactive Media Solutions for Automotive, Web Platform, CRM, Online Marketing and Virtual Reality Platform for the Automotive industry.

Job Description & Duties

• Develop & maintain a high performing, secure, scalable database design in MySQL
• Generate and test performance data
• Testing and validating work produced as part of the development process.
• Collaborate closely with all team members to take shared responsibility for the sprint backlog and the team’s success.
• Maintain broader code quality through peer code reviews.
• Assist with live releases in line with the team’s release schedule.
• Approach work from an Agile mindset applying practices and principles wherever possible. Attend and participate in all Sprint events to achieve desired outcomes.
• Participate in the testing process through test review and analysis.
• Should learn new development constructs related to the technology used in the product with an objective to improve the productivity of the self and to improve the robustness of the product.

Mandatory / Primary Skills

Good knowledge of ANSI-SQL.

• Should have knowledge in writing MySQL Stored Procedures
• Should have knowledge in using MySQL Functions (String to Date and Date Format, Control Flow Functions and Casting Functions)
• Should have knowledge in writing User Defined Functions
• Should have knowledge in using JOINS (Inner Join, Left Join, Full Outer Join, Self-Join, Unions, Except, and Intersect)
• Should have knowledge in writing advanced SQL queries (Distinct Values, Top Values, Date Functions, Date Calculations, Aggregate Functions, String Functions, Sort Data, and Rank Data)
• Should have knowledge in writing basic SQL queries with the following:
• Conditional statements
• Multiple conditions
• Comparison Operators
• Logic Values
• Null Values
• Patterns also known as Wildcard characters
• Compare Column Values
• Good written and verbal communication skills in English will be a plus
• Should have the ability to work under very strict supervision.
• Ability to interpret and read technical data.
• Ability to work in a high-pressure environment.
• Good time-management skills.