Lead Consultant- Snowflake Data Engineer( Snowflake+python+cloud)

Ready to shape the future of work At Genpact we don t just adapt to change we drive it AI and digital innovation are redefining industries and we re leading the charge Genpact s our industry-first accelerator is an example of how we re scaling advanced technology solutions to help global enterprises work smarter grow faster and transform at scale From large-scale models to our breakthrough solutions tackle companies most complex challenges If you thrive in a fast-moving tech-driven environment love solving real-world problems and want to be part of a team that s shaping the future this is your moment Genpact NYSE G is an advanced technology services and solutions company that delivers lasting value for leading enterprises globally Through our deep business knowledge operational excellence and cutting-edge solutions - we help companies across industries get ahead and stay ahead Powered by curiosity courage and innovation our teams implement data technology and AI to create tomorrow today Get to know us at and on and Inviting applications for the role of Lead Consultant- Snowflake Data Engineer Snowflake Python Cloud In this role the 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 Snowpark or Streamlit or GenAI but not mandatory Should have experience on implementing Snowflake Best Practices Snowflake SnowPro Core Certification will be added an advantage Roles and Responsibilities Gather requirements create detailed design documents provide solutions to customers and collaborate effectively with offshore teams Write SQL queries against Snowflake and develop scripts to perform Extract Load and Transform ELT ETL operations Hands-on experience with Snowflake utilities such as SnowSQL Bulk Copy Snowpipe Tasks Streams Time Travel Cloning Optimizer Metadata Manager Data Sharing Stored Procedures UDFs Snowsight and Streamlit Experience working with Snowflake cloud data warehouse integrated with AWS S3 buckets or Azure Blob Storage containers to consolidate data from multiple source systems Familiarity with AWS services S3 Glue Lambda or Azure services Blob Storage ADLS Gen2 ADF for cloud data processing and orchestration Strong experience integrating Python PySpark with Snowflake and cloud platforms AWS Azure leveraging cloud-native services for efficient data processing and storage Proficient in Python programming with solid understanding of core concepts including data types variables functions loops and conditionals Deep knowledge of ETL processes and tools capable of designing and developing optimized ETL pipelines using Python or PySpark Experience with Snowflake Role-Based Access Control RBAC and implementing robust data security measures Skilled in implementing Change Data Capture CDC and Slowly Changing Dimension SCD Type 2 methodologies Well-versed in Snowflake best practices for architecture development and optimization Comprehensive understanding of data warehousing concepts ETL frameworks and data modeling principles Proven track record in requirement gathering analysis design development and deployment of data solutions Experience building scalable data ingestion pipelines and optimizing them for performance and reliability Strong communication skills with the ability to engage clients and lead technical teams effectively Proficient with Airflow or other workflow orchestration tools for scheduling and managing ETL jobs Familiarity with CI CD deployment pipelines and version control systems such as Azure Repos and GitHub is a plus Qualifications we seek in you Minimum qualifications B E Masters in Computer Science Information technology or Computer engineering or any equivalent degree with good IT experience and relevant as Snowflake Data Engineer Skill Matrix Snowflake Python PySpark AWS Azure ETL concepts Data Warehousing concepts Why join Genpact Be a transformation leader - Work at the cutting edge of AI automation and digital innovation Make an impact - Drive change for global enterprises and solve business challenges that matter Accelerate your career - Get hands-on experience mentorship and continuous learning opportunities Work with the best - Join 140 000 bold thinkers and problem-solvers who push boundaries every day Thrive in a values-driven culture - Our courage curiosity and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress Come join the tech shapers and growth makers at Genpact and take your career in the only direction that matters Up Let s build tomorrow together 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 respect and integrity customer focus and innovation 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