Job Vacancy in Chennai

  • Full Time
  • Chennai
  • 250000 INR / Year

BMK and Associates

Company 

BMK is a technology supplier to several large companies. We support and host several applications that span from consumer websites to back-end business processes. We are currently looking for an experienced SQL Developer to supplement our team.

Position

The Job involves developing, testing, deploying database functions and stored procedures. Key databases used are Postgres and MS SQL

Skills

  • Write Complex SQL Queries to pull data from SQL Server ( PostgreSQL PGSQL is a plus )
  • Develop scripts to create / schedule SQL Jobs
  • Good to have knowledge of at least one Source Code version control systems eg: Git , SVN , VSTS , Hg , Mercurial
  • Experience working with loading data from XML Files / Web Services / RESTful services is a plus.
  • Knowledge of Other ETL tools is a plus.
  • Bachelor’s degree in Computer Science or MIS from four-year college or university

Compensation: $2,500 – $3,500 US Dollar per month

Hiring Organization: BMK and Associates

Post Name: SQL Senior Developer

Job Type: Full-time

Pay: ₹250,000.00 – ₹300,000.00 per month

Schedule:

  • Day shift

Application Question(s):

  • 1. What are the different types of Joins? ( Explain )

Inner Join
Outer Join
Cross Join

  • 2. Here are 3 tables

Table 1 : Employee
With Fields : Id (integer)
Name ( Varchar(30) )
Table 2: Department
With Fields : Id (Integer)
Name ( Varchar(50))

  • Table 3: EmployeeDepartment

With Fields : MappingId (Integer)
EmployeeId (Integer) — > Refers Id of Employee table
DepartmentId (Integer) — > Refers Id of Department table
StartDate ( DateTime )
EndDate ( DateTime)

Question 1: How to get all the employees and all the departments an employee worked for?

Question 2: Get all the Employees and the departments they are currently working for?

Education:

  • Bachelor’s (Preferred)

To apply for this job please visit www.glassdoor.co.in.

Scroll to Top