Capco

SQL Server Developer

Capco
Apply
1 day ago
Bengaluru, IndiaSenior / Staff+

Responsibilities

  • Design, develop, test, and maintain SQL Server database objects, schemas, indexes, relationships, and complex T-SQL queries.
  • Develop and optimize stored procedures, functions, views, triggers, and database code for application, processing, and reporting needs.
  • Analyze execution plans, monitor SQL Server performance, identify bottlenecks, and perform query and capacity optimization.
  • Develop and support ETL and data-integration processes using SQL Server Integration Services or equivalent technologies.
  • Support data extraction, transformation, migration, loading, validation, reconciliation, and reliable data flows across systems.
  • Participate in the full software development lifecycle, including requirements analysis, technical design, development, testing, deployment, production support, and defect resolution.
  • Use source control and deployment tools, contribute to code reviews and documentation, and follow database development standards.
  • Collaborate with client, application, business, and cross-functional teams to translate requirements into technical solutions.
  • Communicate delivery progress, risks, issues, and dependencies while managing assigned deliverables and contributing to continuous improvement.

Requirements

  • Hands-on experience in SQL Server development or a closely related database development role.
  • Strong proficiency in Microsoft SQL Server and T-SQL, including complex stored procedures, functions, views, and queries.
  • Knowledge of relational database design, normalization, indexing, data modeling, transactions, concurrency, locking, and data integrity.
  • Practical experience with SQL query optimization, execution-plan analysis, performance tuning, database testing, debugging, troubleshooting, and production support.
  • Experience developing and supporting ETL processes, ideally with SSIS.
  • Experience with Git, Azure DevOps, or equivalent source-control and delivery tools.
  • Understanding of Agile software development methodologies and the ability to work through defined technical deliverables.
  • Strong analytical, problem-solving, written, verbal communication, collaboration, prioritization, and risk-identification skills.
  • Desirable experience includes financial-services industry exposure, AWS, Java, Spark, Scala, SSRS, Power BI, data warehousing, dimensional modeling, analytical databases, CI/CD pipelines, automated database deployments, Python, PowerShell, data governance, security and access controls, cloud migration, database modernization, large-scale data transformation, high availability, and disaster recovery.

Benefits

  • Work location is Bangalore or Pune.
  • The role offers consulting work with international and local banks, insurance companies, payment service providers, and other financial-services clients.
  • Capco describes an open, inclusive culture with career growth opportunities and no forced hierarchy.

Tech Stack

Apache SparkAWSGitJavaMicrosoft SQL ServerPowerShellPythonScala

Categories

Data Engineering
Capco

About Capco

5,001-10,000 employees

Capco is a global technology and management consultancy focused on financial services, helping banks, capital markets, insurance, and wealth firms with digital transformation, risk and compliance, and data/AI-enabled modernization. Founded in 1998 and headquartered in London, it operates as a Wipro company. Its business model centers on project-based consulting, managed services, and solution delivery across strategy, engineering, and platforms for regulated institutions.

Contact me