ETL Engineer

TheCorporate LLC

North Chicago (IL)

On-site

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

TheCorporate LLC is seeking an experienced ETL Engineer for a 12-month contract-to-hire engagement in North Chicago, IL. The role focuses on building and optimizing data integration pipelines using Informatica PowerCenter, advanced SQL, and modern data technologies.

The ideal candidate will work hands-on with SQL Server, Cassandra/DataStax, and have exposure to Databricks or PySpark to process large datasets. This onsite position starts immediately with potential extension based on performance.

Qualifications

  • Strong hands-on experience in ETL development.
  • Expert-level SQL skills, including complex queries and query optimization.
  • Strong experience with Informatica PowerCenter.
  • Hands-on experience with SQL Server.
  • Hands-on experience with Cassandra/DataStax.
  • Ability to troubleshoot and optimize ETL workflows and database processes.
  • Must be authorized to work as a U.S. Citizen or Green Card holder.

Responsibilities

  • Develop, maintain, and optimize ETL processes and data integration workflows.
  • Build and maintain ETL solutions using Informatica PowerCenter.
  • Write, troubleshoot, and optimize complex SQL queries.
  • Work with SQL Server and Cassandra/DataStax databases.
  • Support data extraction, transformation, loading, and validation processes.
  • Troubleshoot data pipeline issues and improve data processing performance.
  • Collaborate with technical teams to support data integration and business requirements.
  • Utilize Databricks and/or PySpark for data processing tasks where applicable.

Skills

ETL Development
SQL
Informatica PowerCenter
SQL Server
Cassandra/DataStax
Databricks PySpark

Tools

Databricks
PySpark
SQL Server
Cassandra/DataStax

Job description

ETL Engineer

Location : North Chicago, IL

Job Type: Contract-to-Hire

Work Arrangement: 100% Onsite

Contract Duration: 12 months, with potential for extension

**Start Date:* * Immediate

**Client :** Direct Client

**Work Authorization:** U.S. Citizens and Green Card holders only

Job Overview

We are seeking an experienced ETL Engineer with strong hands-on expertise in ETL development, Informatica PowerCenter, advanced SQL, and database technologies. The ideal candidate will have practical experience working with SQL Server and Cassandra/DataStax. Experience with Databricks and/or PySpark is highly desirable.

This is an excellent opportunity for a skilled ETL professional looking for a contract-to-hire position with a direct client in North Chicago, IL.

## Key Responsibilities
  • Develop, maintain, and optimize ETL processes and data integration workflows.

  • Build and maintain ETL solutions using Informatica PowerCenter.

  • Write, troubleshoot, and optimize complex SQL queries.

  • Work with SQL Server and Cassandra/DataStax databases.

  • Support data extraction, transformation, loading, and validation processes.

  • Troubleshoot data pipeline issues and improve data processing performance.

  • Collaborate with technical teams to support data integration and business requirements.

  • Utilize Databricks and/or PySpark for data processing tasks where applicable.

Required Qualifications
  • Strong hands-on experience in ETL development.

  • Expert-level SQL skills, including complex queries and query optimization.

  • Strong experience with Informatica PowerCenter.

  • Hands-on experience with SQL Server.

  • Hands-on experience with Cassandra/DataStax.

  • Ability to troubleshoot and optimize ETL workflows and database processes.

  • Must be authorized to work as a U.S. Citizen or Green Card holder.

## Preferred Qualifications
  • Experience with Databricks and/or PySpark.

  • Experience with Oracle and/or DB2.

  • Strong analytical, problem-solving, and troubleshooting skills.

## Work Details

Location: North Chicago, IL

Work Schedule: 100% onsite

Employment Type: Contract-to-hire

Contract Period: 12 months, potentially longer

Start Date: Immediate

Interview Process: Two online interviews; a third onsite interview may be required.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Onsite ETL Engineer – PowerCenter & Databricks (Contract-to-Hire)
Onsite ETL Engineer – PowerCenter & Databricks (Contract-to-Hire)

TheCorporate LLC • North Chicago (IL)

On-site
USD 90,000 - 120,000
ETL Engineer
ETL Engineer

Valiant Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 150,000
ETL Engineer
ETL Engineer

Ethereum Technologies LLC • Columbia (SC)

On-site
USD 95,000 - 135,000
ETL Developer
ETL Developer

Ethereum Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 130,000
ETL Developer
ETL Developer

Valiant Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000
ETL Engineer
ETL Engineer

Quantum Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 140,000
ETL Developer
ETL Developer

Robotic Process Automation LLC • Santa Ana (CA)

On-site
USD 83,000 - 107,000
Data Engineer/ ETL Developer
Data Engineer/ ETL Developer

FedEx Corporation • Honolulu (HI)

On-site
USD 69,640 - 94,221
ETL Developer
ETL Developer

Ethereum Technologies LLC • Santa Ana (CA)

On-site
USD 77,000 - 110,000
ETL Architect
ETL Architect

360 IT Professionals • Southfield (MI)

On-site
USD 120,000 - 150,000