T-SQL developer @Chennai @ FTF 2nd Round

Location;-Mahendra World City, Chengalpattu,Chennai

Interview:-

1st Round-Virtual

2nd round-FTF

Must-Have Qualifications

• 57 years total experience as a database/T-SQL developer in mission-critical systems.
• Expert-level T-SQL in Microsoft SQL Server (query writing, set-based design, window functions, error handling, transactions).
• Advanced performance tuning: indexing/partitioning, parameter sniffing strategies, statistics management, memory/IO considerations.
• Solid data-modelling: normalization/denormalization, constraints, keys, and concurrency patterns.
• Scripting & Jobs: Windows/Linux scripting for build/deploy/ops automation; job scheduling and monitoring.
• Version control: Git (preferred) or SVN; pull requests and code-review discipline.
• Banking/Insurance exposure: real-world experience with at least one areapayments, cards, core banking, lending, policy/claims, underwriting, risk, or compliance/reporting (e.g., AML/KYC, IFRS/IRDAI reporting).
• Stakeholder skills: crisp communication with business/tech partners; clear documentation