1

Extract Transfer Load Data Jobs in Illinois (NOW HIRING)

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

The role involves leading ETL processes, writing SQLs, and managing AWS Glue jobs while ensuring effective communication and documentation. Responsibilities : • Experienced in Writing SQL's. Able ...

Senior ETL Developer

Chicago, IL · On-site

$80K - $130K/yr

Model extensions to the existing Data Warehouse. * Build ETL components according to ETL specifications. Code must address performance, dependency, auditing, error handling, and data quality issues.

Specialties Business Intelligence, Custom Application Development, Mobile Applications, Data ... ETL; analysis, design, coding, testing and documentation Hands-on ETL developer (in one or more ...

Data Engineer, Python & ETL

Chicago, IL · On-site

$118K - $141K/yr

  • Medical

  • Retirement

  • PTO

Data Engineer, Python & ETL, Chicago, IL A proprietary trading firm is seeking a Data Engineer, Python & ETL to join its Data Infrastructure team, to help improve and extend the data platform. This ...

ETL DEVELOPER

Chicago, IL · On-site

$99 - $100/hr

ETL DEVELOPER REQUIRES: * 10+ years of experience in Enterprise Application Integration and software development. * 5+ years of hands-on experience with Oracle Integration Cloud (OIC). * Strong ...

Job Role: ETL Tester Location: Deerfield, IL Permanent/Fulltime Requirements 6+ years of experience ... large data sets; Team leadership experience Experience working in the dynamic Agile framework ...

Job Role: ETL Tester Location: Deerfield, IL Permanent/Fulltime Requirements 6+ years of experience ... large data sets; Team leadership experience Experience working in the dynamic Agile framework ...

ETL Test Lead with Actimize experience

Chicago, IL · On-site

$49 - $66.75/hr

Write and execute complex SQL queries for data validation and reconciliation * Documentation, test reporting and people management * Familiarity of ETL tools * Exposure to cloud platforms (AWS, Azure ...

Showing results 21-40

Extract Transfer Load Data information

What is the difference between Extract Transfer Load Data vs Data Analyst?

AspectExtract Transfer Load DataData Analyst
Primary RoleExtracts, transforms, and loads data for systems or databasesAnalyzes data to generate insights and reports
Skills & CertificationsSQL, ETL tools, data management certificationsSQL, data visualization, statistical analysis
Work EnvironmentData warehouses, ETL pipelines, IT departmentsBusiness intelligence, analytics teams, offices
Industry UsageData integration, database managementBusiness analysis, decision-making

While both roles involve working with data, Extract Transfer Load Data focuses on data extraction, transformation, and loading processes, often in IT or database environments. Data Analysts interpret data to provide insights and support business decisions. Understanding these differences helps clarify career paths and job expectations in data-related fields.

What are popular job titles related to Extract Transfer Load Data jobs in Illinois? For Extract Transfer Load Data jobs in Illinois, the most frequently searched job titles are:
What job categories do people searching Extract Transfer Load Data jobs in Illinois look for? The top searched job categories for Extract Transfer Load Data jobs in Illinois are:
What cities in Illinois are hiring for Extract Transfer Load Data jobs? Cities in Illinois with the most Extract Transfer Load Data job openings:

MDM ETL Test Engineer

PB consulting

Bloomington, IL • On-site

Full-time

Posted 5 days ago


Job description

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.