Principal Consultant- Data Engineer (Azure Snowflake+ Python)

Principal Consultant- Data Engineer (Azure Snowflake+ Python)-BFS039514

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 Principal Consultant- Data Engineer (Azure Snowflake+ Python) 
In this role, you shall be responsible for design and build modern data pipelines and data streams. 
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.) 
• Experience with end to end implementation of Snowflake cloud data warehouse or end to end data warehouse implementations on-premise 
• Proven analytical and problem-solving skills 
• Strong understanding of ETL concepts and work experience in any of ETL tool like Informatica, Data stage or Talend 
• Ability to work independently and on multiple tasks/initiatives with multiple deadlines 
• Effective oral, presentation, and written communication skills 
• Data modelling and data integration 
• Support/Troubleshooting 
 
Qualifications we seek in you! 

Minimum qualifications 
• BE/MCA/B.Tech in Computer Science, Information Systems, Engineering, related fields 
• Full lifecycle implementation of Snowflake project Experience (both migration and new implementation). 
• Must have designed and executed at least 1 project of snowflake implementation (ideally on Azure). 
• Snowflake Certification / Azure Certification Preferred-Good to have 
• Extensive Experience on Data Analysis Projects & Expertise in writing complex DB SQL Queries 
• Good Understating of Data-warehousing concepts (** Worked on Traditional Data warehouse projects, not just familiarity with any DB) 
• Good to have hands-on core python scripting exp. & Specialist in data analysis in Python scripting to write function in Azure. 
• Solid experience in consulting or client service delivery experience on Snowflake and Azure 
• Good interpersonal, problem solving and verbal communication skills 

 

 

Regulatory reporting exposureGenpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at genpact.com and on LinkedIn, X, YouTube, and Facebook. 

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training. 

 

 

 

Job

 Principal Consultant

Primary Location

 India-Bangalore

Schedule

 Full-time

Education Level

 Bachelor's / Graduation / Equivalent

Job Posting

 Dec 10, 2024, 7:50:23 AM

Unposting Date

 Jun 8, 2025, 2:20:23 AMMaster Skills List DigitalJob Category Full Time