Data Engineer with Kafka

<p><strong>Data Engineer with Kafka</strong></p> <p><strong>About Us</strong></p> <p><em>“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with </em><strong><em>Consultancy of the year in the British Bank Award</em></strong><em> and has been ranked </em><strong><em>Top 100 Best Companies for Women in India 2022 by <a href="https://avtarinc.com/what-we-do/enrich-diversity/best-companies-for-women/" target="_blank">Avtar & Seramount</a></em></strong><em><a href="https://avtarinc.com/what-we-do/enrich-diversity/best-companies-for-women/" target="_blank">. </a></em><strong><em>With</em></strong><em> 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.</em></p> <p><strong><em>WHY JOIN CAPCO?</em></strong></p> <p>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.</p> <p><strong><em>MAKE AN IMPACT</em></strong></p> <p>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.</p> <p><strong><em>BEYOURSELFATWORK</em></strong></p> <p>Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.</p> <p><strong><em>CAREER ADVANCEMENT</em></strong></p> <p><em>With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.</em></p> <p><strong><em>DIVERSITY & INCLUSION</em></strong></p> <p><em>We believe that diversity of people and perspective gives us a competitive advantage.</em></p> <p><strong>Job Title: Data Engineer with Kafka</strong></p> <p><strong>Position:</strong> Data Engineer with Kafka<br><strong>Experience:</strong> 5+ Years<br><strong>Work Mode:</strong> Hybrid (Capco Office)</p> <p> </p> <h3>Job Summary</h3> <p>We are looking for an experienced <strong>Senior Data Engineer with strong expertise in Apache Kafka, Apache Spark, Scala/PySpark, SQL, and modern data engineering technologies</strong>. The ideal candidate should have hands-on experience designing, developing, optimizing, and maintaining scalable data pipelines, including batch and real-time streaming solutions.</p> <p>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.</p> <h3>Key Responsibilities</h3> <ul> <li>Design, develop, and maintain scalable, reliable, and high-performance data pipelines for batch and real-time data processing.</li> <li>Implement and optimize <strong>Kafka-based event streaming solutions</strong>, ensuring reliable data ingestion, processing, and integration.</li> <li>Develop production-grade data processing applications using <strong>Apache Spark and Scala/PySpark</strong>.</li> <li>Optimize Spark workloads through effective partitioning, caching, skew handling, join optimization, and performance tuning.</li> <li>Write advanced SQL queries involving complex joins, window functions, data transformations, and query optimization.</li> <li>Design, develop, and troubleshoot ETL/ELT workflows using <strong>Apache NiFi, Apache Airflow, or Azure Data Factory (ADF)</strong>.</li> <li>Work with cloud-based data storage solutions such as <strong>Amazon S3, Azure Data Lake Storage (ADLS), and Data Lakes</strong>.</li> <li>Develop Python scripts, automation utilities, reusable ETL components, and testing frameworks.</li> <li>Monitor and support production data pipelines, troubleshoot incidents, perform root cause analysis (RCA), and implement preventive measures.</li> <li>Design end-to-end data engineering solutions with a focus on scalability, performance, reliability, and maintainability.</li> <li>Conduct code reviews, enforce engineering best practices, and mentor junior data engineers.</li> </ul> <h3>Required Technical Skills</h3> <p><strong>1. Apache Kafka / Event Streaming</strong></p> <ul> <li>Strong understanding of Kafka architecture, event streaming concepts, and implementation.</li> <li>Hands-on experience developing and supporting Kafka-based data ingestion and streaming pipelines.</li> <li>Knowledge of Kafka producers, consumers, topics, partitions, consumer groups, and offset management.</li> <li>Understanding of fault tolerance, message delivery guarantees, and streaming performance optimization.</li> </ul> <p><strong>2. Apache Spark</strong></p> <ul> <li>Strong hands-on experience with Apache Spark for large-scale data processing.</li> <li>Expertise in Spark performance tuning, including joins, partitioning, caching, data skew handling, and troubleshooting.</li> <li&