Senior MDM/ETL Test Engineer: Data Quality & Validation

Veriipro; Bloomington (IL); On-site; USD 110,000 - 150,000; Full time

Job summary

Veriipro is seeking a Senior MDM ETL Test Engineer to validate MDM and ETL processes, ensuring data quality and accurate transformations within enterprise data integrations. Strong SQL, Informatica MDM, and data warehousing knowledge are essential.

The role involves designing and executing test cases, automating data generation with Python, and collaborating in an Agile environment to deliver reliable data solutions.

Qualifications

• Bachelor's degree in Computer Science, IT, Data Engineering, or related field.
• 6+ years of experience in MDM, ETL, or data warehouse testing.
• Strong hands-on experience with Informatica MDM and MDM concepts.
• Extensive ETL testing and data validation experience.
• Advanced SQL skills, including complex queries, joins, stored procedures, and data reconciliation.
• Knowledge of Python for test automation.
• Experience working in Agile/Scrum environments.
• Understanding relational databases and data warehousing concepts.

Responsibilities

• Develop and implement test strategies for MDM, ETL, and data integration solutions.
• Design, develop, and execute test cases to validate ETL workloads, data migrations, and data transformations.
• Validate data quality, data governance rules, and golden record creation within MDM platforms.
• Perform end-to-end testing of ETL pipelines, data marts, and data warehouses.
• Write and optimize complex SQL queries and stored procedures for data validation and reconciliation.
• Identify data validation scenarios and ensure comprehensive test coverage.
• Collaborate with business analysts, developers, and QA teams to understand business requirements and data flows.
• Automate test data generation and provisioning using Python or similar technologies.
• Analyze, troubleshoot, and resolve data quality and ETL-related issues.
• Participate in Agile ceremonies, defect management, and test reporting.

Skills

MDM concepts

ETL testing

Data validation

SQL proficiency

Python automation

Agile/Scrum

Data warehousing

Data governance

Education

Bachelor's degree

Tools

Informatica MDM

Python

Azure Data Factory

Job description

Veriipro is seeking a Senior MDM ETL Test Engineer to validate MDM and ETL processes, ensuring data quality and accurate transformations within enterprise data integrations. Strong SQL, Informatica MDM, and data warehousing knowledge are essential.

The role involves designing and executing test cases, automating data generation with Python, and collaborating in an Agile environment to deliver reliable data solutions.