SQL Server Developer
Capco · India - Bengaluru · Presencial · Greenhouse
Esta vaga é restrita a candidatos em: Índia. Cidade: Bengaluru. Modalidade: Presencial
Sobre a vaga
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.
Candidatura
Publicado há 1 hora
Recurso para membros · Ver planos
Lembre-se: o Vagaslume.Tech não cobra taxas, cursos ou pagamentos para participação em processos seletivos. Se receber alguma cobrança relacionada à contratação, não efetue o pagamento.