1

Intern Etl Informatica Developer Jobs in Illinois

You'll work across a modern, meaningful stack - Informatica PowerCenter, Teradata, Azure DevOps, ... Our teams work in tight Agile cycles with real communication between QA engineers, ETL developers ...

You'll work across a modern, meaningful stack - Informatica PowerCenter, Teradata, Azure DevOps, ... Our teams work in tight Agile cycles with real communication between QA engineers, ETL developers ...

You'll work across a modern, meaningful stack -- Informatica PowerCenter, Teradata, Azure DevOps, ... Our teams work in tight Agile cycles with real communication between QA engineers, ETL developers ...

ETL/ Databse Developer

Chicago, IL · On-site

$52.50 - $68.75/hr

Company Description Established in 1991, Collabera has been a leader in IT staffing for over 22 ... Programming, maintenance and user support of the database and software tools written by the team.

ETL Lead

Lisle, IL · On-site

$90K - $120K/yr

Must Have Technical/Functional Skills Snowflake Roles & Responsibilities • Experienced in Writing SQLs. Able to work independently in analyzing Break fix, Enhancement • Experienced in Python ...

ETL Lead

Lisle, IL · On-site

$90K - $120K/yr

Must Have Technical/Functional Skills Snowflake Roles & Responsibilities • Experienced in Writing SQLs. Able to work independently in analyzing Break fix, Enhancement • Experienced in Python ...

Abinitio

Moline, IL · On-site

$46 - $60.25/hr

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services. * Skills: - Ab initio ETL, UNIX shell ...

Lead ETL Architect (No H1B)

Deerfield, IL

$56.25 - $77/hr

... Information Technology Enabled Services. As background, this client has been working with us and ... Lead ETL Architect Client's is seeking a Lead ETL Architect as a key member of their Center of ...

Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services. - * Skills: - Ab initio ETL, UNIX shell ...

next page

Showing results 1-20

Intern Etl Informatica Developer information

What is the difference between Intern Etl Informatica Developer vs Data Analyst?

AspectIntern Etl Informatica DeveloperData Analyst
Required CredentialsBasic knowledge of ETL tools, Informatica certifications preferredDegree in statistics, mathematics, or related field; SQL knowledge
Work EnvironmentData integration teams, IT departments, project-basedBusiness units, analytics teams, reporting environments
Employer & Industry UsageIT companies, data management firms, finance, healthcareMarketing, finance, retail, consulting

Intern Etl Informatica Developers focus on learning and assisting with data integration using Informatica tools, often in IT or data management teams. Data Analysts analyze data sets to generate insights, typically working in business or analytics departments. While both roles require data skills, the Intern Etl Informatica Developer role emphasizes data integration and ETL processes, whereas Data Analysts focus on data interpretation and reporting.

What cities in Illinois are hiring for Intern Etl Informatica Developer jobs? Cities in Illinois with the most Intern Etl Informatica Developer job openings:
Quality Assurance Analyst / ETL Tester

Quality Assurance Analyst / ETL Tester

DATAMAXIS

Springfield, IL • On-site, Remote

Contractor

Re-posted 18 days ago


Job description

Position Summary: The ETL Tester will be responsible for designing, automating, and executing test cases for Enterprise
Data Warehouse (EDW) ETL processes in a State Government Medicaid environment. In this role, you will be responsible for ensuring the accuracy, integrity, and reliability of data as it moves through our ETL processes. You will leverage your expertise to design and execute test strategies that validate both functional and non-functional requirements of our data pipelines.
The tester will leverage ETL tools, primarily Informatica PowerCenter for extraction, transformation, and loading, and Teradata RDBMS for core data store validation - within Azure DevOps and agile sprint cycles to ensure data quality, identify defects, and automate repeatable testing processes.
Requirement Analysis & Test Strategy
  • Review change requests and participate in requirement analysis for EDW data pipelines and transformations
  • Collaborate with data engineers, analysts, and business stakeholders to ensure test coverage aligns with business requirements
  • Design comprehensive test strategies, test plans, and test cases for ETL workflows

ETL & Data Validation
  • Perform end-to-end validation of data pipelines from source systems to EDW targets • Validate source-to-target mappings, transformation logic, and business rules
  • Execute data quality checks including row counts, null validation, duplicate detection, and referential integrity SQL & Backend Testing
  • Develop complex SQL queries (joins, aggregations, transformations) to validate ETL processes
  • Perform backend and database testing across large datasets and multiple systems

Automation & Scripting
  • Develop and maintain automated data validation frameworks using Python (Pandas, SQLAlchemy)
  • Build reusable scripts for regression testing, reconciliation, and data comparisons
  • Integrate automated testing into Azure DevOps CI/CD pipelines

Cloud & Data Platform Testing
  • Validate data pipelines and workflows within Azure Data Factory (ADF)
  • Test integrations across Azure services including Azure Data Lake, Azure SQL, and related components
  • Support validation of cloud-based data processing and orchestration workflows

Defect Management & Reporting
  • Identify, document, and track defects using tools such as Azure DevOps, JIRA, or HP ALM
  • Partner with development teams to troubleshoot issues and ensure resolution
  • Provide clear, audit-ready documentation of test results and findings

Required Qualifications:
  • 5+ years of experience in QA/testing with a focus on ETL, EDW, or backend data systems
  • 5+ years of hands-on Python experience for data validation, automation, and scripting
  • 5+ years of Azure experience, including data platform and cloud-based testing
  • 5+ years of Azure Data Factory (ADF) experience, including pipeline validation and orchestration testing
  • 5+ years of experience working in cloud environments, preferably Azure
  • Strong SQL expertise with hands-on experience in relational databases (Teradata, SQL Server, or equivalent)
  • Experience testing complex data transformations, data models (star/snowflake), and SCD (Type 1/Type 2)
  • Experience with test management and defect tracking tools (Azure DevOps, JIRA, HP ALM)
  • Strong analytical and troubleshooting skills with attention to detail
  • Experience working in Agile/Scrum environments

Preferred Qualifications
  • Healthcare or Medicaid domain experience (claims, encounters, eligibility, provider data)
  • Knowledge of HIPAA and healthcare data standards (837/835, ICD, CPT, HL7)
  • Experience with Medicaid Enterprise Systems (MES) or State agencies (e.g., Illinois HFS)
  • Experience with Informatica or legacy ETL tools (nice-to-have, not required)
  • Familiarity with GitHub or version control for automation

DATAMAXIS logo

About DATAMAXIS

Sourced by ZipRecruiter

Datamaxis is passionate about making our clients win. As a trusted partner, we will bring innovative solutions, technical expertise in Data, cyber security analytics, strategic staffing and AI/ML to help create value (ROI) for our clients, stay competitive and operationally efficient.

Industry

It services

Company size

51 - 200 Employees

Headquarters location

Reston, VA, US

Year founded

2003