ETL Developer with Mainframe

Choose a partner with intimate knowledge of your industry and first-hand experience of defining its future.Select your locationSelect your locationIndustriesChoose a partner with intimate knowledge of your industry and first-hand experience of defining its future.San Francisco, CA# ETL Developer with Mainframe## Job Description**Job Title: ETL Developer with Mainframe Experience****Location: Woodland Hills, CA (Hybrid)****Employment Type: Full-Time****Experience Level: 10+ Years****Job Summary:**We are seeking a skilled professional with expertise in both ETL development and Mainframe technologies. The ideal candidate will be responsible for designing and maintaining robust data pipelines and legacy systems, ensuring seamless data integration and application performance across platforms.**Key Responsibilities:****ETL Responsibilities:*** Design and implement ETL workflows using tools such as **Informatica**, **Talend**, **Apache NiFi**, or **Apache Airflow**.* Extract data from diverse sources including **databases**, **flat files**, and **APIs**.* Transform data according to business rules and load it into **data warehouses** or **data lakes**.* Perform **data profiling**, **cleansing**, and **quality checks** to ensure data integrity.* Collaborate with **data architects** and **business analysts** to define data models and mappings.* Monitor and optimize ETL jobs for **performance**, **scalability**, and **error handling**.* Maintain comprehensive documentation including **data lineage**, **transformation logic**, and **error resolution procedures**.**Mainframe Responsibilities:*** Develop and maintain applications using **COBOL**, **JCL**, **VSAM**, **DB2**, and **CICS**.* Conduct **unit**, **system**, and **integration testing** for mainframe modules.* Debug and enhance existing mainframe programs to improve **performance** and **functionality**.* Ensure seamless integration with **distributed systems** and **modern data platforms**.* Participate in **code reviews**, **disaster recovery planning**, and **technical documentation**.* Work with mainframe tools such as **Changeman**, **AbendAid**, **FileAid**, and **Control-M**.**Qualifications:*** Bachelor’s degree in Computer Science, Information Technology, or related field.* 5+ years of experience in ETL development and Mainframe programming.* Strong understanding of **data integration**, **data warehousing**, and **legacy systems**.* Excellent problem-solving and analytical skills.* Effective communication and collaboration abilities.Works in the area of Software Engineering, which encompasses the development, maintenance and optimization of software solutions/applications.1. Applies scientific methods to analyse and solve software engineering problems.2. He/she is responsible for the development and application of software engineering practice and knowledge, in research, design, development and maintenance.3. His/her work requires the exercise of original thought and judgement and the ability to supervise the technical and administrative work of other software engineers.4. The software engineer builds skills and expertise of his/her software engineering discipline to reach standard software engineer skills expectations for the applicable role, as defined in Professional Communities.5. The software engineer collaborates and acts as team player with other software engineers and stakeholders.Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:Flexible workHealthcare including dental, vision, mental health, and well-being programsFinancial well-being programs such as 401(k) and Employee Share Ownership PlanPaid time off and paid holidaysPaid parental leaveFamily building benefits like adoption assistance, surrogacy, and cryopreservationSocial well-being benefits like subsidized back-up child/elder care and tutoringMentoring, coaching and learning programsEmployee Resource GroupsDisaster ReliefCapgemini 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 decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $ 130000- $140000 /yearly.This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.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 get in touch with your recruiting contact.Click the following link for more information on your rights as an ApplicantLocationSan Francisco, CA #J-18808-Ljbffr