Quick overview
Job description
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.
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.
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- SU

Senior Software Engineer I - SDETRecently posted Auto Apply
Surveymonkey · Bengaluru · Hybrid · Posted 20 Nov 2026 🇮🇳
RecruitingSourcingDocker+20TechnologySalary not listed - SE

Senior Software Engineer – AI Chat Platform (Go, LLM Integrations)Recently posted Auto Apply
Securly · Pune · Hybrid · Posted 20 Nov 2026 🇮🇳
OnboardingAWSSSO+9TechnologySalary not listed - ZE

Site Reliability Engineer- IIRecently posted Auto Apply
Zeta · Bengaluru · On-site · Posted 18 Nov 2026 🇮🇳
GCPRubyAWS+14TechnologySalary not listed - WE
Principal DevOps EngineerRecently posted Auto Apply
Weekdayworks · Mumbai · On-site · Posted 20 Nov 2026 🇮🇳
AWSELKTechnologySalary not listed - WE
Application Support EngineerRecently posted Auto Apply
Weekdayworks · Bengaluru · On-site · Posted 20 Nov 2026 🇮🇳
Technology₹600k - ₹1000k/yr - PH

Principal Analytics Consultant (Power BI)Recently posted Auto Apply
phData · Bengaluru · Hybrid · Posted 16 Nov 2026 🇮🇳
SQLAWSSnowflake+5TechnologySalary not listed - NA

Technical Services DeveloperRecently posted Auto Apply
Nasuni · Hyderabad · Hybrid · Posted 20 Nov 2026 🇮🇳
SQLTeamCityGit+15TechnologySalary not listed - MA

Support EngineerRecently posted Auto Apply
Matillion · Hyderabad · Hybrid · Posted 20 Nov 2026 🇮🇳
Talent AcquisitionDockerGCP+25TechnologySalary not listed - B2
Lead AI Engineer I - R01573927Recently posted Auto Apply
Brillio 2 · Bengaluru · Hybrid · Posted 20 Nov 2026 🇮🇳
DockerMicroservicesOracle+13TechnologySalary not listed - TG
Application Engineer, IT Commercial PlatformsRecently posted Auto Apply
TeamViewer Germany GmbH · Mumbai · Hybrid · Posted 20 Nov 2026 🇮🇳
Talent AcquisitionOnboardingERP+2TechnologySalary not listed - CL

Data Engineer Auto Apply
Clinisys · Bengaluru · Hybrid 🇮🇳
RecruitingSQLETL+9TechnologySalary not listed - CE

Cloud Platform Engineer - Pune and MumbaiRecently posted Auto Apply
Centiro · Pune · On-site · Posted 17 Nov 2026 🇮🇳
Continuous ImprovementGoogle CloudTerraform+4TechnologySalary not listed
