What are the responsibilities and job description for the ETL Engineer position at TheCorporate?
Location: North Chicago, IL
Work Arrangement: 100% Onsite
Employment Type: Contract-to-Hire
Contract Duration: 12 months, with the possibility of extension
Client Type: Direct Client
Start Date: Immediate
Interview Process: Two virtual interviews and potentially one onsite interview
Job Summary
We are seeking an experienced ETL Engineer with strong expertise in SQL, Informatica PowerCenter, and database technologies. The ideal candidate will have hands-on experience developing, maintaining, and optimizing ETL processes and working with complex data environments.
This is an excellent opportunity to work directly with the end client in North Chicago, IL, with an immediate start and a potential transition to a permanent position after the contract period.
Required Qualifications
Work Arrangement: 100% Onsite
Employment Type: Contract-to-Hire
Contract Duration: 12 months, with the possibility of extension
Client Type: Direct Client
Start Date: Immediate
Interview Process: Two virtual interviews and potentially one onsite interview
Job Summary
We are seeking an experienced ETL Engineer with strong expertise in SQL, Informatica PowerCenter, and database technologies. The ideal candidate will have hands-on experience developing, maintaining, and optimizing ETL processes and working with complex data environments.
This is an excellent opportunity to work directly with the end client in North Chicago, IL, with an immediate start and a potential transition to a permanent position after the contract period.
Required Qualifications
- Strong hands-on experience as an ETL Engineer or in a similar data engineering role.
- Expert-level SQL skills with the ability to write and optimize complex queries.
- Strong practical experience with Informatica PowerCenter.
- Hands-on experience with Microsoft SQL Server.
- Required experience with Cassandra/DataStax.
- Solid understanding of ETL concepts, data integration, data transformation, and data quality.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to work onsite five days a week in North Chicago, IL.
- Experience with Databricks.
- Experience with PySpark.
- Knowledge of Oracle and/or DB2 databases.
- Experience optimizing ETL performance and handling large datasets.
- Location: North Chicago, Illinois.
- Work Arrangement: 100% onsite; remote or hybrid work is not available.
- Contract: 12 months, contract-to-hire, with the possibility of a longer duration.
- Interviews: Two online interviews, followed by a potential onsite interview.
- Availability: Candidates who can start immediately are preferred.