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.

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

 

Salary Transparency

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

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 get in touch with 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