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

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Engineer
ETL Engineer

TheCorporate LLC • North Chicago (IL)

On-site
USD 90,000 - 120,000
Lead Data Engineer
Lead Data Engineer

TechDigital Group • Bethlehem Township (NJ)

Hybrid
USD 150,000 - 210,000
Data Engineer (Onsite Chicago) | ETL, Spark & AWS
Data Engineer (Onsite Chicago) | ETL, Spark & AWS

Robotics Technologies • Chicago (IL)

On-site
USD 90,000 - 110,000
Onsite Databricks Engineer — Lakehouse & ETL Expert
Onsite Databricks Engineer — Lakehouse & ETL Expert

CoSourcing Partners Inc. • Englewood Cliffs (NJ)

On-site
USD 120,000 - 200,000
Data Engineer – Data Integration & Analytics
Data Engineer – Data Integration & Analytics

Talent Management Plus, Inc. • Detroit (IL), Chicago (IL)

On-site
USD 110,000 - 150,000
Senior Data Engineer
Senior Data Engineer

Planet Group (United States) • Irving (TX)

Hybrid
USD 96,000 - 110,000
Data Engineer
Data Engineer

Robotics Technologies • Tampa (FL)

On-site
USD 89,000 - 126,000
Databricks Data Engineer Lead | ETL & Data Lake Expert
Databricks Data Engineer Lead | ETL & Data Lake Expert

ContractStaffingRecruiters.com • Branford (CT)

Remote
USD 80,000 - 110,000
Azure Data Engineer
Azure Data Engineer

Signature IT World • Pennsylvania

Hybrid
USD 120,000 - 150,000
Azure Data Engineer
Azure Data Engineer

Signature IT World • New Jersey

Hybrid
USD 110,000 - 150,000