MDM ETL Test Engineer
PB consulting
We are seeking a Senior MDM ETL Test Engineer with strong experience in Master Data Management (MDM), ETL testing, and data validation. The ideal candidate will be responsible for validating MDM and ETL processes, ensuring data quality, verifying data transformations, and testing enterprise data integration solutions. This role requires strong SQL expertise, experience with Informatica MDM, and a solid understanding of data warehousing concepts.
Roles and Responsibilities
- Develop and implement test strategies for MDM, ETL, and data integration solutions.
- Design, develop, and execute test cases to validate ETL workflows, 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.
Required Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
- 6+ years of experience in MDM, ETL, or data warehouse testing.
- Strong hands-on experience with Informatica MDM and MDM concepts.
- Extensive experience in ETL testing and data validation.
- Advanced SQL skills, including complex queries, joins, stored procedures, and data reconciliation.
- Strong understanding of relational databases, data modeling, and data warehousing concepts.
- Experience validating data quality, business rules, and data governance requirements.
- Knowledge of Python for test automation and data processing.
- Experience working in Agile/Scrum environments.
- Strong analytical, troubleshooting, and problem-solving skills.
Preferred Skills
- Experience with Azure Data Factory or other cloud-based data integration platforms.
- Experience with test automation frameworks for data testing.
- Exposure to enterprise data governance and master data management initiatives.
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the MDM ETL Test Engineer in Normal, IL vacancy
$98.5k - $123.1k
...future generations. Role Summary The Sr. Quality Engineer, Complete Vehicle Quality, will be a cross-functional role that... ...engineering environments ~ Demonstrated ability to build and maintain testing methods for detection, diagnostics and investigation for...SuggestedFull timeContract workTemporary workPart timeLocal areaShift workRivian
Normal, IL20 hours ago- ...Quality EngineerAvailable Shifts:1st Shift: 7:00 AM – 3:30 PM2nd Shift: 6:30 PM – 3:30 AMThe Quality Engineer coordinates, administers, and performs quality functions of an engineering and technical nature to ensure product quality and reliability at minimum quality costs...SuggestedWork at officeShift workDay shift
Adient
Normal, IL4 days ago - ...Senior Automation Controls EngineerJob: Senior Automation Controls Engineer Duration: 3+ Months Location: Normal, ILManufacturing Data & Controls Systems Engineer (Contract)Client is seeking an experienced Manufacturing Data & Controls Systems Engineer to lead data cleanup...SuggestedContract workImmediate start
eTeam
Normal, IL1 day ago - ...education, industrial instruction, or structured system integration mentoring. Sourced via an approved specialized automation engineering agency partner (e.g., Actalent, Aerotek) for an initial 12-month milestone contract. Demonstrated ability to be proactive, flexible...SuggestedContract workWork experience placementImmediate startFlexible hours
Artech
Normal, IL4 days ago $43.34 - $57.31 per hour
...Automation Controls Engineer Job Number: 366666 Category: Manufacturing Engineering Description: Job Title: Contract Controls Engineer... ...supporting automated lines. Establish, document, and test critical system-recovery blocks to minimize downtime and ensure...SuggestedContract workTemporary workImmediate startWorldwideFlexible hoursBelcan
Normal, IL4 days ago- ...Description JOB TITLE: Quality Resident Engineer I Work Location: Rivian Assembly Plant in Normal, Illinois Address: 100 Rivian Motorway, Normal, Illinois 61761 Shift / Work Hours: 2nd Shift, 6:30 PM to 3:00 AM, Monday - Friday BASIC PURPOSE: The...Immediate startWorldwideMonday to FridayShift workAfternoon shift
Sumitomo Electric Wiring Systems, Inc
Normal, IL17 days ago $98.5k - $123.1k
...and a desire to protect it for future generations. Role Summary Rivian is seeking a highly motivated and skilled Senior Process Engineer to optimize our manufacturing processes and uphold the highest standards of product quality. The ideal candidate will bridge the...Full timeContract workTemporary workPart timeLocal areaShift workNight shiftAfternoon shiftRivian
Normal, IL5 days ago$94.4k - $138.4k
...JOB DESCRIPTION Summary: A Manufacturing Engineer is responsible for designing, implementing, and improving manufacturing processes to ensure safe, efficient, and cost-effective production. This role works closely with production, quality, maintenance, and leadership...Work at officeAdient US LLC
Normal, IL5 days ago- ...group – Electrification and Energy Solutions. Team of 15 total engineers. They develop ePowertrains – everything from power source all the... ...have responsibility to Client out validation plan, observe testing results and communicate out to product groups. This role will investigate...
Kasmo Global
Bloomington, IL4 days ago $19 - $22.5 per hour
Packaging Supervisor**Location:**Bloomington, IL — 100% onsite (seed conditioning & packaging plant)**Salary:**$19.00–$22.50/hr (DOE) + full benefits + company-wide 15–17% profit-sharing bonus (paid twice a year — roughly an extra $3–4/hr equivalent)**Industry:**Agribusiness...Hourly payFull timeSeasonal workLocal areaImmediate startRelocationAfternoon shiftTorrey Holistics
Bloomington, IL3 days ago$500 per month
...Professional Game Tester We're looking for passionate gamers to join our elite team of mobile game testers. Get paid to play and test the latest games before they launch. $500+ Avg Monthly Pay 5-10 Hours/Week 100% Remote Position Requirements: Must...Remote work10 hours per weekBabki
Bloomington, IL3 days ago- ...Streaming API is a must.Strong expertise on working with various ETL looks like Informatica, Pervasive, Dell Boomi, and Data Stage.... ...mapping for data integration and migration.Develop and document unit testing scenarios.Adhere to best practices defined by the Architects...Permanent employmentFull timeH1b
- ...build your career. Are you ready to realize your potential? Join Team Novo Nordisk and help us make what matters.The PositionThe Engineer, Process - Drug Substance, will support ongoing activities by assisting in troubleshooting mechanical problems, identifying improvements...For contractorsLocal area
$25 - $31.25 per hour
...Job Description Job Description Job Title: Supply Chain Engineer Job Description The Supply Chain Engineer collaborates closely with... ...in Massachusetts to require or administer a lie detector test as acondition of employment or continued employment. An employer...Contract workTemporary workActalent
Bloomington, IL9 days ago$19 - $22.5 per hour
Job Description Job Description Seed Packaging and Bagging Operations Supervisor Step into a hands-on leadership role where precision packaging meets agricultural impact. From preseason tune-ups to peak-season execution, you’ll guide a small crew to label, bag, stack...Hourly payFull timeSeasonal workLocal areaImmediate startRelocationDay shiftAfternoon shiftEssenti
Bloomington, IL6 days ago$25 - $31.25 per hour
...Job Description Job Description Job Title: Supply Chain Engineer Job Description The Supply Chain Engineer collaborates closely with... ...in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer...Contract workTemporary workActalent
Bloomington, IL9 days ago$113.2k - $155.65k
...that are high performing and meet technical standards.Supports testing and problem solving/debugging of solutions.Implements software... ..., take ownership of outcomes, and exercise strong integration engineering judgment.#LI-CORP#LI-HybridBase Pay Range:$113,200-$155,650The...Full timeTemporary work- ...Forward Deployed Engineer We're hiring a Forward Deployed Engineer to be our hands and eyes onsite at a key customer in Normal, IL. You'll be responsible for our fleet of data collection devices — diagnosing and repairing devices, provisioning new hardware, troubleshooting...Local areaRemote work
Mind Robotics
Normal, IL18 hours ago $82.7k - $128.2k
...BloomingtonManagement LevelIndividual ContributorJob CategoryLegal, Compliance & AuditPosition SummaryIn this role the Sr. Environmental Engineer is responsible for assuring ongoing plant compliance with all State and Federal environmental regulations / permits, and corporate...Full timeTemporary workFor contractorsWork experience placementLocal area- ...architecture components using business requirements and creating corresponding documentation for future reference • Partner with the testing team to ensure applications/components are fully functional • Follow procedures and standards set by the project and client •...
Concord IT Systems
Bloomington, IL5 days ago - ...State Farm in Tempe, AZ is hiring a Software Engineer to join the Innovation Group. You will design, develop, and maintain scalable software using TypeScript, Angular, and Go, while applying GenAI and AI tools to enhance product capabilities. You will collaborate with...
State Farm
Bloomington, IL3 days ago - Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled...Full timeH1b
- Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled...Permanent employmentFull timeH1b
- Material HandlerSummary: The Material Handler stages the necessary materials at line side needed to produce approximately 4 hours of finished goods. The Material Handler must also identify part shortages in advance, understand and use the Kanban system and communicate ...
Adient
Normal, IL3 days ago $36.78 - $63.26 per hour
...echocardiography laboratory. Perform a full range of cardiac diagnostic testing. Assist performing physicians and sonographers in providing... ...through Carle Illinois College of Medicine, the world’s first engineering-based medical school, and Methodist College. Carle BroMenn...Work experience placementLocal areaRelocation packageShift workWeekend workCarle Health
Normal, IL2 days ago$87k
...vacation, holidays, and sick days and much more. ***This Engineering role can be filled at the Entry, Mid-level, or Senior Engineer... ...requirements, as applicable, and favorable medical examination and/or testing in accordance with position duties MINIMUM...Constellation Energy
Bloomington, IL4 days ago$99k - $149k
...Electrical Project Engineer - HealthcareFarnsworth Group is seeking an Electrical Project Engineer - Healthcare in one of the posting locations below. The Electrical Project Engineer – Healthcare delivers project-level electrical and low-voltage designs for hospitals,...Local areaFlexible hoursFarnsworth Group
Normal, IL4 days ago$99k - $149k
...Electrical Project EngineerFarnsworth Group is seeking an Electrical Project Engineer in one of the posting locations below. In this role, you will serve as a senior technical lead for the planning, design, and execution of electrical building systems projects. This role...For contractorsFlexible hoursFarnsworth Group
Normal, IL4 days ago- ...Civil Engineer I The Civil Engineer I position is an entry-level Civil Engineering position. This position is distinguished from the Civil Engineer II and Senior Civil Engineer levels by the performance of the more routine tasks and duties assigned. Since this position...For contractorsWork experience placementWork at office
GovernmentJobs.com
Bloomington, IL18 hours ago $84.3k - $142.26k
...Location : Operations Building - 109 E. Olive St., Bloomington, IL Job Type: Full-Time Job Number: 00895 Department: Engineering Division: Engineering Opening Date: 06/17/2026 Closing Date: Continuous FLSA: Exempt Hours/Shift: Mon-Fri 7:3...Full timeFor contractorsWork experience placementWork at officeFlexible hoursShift workCity of Bloomington
Bloomington, IL2 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to MDM ETL Test Engineer. Be the first to apply!
