MDM implementations : Data/ETL Test Engineer opportunity in Woodland Hills, CA (Onsite)

Capgemini - San Francisco, CA

Full-time - Mid Level

San Francisco, CA

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Data/ETL Test Engineer role at Capgemini focuses on ensuring data accuracy, consistency, and quality across systems, particularly in IBM Master Data Management (MDM) implementations. The position involves conducting thorough testing, performing ETL validations, and automating data testing tasks to support the organization's commitment to leveraging technology for a sustainable and inclusive world.

Responsibilities

• Conduct testing on MDM implementations, focusing on IBM MDM to ensure data accuracy, consistency, and quality across systems.
• Perform Data and ETL testing to validate data transformation, extraction, and loading processes.
• Write and execute SQL queries for data validation, reconciliation, and quality checks on large datasets.
• Develop and maintain test cases, test data, and automation scripts for comprehensive data testing.
• Use Python to automate repetitive testing tasks and create custom data analysis scripts to improve testing efficiency.
• Collaborate with data architects, developers, and analysts to resolve data issues and enhance testing processes.
• Document test results, provide feedback, and recommend improvements for data integrity and testing practices.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Strong expertise in IBM MDM and data testing methodologies.
• Proficiency in SQL for data validation and reconciliation.
• Experience in ETL testing and data transformation processes.
• Programming experience in Python for automation and data analysis.
• Proven track record in testing large datasets and ensuring data quality in MDM implementations.
• Familiarity with data modeling and database concepts.
• Hands-on experience in writing and executing test plans, test cases, and automation scripts.

Benefits

• 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