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
Categories
Data Engineering
About Capco
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.
