Lead Consultant - Snowflake DW+DBT

Genpact (NYSE : G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. 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, Snowflake !

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

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.

Qualifications we seek in you!

Minimum qualifications