Data Engineer

Capco; Pune District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Capco is seeking an experienced Data Engineer to design, develop, and maintain scalable data pipelines in Python, PySpark, and Kafka. The role focuses on batch and real-time processing for large-scale data platforms across financial services clients.

You will collaborate with data scientists, analysts, and business teams to ensure data quality, governance, and security while delivering robust data solutions on cloud architectures.

Qualifications

• 5+ years of data engineering experience.
• Strong Python programming skills.
• Hands-on PySpark and Kafka experience.
• Experience with large-scale data platforms.
• Knowledge of SQL and data warehousing.

Responsibilities

• Design, develop, and optimize batch and real-time data pipelines using Python, PySpark, and Kafka.
• Build scalable ETL/ELT processes for ingesting, transforming, and loading large volumes of data.
• Develop and maintain real-time streaming applications using Apache Kafka, Kafka Connect, and Kafka Streams.
• Implement data transformation, cleansing, and aggregation using PySpark.
• Collaborate with Data Scientists, Analysts, and Business Teams to understand data requirements and deliver robust solutions.
• Monitor, troubleshoot, and optimize data workflows for performance and reliability.
• Ensure data quality, governance, security, and compliance standards are met.
• Integrate data from multiple sources including databases, APIs, and cloud platforms.
• Participate in code reviews and enforce best practices in data engineering and software development.
• Create technical documentation and maintain operational runbooks.

Skills

Python

PySpark

Apache Kafka

SQL

Data modeling

Data warehousing

Spark ecosystem

Cloud technologies

Job description

“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.

Only Immediate Joiners

Technical Requirement:

Exp: 5+ Years

We are seeking a highly skilled Data Engineer with expertise in Python, PySpark, and Apache Kafka to design, develop, and maintain scalable data processing pipelines and real-time streaming solutions. The ideal candidate should have experience working with large-scale data platforms, distributed systems, cloud technologies, and modern data engineering practices.

Key Responsibilities

• Design, develop, and optimize batch and real-time data pipelines using Python, PySpark, and Kafka.
• Build scalable ETL/ELT processes for ingesting, transforming, and loading large volumes of structured and unstructured data.
• Develop and maintain real-time streaming applications using Apache Kafka, Kafka Connect, and Kafka Streams.
• Implement data transformation, cleansing, and aggregation processes using PySpark.
• Collaborate with Data Scientists, Analysts, and Business Teams to understand data requirements and deliver robust solutions.
• Monitor, troubleshoot, and optimize data workflows for performance and reliability.
• Ensure data quality, governance, security, and compliance standards are met.
• Integrate data from multiple sources including databases, APIs, and cloud platforms.
• Participate in code reviews and enforce best practices in data engineering and software development.
• Create technical documentation and maintain operational runbooks.

Required Skills

Core Technologies

• Strong programming experience in Python.
• Hands-on experience with PySpark and Apache Spark ecosystem.
• Experience designing and managing Apache Kafka clusters and streaming solutions.
• Good understanding of distributed data processing frameworks.
• Strong experience with SQL
• Data modeling and warehousing concepts.
• Experience handling large-scale datasets and performance tuning.

If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.