Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Genpact

Compare

3.8

based on 30.8k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

Top Rated Mega Company - 2024

Top Rated Company for Women - 2024

Top Rated IT/ITES Company - 2024

2208 Genpact Jobs

Lead Consultant - Snowflake Sr. Data Engineer

Headstrong (GENPACT)

3.8

based on 30.8k Reviews

6-11 years

₹ 13 - 22.5L/yr (AmbitionBox estimate)

Mumbai

1 vacancy

Lead Consultant - Snowflake Sr. Data Engineer

Genpact

posted 3hr ago

Job Role Insights

Flexible timing

Key skills for the job

AWS SQL Information Technology Purchase Data Visualization Scheduling

+ 3 more

Job Description

Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of Lead Consultant- S nowflake Sr.Data Engineer (Snowflake + DBT)

In this role, the Snowflake Sr.Data Engineer is responsible for providing technical direction and lead a group of one or more developer to address a goal.

Job Description

Experience in IT industry

Working experience in the IT industry, with a focus on building productionized data ingestion and processing data pipelines in Snowflake.

In-depth knowledge of data warehousing concepts and experience in working with Snowflake, including a deep understanding of its features and integration with other data processing technologies.

Proficiency in creating data pipelines for ETL using Snowflake or DBT (Data Build Tool).

Hands-on experience in configuring, troubleshooting, testing, and managing data platforms, both on-premises and in the cloud.

Familiarity with data visualization tools and methodologies.

Ability to work independently on business problems and generate meaningful insights from data.

Snowflake SnowPro Core Certification is a must .

Excellent presentation and communication skills, both written and verbal.

Strong problem-solving skills and ability to architect solutions in an environment with unclear requirements.

Roles and Responsibilities

Able to work on requirement gathering, analysis, designing, development, and deployment.

Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data.

Good understanding on Data Warehouse concepts and Snowflake Architecture

Hands-on experience with Snowflake utilities such as SnowSQL , SnowPipe , bulk copy, Snowpark, tables, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs, Snowsight .

Have experience with Snowflake AWS data services (S3, Glue,lambda ) or Azure data services (blob storage container, ADLS, ADF) etc

Strong experience in integrating DBT (Data Build Tool) with Snowflake and cloud platforms such as AWS or Azure.

Extensive knowledge of leveraging DBT to build and manage efficient data transformation pipelines in Snowflake.

Experience in designing and developing efficient and scalable data models using DBT, including the creation of tables, views, and macros.

Knowledge of SQL and ability to write complex queries and transformations using DBTs templating language.

Proficiency in using DBTs testing and documentation features to ensure the accuracy and reliability of data transformations.

Understanding of data lineage and metadata management concepts, and ability to track and document data transformations using DBTs lineage capabilities.

Understanding of software engineering best practices and ability to apply these principles to DBT development, including version control, code reviews, and automated testing.

Should have experience building data ingestion pipeline.

Should have good experience in implementing CDC or SCD type 2

Proficiency in working with Airflow or other workflow management tools for scheduling and managing ETL jobs.

Good to have experience in repository tools like Github /Gitlab, Azure repo

Qualifications we seek in you

Minimum qualifications

B.E./ Masters in Computer Science , Information technology, or Computer engineering or any equivalent degree with IT experience and relevant working experience as Snowflake Sr. Data Engineer.

Snowflake, DBT, AWS/Azure, SQL, ETL concepts, Airflow or any orchestration tools, Data Warehousing concepts

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color , religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. .

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit, paying to apply, or purchasing equipment or training .

Employment Type: Full Time, Permanent

Read full job description

Genpact Interview Questions & Tips

Prepare for Genpact Lead Consultant roles with real interview advice

What people at Genpact are saying

3.6

Rating based on 396 Lead Consultant reviews

Anonymous · Healthcare & Life Sciences in Bangalore / Bengaluru

Likes

Wonderful company to work at. No micro management. Good part is genome aap to upskill yourself. Management encourages you to upskill you at work.

Skill development - Excellent

+3 more

Dislikes

No bonus and hike is minimal, health insurance is 2lakhs only, No term insurance for employees, no proper cab service, basic facilities in company is missing.