Lead Consultant - Java, Selenium, API Automation, ETL, SQL, Java/Python
Genpact
5 - 10 years
Bengaluru
Posted: 3/24/2025
Job Description
Responsibilities
Lead and mentor a team in designing, developing, and optimizing ETL processes to ensure seamless data integration.
Implement ETL solutions to extract, transform, and load data from various sources into data warehouses.
Develop and maintain data pipelines that support real-time and batch processing.
Collaborate with stakeholders to understand data requirements and translate them into scalable ETL solutions.
Optimize ETL performance, ensuring high efficiency and minimal data latency.
Troubleshoot and resolve data quality, data flow, and integration issues across ETL processes.
Automate data extraction, transformation, and loading processes using Python, Java, and other scripting tools.
Maintain comprehensive documentation for ETL workflows and ensure proper version control.
Qualificationswe seek in you!
Minimum qualifications
Strong expertise in ETL processes and tools (e.g., Apache Kafka, Talend, Informatica, or custom solutions).
Bachelor's / Graduation / Equivalent with equivalent experience.
Advanced knowledge of SQL, including complex queries, performance tuning, and data transformations.
Experience in Python and Java for scripting and developing data pipelines.
Hands-on experience with large-scale data integration and database management.
Proficiency in data modelling and designing scalable, high-performance ETL architectures.
Strong understanding of data warehousing concepts, including staging, loading, and transformation.
Experience with cloud-based ETL tools and services (e.g., AWS Glue, Azure Data Factory).
Excellent problem-solving skills, especially related to data quality and integration challenges.
Preferred qualifications
Familiarity with Agile methodologies, including Scrum and Kanban.
Experience with Cloud platforms (AWS, Azure, Google Cloud) is a plus.
Experience with DevOps practices and tools (Jenkins, Docker, Kubernetes, etc.).
Familiarity with modern frameworks for API testing such as Postman or Rest Assured.
About Company
Genpact is a global professional services firm that offers a wide range of digital transformation services and solutions. With a presence in over 30 countries, Genpact leverages its deep domain expertise in operations and analytics to help businesses transform their operations, improve efficiency, and enhance customer experience. The company combines digital technology, data science, and operational excellence to deliver business outcomes across various industries, including banking, insurance, manufacturing, and healthcare. Founded in 1997 as a subsidiary of GE, Genpact has grown into an independent, NYSE-listed company with a diverse workforce of over 90,000 employees globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).