A complete application in a minute
Tailored resume and cover letter, ready to send.
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.
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.
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.
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.
Experience with Databricks and/or PySpark.
Experience with Oracle and/or DB2.
Strong analytical, problem-solving, and troubleshooting skills.
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.