Principal Consultant - Snowflake Sr. Data Engineer
Genpact
5 - 10 years
Kolkata
Posted: 3/5/2025
Job Description
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
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 packages like pandas, NumPy etc , 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 and Pyspark.
Ability to use Python and Pyspark for data cleaning, pre-processing, and transformation tasks, including handling missing values, outliers, and other data quality issues.
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
Minimum Qualifications
B.E./ Masters in Computer Science, Information technology, or Computer engineering or any equivalent degree with good IT experience and relevant years of working experience as Snowflake Sr. Data Engineer.
Skill Matrix:
Snowflake, Python/Pysprak, AWS/Azure, ETL concepts, Airflow or any orchestration tools, Data Warehousing concepts
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).