SQL Server Developer
- Bengaluru, India
- Mid Level
- 6+ years
- Posted
Skills
Required
- ETL
- SQL Server development
- T-SQL
- SQL queries
- indexing
- performance tuning
- SSIS
- data integrity
- source control
- database development
- Microsoft SQL Server
- relational database design
- normalisation
- Git
Preferred
- SQL
- Server
- Java
- Spark
- Scala
- SQL Server Reporting Services
- SSRS
- Python
- PowerShell
Job Title: AWS data Engineer
About Capco
“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.
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.
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.
Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.
With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.
We believe that diversity of people and perspective gives us a competitive advantage.
Role: SQL Server Developer
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.
- 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.
Requirements
- Location : Bangalore, Pune
Experience : 6-12 yrs
- 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.
Preferred
- 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.
