Data Engineer

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Job Description and Responsibilities:

• Design, develop, and maintain scalable data pipelines and ETL processes using Python.

• Design and develop Stored Procedures and UDFs in Snowflake
• Manage and optimize data storage solutions on AWS, including S3, Glue, Lambda, Step Function, and RDS.
• Develop and maintain SQL queries and scripts for data extraction, transformation, and loading.
• Collaborate with cross-functional teams to understand data requirements and deliver high-quality data solutions.
• Implement and maintain data quality and governance standards.
• Monitor and troubleshoot data workflows to ensure reliability and performance.
• Mentor junior data engineers and provide technical guidance.
• Excellent written and verbal communication skills and be able to lead meetings with technical peers and clients regarding the solution designs.
• Ability to communicate with the Business Analysts, Data Modelers, Cloud Architects, Technical Developers
• Ability to lead Development teams

Primary/Mandatory Experience:

• Experience building ETL data pipeline in Python using AWS services (S3, SNS, CloudWatch, Glue, Lambda, Step Function etc.) and Snowflake
• Proficient in AWS Server less technologies
• Technical knowledge of Extract/Transform/Load (ETL) solutions for running analytic projects on the cloud
• Candidate must have hands-on technical experience on the AWS cloud native technologies along with traditional ETL tools
• Proficiency in AWS services such as, S3, RDS, Lambda and Glue.
• Strong SQL with Snowflake skills, including experience with complex queries and performance tuning.
• Experience with data warehousing concepts and technologies.
• Strong SQL Experience is mandatory.
• Design and develop in Snowflake is mandatory
• DWH Experience is mandatory.
• Additional Experiences: Snowflake Stored Procedure & DWH experience is a plus"

Life at Capgemini:

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Flexible work
Healthcare including dental, vision, mental health, and well-being programs
Financial well-being programs such as 401(k) and Employee Share Ownership Plan
* Paid time off and paid holidays
* Paid parental leave
* Family building benefits like adoption assistance, surrogacy, and cryopreservation
* Social well-being benefits like subsidized back-up child/elder care and tutoring
* Mentoring, coaching and learning programs
* Employee Resource Groups
* Disaster Relief

Disclaimer:

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

Salary Information:

Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation deci