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 5 days ago
Similar jobs that could be interesting for youBased on the MDM ETL Test Engineer in Danvers, IL vacancy
$92.4k - $138.4k
...DESCRIPTION Summary Available Shifts: ~1st Shift: 7:00 AM - 3:30 PM ~2nd Shift: 6:30 PM - 3:30 AM The Quality Engineer coordinates, administers, and performs quality functions of an engineering and technical nature to ensure product quality and...SuggestedWork at officeShift workDay shiftAfternoon shiftAdient US LLC
Normal, IL2 days ago- ...Using software development methodologies and structured approached to systems development.Must have a Bachelor's degree in Systems Engineering, Electrical Engineering, or similar discipline.Must have excellent communication skills to be able to clearly explain the...Suggested
$86.63k - $115k
...about reaching new heights as one team, always delivering for the good of our customers.Job PurposeWe are currently seeking a Quality Engineer 1st Shift to join our team in Goodfield. In this role, you will be responsible for activities related to quality including...SuggestedFlexible hoursDay shift- ...Senior Automation Controls Engineer Job: Senior Automation Controls Engineer Duration: 3+ Months Location: Normal, IL Manufacturing Data & Controls Systems Engineer (Contract) Client is seeking an experienced Manufacturing Data & Controls Systems Engineer to...SuggestedContract workImmediate start
eTeam
Normal, IL2 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...SuggestedImmediate startWorldwideMonday to FridayShift workAfternoon shift
Sumitomo Electric Wiring Systems, Inc
Normal, IL19 days ago $63.5k - $98.4k
...Bloomington Management Level Individual Contributor Job Category Engineering & Science Position Summary Bridgestone Americas Tire... ..., or curing process. Evaluate production data and laboratory test results, analyze production methods, and adjust specifications...Full timeTemporary workWork at officeLocal area- ...work on and focus on your professional growth! Qualifications: ~ Bachelors degree in Mechanical, Manufacturing, or Fabrication Engineering ~0-4 years of industry experience ~ Any experience with Mechanical, Industrial, Manufacturing ~ Ability to work effectively...
gpac
Bloomington, IL3 days ago $78.2k - $97.7k
...outdoors and a desire to protect it for future generations. Role Summary Rivian is seeking a highly motivated and skilled 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 timeInternshipLocal areaShift workNight shiftAfternoon shiftRivian
Normal, IL17 hours ago$78.2k - $97.7k
...a love of the outdoors and a desire to protect it for future generations.Rivian is seeking a highly motivated and skilled Process Engineer to optimize our manufacturing processes and uphold the highest standards of product quality. The ideal candidate will bridge the gap...Full timeTemporary workPart timeInternshipLocal areaShift workNight shiftAfternoon shiftRivian
Normal, IL6 hours ago$43.34 - $57.31 per hour
Job Title: Contract Controls Engineer Pay rate: $43.34- $57.31/hr. Location: Normal, IL Zip Code: 61761 Duration: 12 Months Start Date... ...supporting automated lines. * Establish, document, and test critical system-recovery blocks to minimize downtime and ensure...Contract workTemporary workImmediate startWorldwideFlexible hoursBelcan
Normal, ILa month ago- ...About the job Solar Engineering Manager Location: ***Chicago, IL*** About Us Charlie Mike has partnered with a national leader offering comprehensive energy solutions (Solar, CHP, Battery, Storage) to commercial and industrial clients across the country...Contract work
Charlie Mike Recruiting
Bloomington, IL1 day ago - ...Building AC On-site 100% 24+ month contract (indefinite) Validation Engineer This team is within CATs ePowertrain group - Electrification... ...have responsibility to Client out validation plan, observe testing results and communicate out to product groups. This role will investigate...Contract work
Kasmo Global
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, IL4 days ago- ...Streaming API is a must.Strong expertise on working wit.h 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
- ...Job Description Job Description Manufacturing Design Engineer Goodfield, IL - Full Time Productive Resources ( is seeking a candidate to be part of our engineering team at our customer's facility in Goodfield, IL. As a member of our team, the selected candidate...Full timeContract workTemporary workFlexible hours
Productive Resources
Goodfield, ILa month ago $19 - $22.5 per hour
Job Description Job Description 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...Hourly payFull timeSeasonal workLocal areaImmediate startRelocationAfternoon shiftEssenti Talent
Bloomington, IL3 days ago- ...development methodologies and structured approached to systems development· Have broad background in such areas as applications/system engineering and architecture development of complex systems.· Experience producing and managing detailed documentation to describe...
$113.2k - $155.65k
...our organization grow and make a difference for our clients. About the role The Identity Governance & Access Management (IGA) Engineer is responsible for designing, implementing, and governing enterprise identity and access management capabilities utilizing...Full timeTemporary work- ...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, IL11 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, IL11 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$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$85.5k - $150k
...opportunity.Grow Your Skills, Grow Your PotentialLooking for Software Engineers to work on a team focused on transforming the Property and... ...this role, you will be responsible for designing, developing, testing, and supporting data and software solutions that align with our...H1bWork at officeImmediate startWork from homeState Farm
Bloomington, IL6 hours 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, IL5 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
$99k - $149k
...Position: Electrical Project Engineer Location: Normal, IL Job Id: 3631 of Openings: 1 Farnsworth 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,...Temporary workFor contractorsImmediate startFlexible hoursFarnsworth Group
Normal, IL2 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, IL4 days ago$90k - $130k
...Position: Civil Engineer - Municipal Location: Normal, IL Job Id: 3533 of Openings: 1 Farnsworth Group is seeking a Civil Engineer for our Municipal Group in one of the locations listed below. In this role, you will work with local municipalities and private...Temporary workLocal areaImmediate startFlexible hoursFarnsworth Group
Normal, IL3 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to MDM ETL Test Engineer. Be the first to apply!
