Consultant- Snowflake+Python+Cloud (AWS or Azure)

Responsibilities

Requirement gathering, creating design document, providing solutions to customer, work with offshore team etc.

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, streamlit

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) with ability to leverage cloud services for data processing and storage.

Proficiency in Python programming language, including knowledge of 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.

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

Experience in requirement gathering, analysis, development, and deployment.

Should Have experience building data ingestion pipeline

Optimize and tune data pipelines for performance and scalability

Able to communicate with clients and lead team.

Good to have exp with Airflow or other workflow management tools for scheduling and managing ETL jobs.

Good to have experience in deployment using CI/CD tools and exp in repositories like Azure repo , Github etc.

Skill Metrix:

Snowflake, Python/PySpark, AWS/Azure, ETL concepts, & Data Warehousing concepts

Qualifications/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.

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.

Lets build tomorrow together.