etl

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 Title: Software Engineer – ETL Tester

Location: Bangalore

Experience: 3+ Years

Role Overview

We are looking for a highly skilled ETL Tester to join our team. In this role, you will collaborate closely with development teams and product managers to design, develop, and maintain robust software applications. You should be comfortable working on both client-side and server-side architectures, ensuring the delivery of scalable, reliable, and high-performing solutions.

Key Responsibilities

Collaborate with development teams and product managers to design and develop software applications.

Design and work with client-side and server-side architectures.

Build reliable, scalable applications and features with responsive design principles.

Test, troubleshoot, debug, and upgrade software to ensure high performance and efficiency.

Develop and maintain well-functioning databases and applications.

Work in an Agile environment using tools such as JIRA boards.

Optimize Spark jobs for performance, including executor/driver sizing, memory management, adaptive query execution, and join strategies.

Must-Have Qualifications

3+ years of hands-on experience building and maintaining ETL/ELT pipelines.

Strong problem-solving skills using data structures and algorithms in Java.

Expertise in Apache Spark performance tuning (executor/driver sizing, memory management, adaptive query execution, broadcast vs. shuffle joins).

Proficiency in SQL (complex joins, window functions, performance tuning) on relational databases such as DB2 or MySQL.

Knowledge of database creation and maintenance (DB2, MySQL).

Working knowledge of at least one scripting language (Shell).

Familiarity with job scheduling/workflow orchestration tools (Control-M).

Good-to-Have Skills

Understanding of microservices architecture.

Basic knowledge of web applications and their working.

Exposure to Linux-based environments.

Experience with source control tools (Git) and CI/CD pipelines (Jenkins).