Python & AWS Data Engineer

Python & AWS Data Engineer Onsite location: New York, Chicago & Atlanta Job Description Seeking a highly skilled and motivated Senior Data Engineer to support enterprise data modernization initiatives. This role requires deep expertise in Python, AWS, and relational databases, combined with strong experience in mainframe technologies (VSAM, DB2). The candidate will play a critical role in end-to-end data migration, transforming legacy data systems into modern, scalable cloud-based architectures while ensuring data accuracy, integrity, and governance standards. Key Responsibilities Lead and execute end-to-end data migration efforts, including planning, design, execution, validation, and post-migration support. Analyze legacy data structures (VSAM, DB2) and design transformation strategies into modern RDBMS and AWS environments. Develop and maintain data pipelines and automation scripts using Python. Design, implement, and maintain data models (conceptual, logical, and physical). Manage and administer AWS RDS environments, ensuring high availability, performance optimization, and security compliance. Collaborate with business and technology stakeholders to gather and translate requirements into scalable data solutions. Ensure adherence to data governance, data quality, and compliance standards. Troubleshoot data-related issues and provide timely resolution. Prepare technical documentation for data models, migration workflows, and architecture designs. Compensation The base compensation range for this role in the posted location is: $86,129 to $127,189. Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law. These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity. Benefits Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave Medical, dental, and vision coverage (or provincial healthcare coordination in Canada) Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada) Life and disability insurance Employee assistance programs Other benefits as provided by local policy and eligibility Capgemini is an Equal Opportunity Employer encouraging inclusion 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. #J-18808-Ljbffr Capgemini