Vacancy description

Data Engineer with Kafka - Pune in Pune, भारत

Capco

  • Full-timeStandard weekly hours

Pune, भारत

Job Title: Data Engineers

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: Senior Data Engineer (Kafka)
Experience: 5+ Years
Location: Pune (Preferred)
Employment Type: Full-Time

Job Summary

We are looking for an experienced Senior Data Engineer with strong expertise in Apache Kafka, Apache Spark, Scala/PySpark, SQL, and modern data engineering technologies . The ideal candidate should have hands-on experience designing, developing, optimizing, and maintaining scalable data pipelines, including batch and real-time streaming solutions.

The role requires strong technical expertise, problem-solving abilities, production support experience, and the capability to independently deliver complex data engineering solutions while mentoring junior team members.

Key Responsibilities

  • Design, develop, and maintain scalable, reliable, and high-performance data pipelines for batch and real-time data processing.
  • Implement and optimize Kafka-based event streaming solutions , ensuring reliable data ingestion, processing, and integration.
  • Develop production-grade data processing applications using Apache Spark and Scala/PySpark .
  • Optimize Spark workloads through effective partitioning, caching, skew handling, join optimization, and performance tuning.
  • Write advanced SQL queries involving complex joins, window functions, data transformations, and query optimization.
  • Design, develop, and troubleshoot ETL/ELT workflows using Apache NiFi, Apache Airflow, or Azure Data Factory (ADF) .
  • Work with cloud-based data storage solutions such as Amazon S3, Azure Data Lake Storage (ADLS), and Data Lakes .
  • Develop Python scripts, automation utilities, reusable ETL components, and testing frameworks.
  • Monitor and support production data pipelines, troubleshoot incidents, perform root cause analysis (RCA), and implement preventive measures.
  • Design end-to-end data engineering solutions with a focus on scalability, performance, reliability, and maintainability.
  • Conduct code reviews, enforce engineering best practices, and mentor junior data engineers.

Required Technical Skills

1. Apache Kafka / Event Streaming

  • Strong understanding of Kafka architecture, event streaming concepts, and implementation.
  • Hands-on experience developing and supporting Kafka-based data ingestion and streaming pipelines.
  • Knowledge of Kafka producers, consumers, topics, partitions, consumer groups, and offset management.
  • Understanding of fault tolerance, message delivery guarantees, and streaming performance optimization.

2. Apache Spark

  • Strong hands-on experience with Apache Spark for large-scale data processing.
  • Expertise in Spark performance tuning, including joins, partitioning, caching, data skew handling, and troubleshooting.
  • Experience developing and optimizing production-grade Spark applications.

3. Scala / PySpark

  • Strong proficiency in at least one of Scala or PySpark, with working knowledge of the other.
  • Ability to write efficient, maintainable, and production-ready code.

4. SQL

  • Advanced SQL skills, including complex joins, window functions, query optimization, and data modeling.
  • Experience working with large datasets and optimizing SQL performance.

5. Data Orchestration – NiFi / Airflow / ADF

  • Strong experience in at least one orchestration tool, with working knowledge of the others.
  • Ability to independently design, develop, monitor, and troubleshoot data pipelines.

6. Cloud Storage – S3 / ADLS / Data Lake

  • Experience working with cloud-based data lakes and storage solutions.
  • Understanding of file formats, partitioning strategies, storage design, data lifecycle management, and performance considerations.

7. Python

  • Good Python scripting and automation skills.
  • Experience building utilities, ETL components, and automated testing frameworks.

8. Production Support & Troubleshooting

  • Experience handling production incidents, monitoring data pipelines, and performing root cause analysis.
  • Ability to implement resiliency improvements and ensure pipeline stability.

Additional Expectations

  • Ability to independently design and deliver medium-to-complex data engineering pipelines with minimal guidance.
  • Strong analytical, debugging, and problem-solving skills.
  • Good understanding of data engineering best practices, performance optimization, and scalable architecture.
  • Experience conducting code reviews and mentoring junior engineers.
  • Strong communication and collaboration skills.

Qualifications

  • Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline.
  • Minimum 5+ years of relevant experience in data engineering, big data technologies, and data pipeline development.
  • Hands-on experience with Kafka-based streaming solutions and distributed data processing frameworks.

Preferred Candidate Profile

We are seeking a technically strong, hands-on Senior Data Engineer who can independently own data engineering deliverables, build robust Kafka-based streaming pipelines, optimize large-scale Spark workloads, resolve complex production issues, and contribute to technical design decisions.

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 Follow us on Twitter, Facebook, LinkedIn, and YouTube.

 

Similar vacancies

More like this role

  • Backend
... development(3+ years) Hands-on expertise in Apache Kafka and event-driven architectures (3+ years) Knowledge of Flowable/BPM workflow development Solid experience with Spring Boot application development Solid knowledge of SQL and relational databases Hands-on experience with Microsoft Azure cloud services Nice to have Good ...

Pune, भारत

  • Full-time
... MAKE AN IMPACT Job Title: Data Engineers Location: Pune, Maharashtra Experience: 5+ Years Employment Type: Full-Time About the Role We are looking for a skilled Data Engineer with strong expertise in Python, Scala, and Databricks to build and maintain scalable data processing solutions. The ideal candidate should have hands-on ...

Pune, भारत

  • Remote
  • Hybrid
  • On-site

€22.5 EUR

... management and integration with current architectural and data governance guidelines with reduced oversight required of leadership. Produces data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science ...

Pune, भारत

Vrinda International

Data Engineer

  • Full-time

Rs 12 - 14 lakhs p.a.

... Requirements Requirements: - Possess 6 to 8 years of professional experience in data engineering, with a strong focus on IT Services. - Demonstrate deep proficiency with Salesforce APIs and dedicated data loading utilities. - Show proven expertise in designing and executing ETL processes and bulk data loading strategies. - Be ...

Pune, भारत

... documentation. Skills Must have 5+ years' experience as a Data Engineer, ideally in a large corporate environment PySpark experience In-depth knowledge of SQL and data modelling/data processing Strong experience working with Microsoft Azure Develop and maintain data pipelines using Databricks Experience with visualisation tools ...

Pune, भारत

IntegriChain

Data Engineer

  • Remote
  • Hybrid
  • Full-time
... quality and relevance - Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions - Partner closely with data analysts and data scientists to deliver clean, well-structured datasets for analysis and modeling - Collaborate with fellow engineers across Git repositories, ...

Pune, भारत

  • Full-time
Leadership QA and testing role at Deutsche Bank in Pune. Needs 9–14 years. What you'll do - Design, develop, test, and deploy high-quality, scalable backend microservices for the Channel Security platform using Java, Spring Boot, Kafka, and related technologies - Partner with the Lead Engineer on solution design and participate ...

Pune, भारत

Madison Logic

Sr. Data Engineer

... business and engineering requirements. - Conduct data analysis to contribute to the enhancement of overall business performance. - Identify and select optimal data sources for specific analytical tasks. - Establish procedures for data mining, data modeling, and data production. - Collaborate with internal and external partners ...

Pune, भारत

nexus-cognitive

Data Platform Engineer

  • On-site
  • Full-time
  • DevOps
... rather ship the rocket than brief someone on it. Check out this podcast of Anu talking about our solution here: We are currently searching for a 100% Hands-on Data Platform Engineer to join our high-performing product team in Pune. As a Data Engineer, you will play a crucial role in providing technical support, resolving ...

Pune, भारत

  • Contract
  • Data Science
... inconsistent, duplicated, and incomplete source data into a clean, reconciled, and trustworthy foundation for analytics. Working closely with the Data Architect, Data Scientist, and Product, the Data Engineer delivers reliable ingestion, entity resolution, and data quality measurement at scale, with multi-tenant data isolation ...

Pune, भारत