Principal Consultant- Data Engineer (Azure Snowflake+ Python)
Genpact
5 - 10 years
Pune
Posted: 11/20/2024
Job Description
Responsibilities
Ability to implement Snowflake as an Tech Lead-Experience in building data warehouse on snowflake.
Experience in Azure data lake and Azure Data Factory (ADF).
Good knowledge of ETL/ELT process and provide direction to the team.
Must have knowledge of snowflake architecture and implementation patterns.
Must have understanding of snowflake roles and deployments of virtual warehouses.
Good knowledge of data modelling, integration and design techniques.
Must be a hands-on programming(Python/pySpark..etc) , snowflake and SQL queries, standard DWH + ETL concepts
Must be able to write complex sql queries and Stored Procedures and UDFs.
Creates and updates technical requirement documentation for all systems and solutions
Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features.
Extensive experience in Data Proofing and Data Modelling, Data Quality, Data Standardization, Data Steward.
Experiences or knowledge of Marketing modelling is mandatory.
The candidate should be able to play a major role in our analytics DataMart project, and help us develop modern end-to-end modelling solution in Marketing domain.
Combination of Python and Snowflakes- SnowSQL; writing SQL queries against Snowflake.
Experience working on different source data - RDBMS, Flat files, XML, JSON
Expertise in SQL, especially within cloud-based data warehouses like Snowflake and Azure
Expertise with SnowSQL, advanced concepts (query performance tuning, time travel etc.) and features/tools (data sharing, events, SnowPipe etc.)
About Company
Genpact is a global professional services firm delivering digital transformation by putting digital and data to work to create competitive advantage.
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).