Lead Consultant - Snowflake Sr. Data Engineer

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 DBT's templating language.

Proficiency in using DBT's 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 DBT's lineage capabilities.

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.