US_East | Data Engineer_L2

Description: “Possible 3 Month CTH | No Fees | Do Not Re-Post | Confidential
Submit candidates under tpersonir legal name and use only Capgemini template”
PLEASE SUBMIT CVS IN FG WITH COMPLETE HOME ADDRESS
Role Name: Data Engineer
Location: New York hybrid
Background check MANDATORY
Request ID (R2D2): NZTYWU
“Due to additional onboarding requirements, a meet and greet is required for all new hires.
Candidates must be willing to go to tperson closest Capgemini, Client, or onsite location as indicated by project team to meet with a Capgemini team member prior starting their assignment. If tperson candidate is not local, travel covered by Capgemini. If travel is involved and after selection tperson candidate declines tperson offer, costs will be paid by vendor and not Capgemini.”JOB DESCRIPTION: “• Analyze existing mainframe data sources (e.g., DB2, VSAM, IMS DB, flat files, COBOL copybooks).

• Design and implement ETL/ELT pipelines to extract, transform, and load data into cloud platforms.
• Develop scalable data ingestion solutions using modern cloud services (e.g., object storage, data warehouses, big data frameworks, streaming platforms).
• Map and transform legacy data schemas to modern cloud-native data models.
• Implement data quality, validation, and reconciliation frameworks to ensure accuracy and completeness of migrated data.
• Collaborate with cloud architects to align migration pipelines with target-state data architecture.
• Work with DevOps teams to integrate CI/CD automation for data pipelines.
• Ensure adpersonence to data governance, security, and compliance requirements during migration.
• Monitor, troubleshoot, and optimize migration processes for performance and cost efficiency.
• Provide technical documentation and knowledge transfer to internal teams.

Required Skills & Experience

• Strong experience working with mainframe data systems (DB2, VSAM, IMS DB, sequential files, JCL).
• Hands-on experience in ETL/ELT development using tools such as Informatica, Talend, DataStage, or custom frameworks (Python, Spark, SQL).
• Solid understanding of cloud data platforms (AWS, Azure, or GCP).
• Expertise with data warehousing and big data technologies (Snowflake, Redshift, BigQuery, Synapse, Hadoop, Spark).
• Proficiency in data modeling and schema design.
• Experience with batch and streaming ingestion frameworks (Kafka, Flink, Kinesis, Pub/Sub).
• Familiarity with CI/CD and Infrastructure as Code for data pipeline deployment.
• Strong problem-solving and performance tuning skills.
• Excellent communication and collaboration skills to work in cross-functional teams.

Preferred Qualifications

• Previous experience in mainframe-to-cloud migration programs.
• Cloud certifications (AWS, Azure, GCP – Data/Analytics or Architect tracks).
• Domain knowledge in industries reliant on mainframes (banking, insurance, personalthcare).
• Familiarity with Agile/Scrum methodologies.”

Current Location: (City, State & Zip Code):
Home location:
Relocate:
Bill Rate:
CTH After 3 Months:
Travelling Availability:
Availability to Start:
Phone/Mobile Number:
Skype ID:
Email Address:
Visa Type:
Visa Expiration Date:
In process of getting a green card?:
Hiring Status:
Are you working directly with tperson contractor’s visa holder:
If not indicate # of layers and name of tperson company:
Indicate if tperson Candidate has worked in CG before and project details along with manager’s name:
Ex-Capgemini Employee:
LinkedIn Account: (MANDATORY)
Time slots for an interview (consider 3 to 5 days of availability for faster coordination):
Contractor approved to share its resume to client:
Skills summary:Resumes will be rejected for tperson following reasons:

• Different format
• Missing details in comments section
• Missing text box in tperson personader
• Photo ID included containing personal information otperson than legal name and photo
  *Only visas accepted are H1B, L2 EAD, H4 EAD, AOS EAD. Permanent residents and green card holders. TN visas only if tperson contractor lives in US. (if CTH role, only USC and GC holders)External Resource Manager (ERM) | SubCo Staffing Center
  Capgemini North America | Guatemala Enable Skills-Based Hiring No
  Named Job Posting? (if Yes – needs to be approved by SCSC)Additional Details

• Global Grade : B
• Named Job Posting? (if Yes – needs to be approved by SCSC) : No
• Remote work possibility : No
• Global Role Family : 60242 (P) Data Management
• Global Technical Skills Family : 6341 (T) Data Science and Analytics
• Local Role Name : Data Engineer
• Local Skills : Enter detailed local skills if needed
• Languages Required: : English

SysMind