Lead Consultant- Snowflake Data Engineer( Snowflake+Python+Cloud)

Ready to shape the future of work?

At Genpact, we don’t just adapt to change—we drive it. AI and digital innovation are redefining industries, and we’re leading the charge. Genpact’s AI Gigafactory, our industry-first accelerator, is an example of how we’re scaling advanced technology solutions to help global enterprises work smarter, grow faster, and transform at scale. From large-scale models to agentic AI, our breakthrough solutions tackle companies’ most complex challenges. 

If you thrive in a fast-moving, tech-driven environment, love solving real-world problems, and want to be part of a team that’s shaping the future, this is your moment. 

Genpact (NYSE: G) is anadvanced technology services and solutions company that deliverslastingvalue for leading enterprisesglobally.Through ourdeep business knowledge, operational excellence, and cutting-edge solutions – we help companies across industries get ahead and stay ahead.Powered by curiosity, courage, and innovation,our teamsimplementdata, technology, and AItocreate tomorrow, today.Get to know us atgenpact.comand onLinkedIn,X,YouTube, andFacebook.

Inviting applications for the role of Lead Consultant- Snowflake Data Engineer( Snowflake+Python+Cloud) 

In this role, the Snowflake 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 with building productionized data ingestion and processing data pipelines in Snowflake

Strong understanding on Snowflake Architecture

Fully well-versed with data warehousing concepts.

Expertise and excellent understanding of Snowflake features and integration of Snowflake with other data processing.

Able to create the data pipeline for ETL/ELT

Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements.

Able to create the high level and low-level design document based on requirement.

Hands on experience in configuration, troubleshooting, testing and managing data platforms, on premises or in the cloud.

Awareness on data visualisation tools and methodologies

Work independently on business problems and generate meaningful insights

Good to have some experience/knowledge on Snowpark or Streamlit or GenAI but not mandatory.

Should have experience on implementing Snowflake Best Practices

Snowflake SnowPro Core Certification will be added an advantage

Roles and Responsibilities:

Requirement gathering, creating design document, providing solutions to customer, work with offshore team etc.

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

Hands-on experience with Snowflake utilities such as SnowSQL, Bulk copy, Snowpipe, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs, Snowsight, Steamlit

Have experience with Snowflake cloud data warehouse and AWS S3 bucket or Azure blob storage container for integrating data from multiple source system.

Should have have some exp on AWS services (S3, Glue, Lambda) or Azure services ( Blob Storage, ADLS gen2, ADF)

Should have good experience in Python/Pyspark.integration with Snowflake and cloud (AWS/Azure) with ability to leverage cloud services for data processing and storage.

Proficiency in Python programming language, including knowledge of data types, variables, functions, loops, conditionals, and other Python-specific concepts.

Knowledge of ETL (Extract, Transform, Load) processes and tools, and ability to design and develop efficient ETL jobs using Python orPyspark.

Should have some experience on Snowflake RBAC and data security.

Should have good experience in implementing CDC or SCD type-2. 

Should have good experience in implementing Snowflake Best Practices

In-depth understanding of Data Warehouse, ETL concepts and Data Modelling

Experience in requirement gathering, analysis, designing, development, and deployment.

Should Have experience building data ingestion pipeline

Optimize and tune data pipelines for performance and scalability

Able to communicate with clients and lead team.

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

Good to have experience in deployment using CI/CD tools and exp in repositories like Azure repo ,Github etc.

Qualifications we seek in you

Minimum qualifications

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

Skill Metrix:

Snowflake, Python/PySpark, AWS/Azure, ETL concepts, & Data Warehousing concepts

Why join Genpact?

Be a transformation leader – Work at the cutting edge of AI, automation, and digital innovation 

Make an impact – Drive change for global enterprises and solve business challenges that matter 

Accelerate your career – Get hands-on experience, mentorship, and continuous learning opportunities 

Work with the best – Join 140,000+ bold thinkers and problem-solvers who push boundaries every day 

Thrive in a values-driven culture – Our courage, curiosity, and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress 

Come join the tech shapers and growth makers at Genpact and take your career in the only direction that matters: Up. 

Let’s build tomorrow together. 

---