₹14L – ₹25L a year estimatetypical for IT Jobs in Pune, 56 posts
Posted 13 years ago Last checked 29 min ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Design, program, test and implement the changes/new development and be responsible for production deployment of the same
Experience
3–4 years
Must-have skills
Microsoft SQL ServerSQLDebugging
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: Pune, , India Department: Information Technology
Job Description
Would be required to support our SQL Server DB Initiatives
Would be the responsible for any technical issues related to data movement between SFDC, Finnone, Datamart and Portal systems
Convert business requirements into a technical document for all enhancements related to interface between SFDC, Datamart and Portal projects
Design, program, test and implement the changes/new development and be responsible for production deployment of the same
Would be required to support day end batch processes and fine tune the same
Qualifications
Minimum qualification required is Graduate with an experience of 3 - 4 years
Should have atleast 4 years of experience in working with SQL Server and have proficient knowledge in the T SQL programming
Knowledge of SQL Server DBA related activities is preferred
Should have proven abilities to analyse, code, test and implement complex code
Should have worked and implemented projects in the Finance Domain
Should have experience in Performance tuning, debugging and version controlling
Additional Information
All your information will be kept confidential according to EEO guidelines.
Company Description
Company Description:
LinkTag is a dynamic firm, where all of us here have a single motivation to succeed and our success is defined by our clients, making that as our ultimate objective. We extend our services to hiring resources on staffing basis- fulltime, contracting and consulting and/or working on fixed price proposals for deployment of teams. These technical and skilled teams are flexible to work from any locations – your clients, or ours. We also help you fulfill your needs at other global locations as well.
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?
