Principal Consultant-Senior Snowflake Data Engineer

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, Senior Snowflake Data Engineer!

In this role, the Sr. Snowflake Data Engineer is responsible for providing technical direction and lead a group of one or more developer to address a goal. • Experience in IT industry • Working experience with building productionized data ingestion and processing data pipelines in Snowflake • Strong understanding on Snowflake Architecture • Fully well-versed with data warehousing concepts. • Expertise and excellent understanding of Snowflake features and integration of Snowflake with other data processing. • Able to create the data pipeline for ETL/ELT • Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements. • Able to create the high level and low-level design document based on requirement. • Hands on experience in configuration, troubleshooting, testing and managing data platforms, on premises or in the cloud. • Awareness on data visualisation tools and methodologies • Work independently on business problems and generate meaningful insights • Good to have some experience/knowledge on Streamlit and AI/ML • Should have experience on Snowflake Best Practices • Snowflake SnowPro Core Certification is must.

Responsibilities

Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data. • Hands-on experience with Snowflake utilities such as SnowSQL, Bulk copy, Snowpipe, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs, Snowsight. • Have experience with Snowflake cloud data warehouse and AWS S3 bucket or Azure blob storage container for integrating data from multiple source system. • Should have have some exp on AWS services (S3, Glue, Lambda) or Azure services ( Blob Storage, ADLS gen2, ADF) • Should have good experience in Python/Pyspark.integration with Snowflake and cloud (AWS/Azure) • Should have some experience on Snowflake RBAC and data security. • Should have good experience in implementing CDC or SCD type-2. • In-depth understanding of Data Warehouse, ETL concepts and Data Modelling • Experience in requirement gathering, analysis, designing, development, and deployment. • Should Have experience building data ingestion pipeline • Good to have DBT experience. • Able to communicate with clients and lead team. • Should have good experience in implementing Snowflake Best Practices • Good to have experience in deployment using CI/CD tools and exp in repositories like Azure repo , Github etc.

Qualifications we seek in you!

Minimum qualifications • B.E./ Masters in Computer Science, Information technology, or Computer engineering or any equivalent degree with IT experience and good working experience as Senior Snowflake Data Engineer.

Skill Metrix: Snowflake, Python/PySpark, AWS/Azure, ETL concepts, Data Modeling, Data Warehousing concepts

Genpact 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.