Job Summary

Must-Have Qualifications

- 5–7 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 area—payments, 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

Key Responsibilities

Solid data-modelling: normalization/denormalization, constraints, keys, and concurrency patterns.

Skill Requirements

Must Have Skill

TSQL

Valuable to Have Skill

Other Requirements

📌 Technical Lead (India)
🏢 HCLTech
📍 India