Join Genpact as a Lead Consultant in Mumbai with expertise in SQL & Python. Manage large datasets, automate data processes, and generate insights to support business decision-making. Ideal for professionals with strong analytical skills and an engineering mindset.
Job Details
| Job Title | Lead Consultant, SQL & Python |
|---|---|
| Company | Genpact (NYSE: G) |
| Location | Mumbai, India |
| Industry | Professional Services & Solutions |
| Experience | 3+ years in Data Engineering/Analysis |
| Education | Bachelor’s degree (BTECH) |
| Job Type | Full-time |
| Job Posting Date | Dec 20, 2024 |
| Unposting Date | Jan 19, 2025 |
About the Role
Genpact is seeking a motivated and detail-oriented Lead Consultant with expertise in SQL and Python to join their dynamic team. The role focuses on managing large datasets, designing efficient data pipelines, automating data processes, and generating actionable insights to support data-driven decision-making. You will work collaboratively with cross-functional teams to ensure that data is processed, analyzed, and reported accurately and on time.
Key Responsibilities
- Design & Development: Design, develop, and create data pipelines using AWS and Snowflake.
- SQL & Python: Utilize SQL for data extraction, manipulation, and analysis, and leverage Python for data analysis, automation, and visualization.
- Data Processing: Perform data cleaning, transformation, and ensure data consistency.
- Automate Reporting: Build and maintain automated reports and dashboards for stakeholders.
- Ad-hoc Analysis: Conduct ad-hoc analysis to support business needs and inform data-driven decisions.
- ETL Process: Integrate Python with SQL databases to automate extraction, transformation, and loading (ETL) processes.
- Statistical Analysis: Leverage Python libraries like Pandas, NumPy, and Matplotlib for data manipulation and visualization, and use statistical techniques when necessary.
Qualifications
Minimum Qualifications
- Bachelor’s degree (BTECH) in a related field.
- Excellent communication and presentation skills.
Preferred Skills
- Experience with cloud platforms like AWS, Google Cloud, or Azure.
- Familiarity with big data technologies such as Hadoop and Spark.
- Experience using version control systems (e.g., Git).
- Knowledge of machine learning libraries like scikit-learn is a plus.
- Familiarity with Agile or Scrum development methodologies.
Why Apply?
This position offers an exciting opportunity to work in a global professional services firm with a focus on cutting-edge technology. If you’re passionate about data engineering and enjoy solving complex data problems with SQL and Python, this role at Genpact could be the perfect fit for you.
About Genpact
Genpact is a global professional services and solutions firm that partners with clients to solve complex challenges, enhance business performance, and drive lasting value. With over 125,000 employees across 30+ countries, Genpact combines deep industry knowledge, digital operations services, and expertise in data, technology, and AI to transform leading enterprises.
Application Process
- Location: Mumbai, India.
- Work Schedule: Full-time with the possibility of extended hours depending on the project.
- Equal Opportunity: Genpact values diversity and inclusion, and offers equal employment opportunities regardless of race, color, religion, gender, or any other characteristic protected by law.
The Lead Consultant, SQL & Python role at Genpact presents an exciting opportunity for professionals with expertise in data engineering and analytics, particularly with strong SQL and Python skills. Here’s a breakdown of how you can approach preparing for this role:
Key Responsibilities:
- Data Pipeline Design and Development:
- Develop and manage data pipelines using cloud platforms like AWS and Snowflake.
- Create efficient SQL queries for data extraction, transformation, and analysis.
- Data Cleaning and Transformation:
- Ensure data consistency and accuracy by performing cleaning and transformation tasks.
- Automated Reporting:
- Build and maintain automated dashboards and reports for stakeholders.
- Python for Data Analysis:
- Use Python libraries like Pandas, NumPy, and Matplotlib for data manipulation and visualization.
- Automate data extraction and transformation processes using Python scripts.
- Leverage Python for statistical analysis and predictive modeling when needed.
- Collaboration with Teams:
- Work closely with cross-functional teams to ensure timely and accurate data reporting and analysis.
Skills and Qualifications:
Core Requirements:
- B.Tech degree.
- SQL proficiency for querying and data manipulation.
- Strong Python skills for data analysis and automation.
- Analytical skills with an engineering mindset.
- Strong communication and presentation skills to interact with stakeholders.
Preferred Qualifications:
- Experience with cloud data platforms like AWS, Google Cloud, or Azure.
- Familiarity with big data technologies such as Hadoop or Spark.
- Knowledge of version control systems like Git.
- Experience in machine learning using Python (e.g., scikit-learn).
- Exposure to Agile or Scrum development methodologies.
How to Prepare:
- Cloud Platforms & Big Data:
- Familiarize yourself with cloud technologies, particularly AWS and Snowflake.
- Learn about the architecture and services available for data processing and storage on these platforms.
- If you are not already familiar with Hadoop or Spark, consider doing a crash course or looking into online resources that teach big data frameworks.
- SQL Mastery:
- Enhance your ability to write complex SQL queries for data extraction, aggregation, and transformation.
- Study window functions, joins, and advanced SQL optimization techniques.
- Practice querying data from various types of databases (e.g., relational, cloud-based).
- Python for Data Science:
- Get hands-on experience with Pandas, NumPy, and Matplotlib to work with data.
- Try building automated ETL processes using Python, integrating it with SQL databases.
- Experiment with machine learning libraries like scikit-learn to understand predictive modeling.
- Automation and ETL:
- Build sample Python scripts that automate data processing workflows.
- Practice setting up and maintaining data pipelines from raw data ingestion to final reporting.
- Version Control & Agile:
- If you haven’t already, get familiar with Git for version control.
- Familiarize yourself with Agile methodologies for managing software projects and working within an iterative framework.
Interview Preparation:
- Technical Interviews: Prepare to demonstrate your ability to solve data problems using SQL and Python. You may be asked to build SQL queries or a data pipeline that extracts, transforms, and loads data.
- Behavioral Interviews: Be ready to discuss past projects where you’ve worked with large datasets, automated processes, and collaborated with cross-functional teams.
By enhancing your skills in these areas, you’ll be well-prepared for the Lead Consultant, SQL & Python role at Genpact!
