BMK and Associates
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.
The Job involves developing, testing, deploying database functions and stored procedures. Key databases used are Postgres and MS SQL
- 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
- Day shift
- 1. What are the different types of Joins? ( Explain )
- 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?
- Bachelor’s (Preferred)
To apply for this job please visit www.glassdoor.co.in.