Overview
Capco is hiring a SQL Server Developer to design, develop and maintain SQL Server database objects, optimise performance, and support data integration and ETL processes for client engagements.
What you'll do
- Design, develop, test and maintain SQL Server database objects, including stored procedures, functions, views, triggers, and complex SQL queries.
- Develop and optimise T-SQL code to support application functionality, data processing, and reporting requirements.
- Design and implement efficient database schemas, tables, indexes, and relationships.
- Troubleshoot and resolve database-related issues, ensuring reliability, performance, and data integrity.
- Conduct code reviews and adhere to established development standards and best practices.
- Analyse and optimise SQL query performance using execution plans, indexing strategies, and SQL Server performance monitoring tools.
- Identify and resolve database performance bottlenecks.
- Support database performance tuning, capacity considerations, and query optimisation activities.
- Apply appropriate database design principles to ensure scalability, maintainability, and efficiency.
- Develop and maintain data integration and ETL processes using SQL Server Integration Services (SSIS) or equivalent technologies.
- Support data extraction, transformation, migration, and loading activities across multiple systems.
- Implement data validation, reconciliation, and quality checks to ensure accuracy and consistency.
- Collaborate with upstream and downstream application teams to support reliable data flows.
- Participate in the full software development lifecycle, from requirements analysis and technical design through development, testing, deployment, and support.
- Work within Agile delivery teams, contributing to sprint planning, daily stand-ups, retrospectives, and technical discussions.
- Develop unit tests and support system integration testing, regression testing, and defect resolution.
- Use source control and deployment tools to manage database code changes across environments.
- Produce clear technical documentation covering database designs, data flows, and implementation decisions.
- Collaborate with client stakeholders to understand business requirements and translate them into technical solutions.
- Communicate technical concepts clearly to both technical and non-technical audiences.
- Provide regular updates on delivery progress, risks, issues, and dependencies.
- Take ownership of assigned deliverables, ensuring they are completed to agreed quality standards and timelines.
- Contribute to continuous improvement initiatives and share technical knowledge with colleagues.
What you'll need
- Hands-on experience in SQL Server development or a closely related database development role.
- Strong proficiency in Microsoft SQL Server and T-SQL.
- Demonstrable experience developing complex stored procedures, functions, views, and SQL queries.
- Good understanding of relational database design, normalisation, indexing, and data modelling.
- Practical experience in SQL query optimisation, execution plan analysis, and performance tuning.
- Experience developing and supporting ETL processes, ideally using SSIS.
- Understanding of database transactions, concurrency, locking, and data integrity.
- Experience with Git, Azure DevOps, or equivalent source control and delivery tools.
- Familiarity with database testing, debugging, troubleshooting, and production support.
- Understanding of Agile software development methodologies.
- Strong analytical and problem-solving capabilities.
- Ability to work independently on defined technical deliverables with appropriate guidance.
- Effective written and verbal communication skills.
- Experience collaborating with cross-functional technology and business teams.
- Ability to manage competing priorities and deliver within agreed timelines.
- Proactive approach to identifying technical risks and recommending improvements.
- Willingness to learn new technologies and adapt to different client environments.
Nice to have
- Experience working within banking, capital markets, insurance, or other financial services environments.
- Exposure to AWS, Java, Spark, Scala.
- Experience with SQL Server Reporting Services (SSRS) or Power BI.
- Familiarity with data warehousing concepts, dimensional modelling, and analytical databases.
- Experience with CI/CD pipelines and automated database deployments.
- Knowledge of Python, PowerShell, or other scripting languages.
- Understanding of data governance, security, access controls, and regulatory considerations in financial services.
- Exposure to cloud migration, database modernisation, or large-scale data transformation programmes.
- Familiarity with high-availability and disaster recovery concepts.
Details
- Location: Bangalore, Pune.
- Experience: 6-12 years.
Read the full description and apply on the company’s own careers page.