SQL Server Developer
Role Overview
“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.
WHY JOIN CAPCO?
You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.
MAKE AN IMPACT
Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.
#BEYOURSELFATWORK
Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.
CAREER ADVANCEMENT
With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.
DIVERSITY & INCLUSION
We believe that diversity of people and perspective gives us a competitive advantage.
Job Description:
Role: SQL Server Developer
Location: Bangalore, Pune
Experience: 6-12 yrs
Key Skills for This Role
Full Job Posting
Job Title: AWS data Engineer
About Us
“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount*. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.*
WHY JOIN CAPCO?
You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.
MAKE AN IMPACT
Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.
#BEYOURSELFATWORK
Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.
CAREER ADVANCEMENT
With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.
DIVERSITY & INCLUSION
We believe that diversity of people and perspective gives us a competitive advantage.
Job Description:
Role: SQL Server Developer
Location: Bangalore, Pune
Experience: 6-12 yrs
Responsibilities:
SQL Server Development
- 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.
- Database Performance and Optimisation
- 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.
- Data Integration and ETL
- 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.
- Software Delivery and Quality Assurance
- 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.
- Consulting and Stakeholder Engagement
- 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.
- Required Skills and Experience
- Essential Technical Skills
- 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.
- Consulting and Professional Skills
- 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.
- Desirable Skills and Experience
- 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.
About Capco
Capco is a global management and technology consultancy dedicated to the financial services and energy industries.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Capco
Managing Principal – Cybersecurity Strategy & Transformation
Toronto, CAN
Capco is seeking a cybersecurity leader to grow its consulting practice and advise financial-services executives on security, risk, and resilience. The role leads complex client engagements, develops teams and offerings,
Executive Director, Sales Enablement - North America
Toronto, CAN
Capco is seeking a Sales Enablement Lead to strengthen sales effectiveness and growth across North America. The role leads strategic pursuits, develops sales capabilities, and improves sales tools and practices. Candidat
Talent Acquisition Partner - Technical
Toronto, CAN
The employer is seeking an experienced technical recruiter to lead full-cycle hiring and advise business leaders across its Canadian consulting business. The role includes sourcing, assessing candidates, building pipelin
Market Lead – Financial Services - Qatar
, QAT
Location: Qatar | Practice Area: Business Consulting | Type: Permanent Financial Services organizations across the Middle East are accelerating their transformation agendas to meet evolving customer expectations, regulat
Managing Principal – Cybersecurity Strategy & Transformation
Toronto, CAN
Senior Solution Architect
Toronto, CAN
Senior Backend Developer
Toronto, CAN
Quality Assurance Analyst
, USA
Executive Director, Sales Enablement - North America
Toronto, CAN
Talent Acquisition Partner - Technical
Toronto, CAN
Market Lead – Financial Services - Qatar
, QAT
