Lead Consultant - Snowflake DW+DBT
Genpact
5 - 10 years
Gurugram
Posted: 3/5/2025
Job Description
Responsibilities
:Should have experience in IT industry
Should have good experience in DBT
Strong experience in building/designing the data warehouse, data lake, and data mart end-to-end implementation experience focusing on large enterprise scale and Snowflake implementations on any of the hyper scalers.
Strong understanding on Snowflake Architecture
Able to create the design and data modelling independently.
Able to create the high level and low-level design document based on requirement.
Strong experience with building productionized data ingestion and data pipelines in Snowflake
Should have strong experience in migration/greenfield projects in Snowflake.
Should have experience in implementing Snowflake best practices for network policy , Storage integration, data governance, cost optimization, resource monitoring, data ingestion, transformation, consumption layers
Should have good exp on Snowflake RBAC and data security
Should have good experience in implementing strategy for CDC or SCD type 2
Strong experience in Snowflake features like Bulk Copy, Snowpipe, Snowpark, SnowSQL, stages, file format, virtual warehouses, time travel, cloning, tables, store procedures, UDFs, Data Sharing, SnowSight.
Should have good understanding on ETL processes.
Should have good experience in Python.
Should have experience in AWS services (S3, Glue, Lambda, Secrete Manager, DMS) and few Azure services (Blob storage, ADLS, ADF)
Should have some experience/knowledge in orchestration and scheduling tools experience.
Good understanding of agile methodology.
Good to have exposure to on-prem databases such as SQL Server, Oracle, PostgreSQL
Must to have Snowflake SnowPro Core or SnowPro Advanced Architect certification.
Able to create POCs, roadmaps, solution architecture, estimations & implementation plan Experience for Snowflake integrations with other data processing.
Minimum Qualifications
B.E./ masters in computer science, Information technology, or Computer engineering or any equivalent degree with good years of IT experience and strong working experience in Snowflake as a Snowflake Architect.
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).