ETL Engineer

Thecorporate; North Chicago (IL); Presencial; USD 85.000 - 110.000; Jornada completa

Descripción de la vacante

Thecorporate is seeking an experienced ETL Engineer in North Chicago, IL for a 12-month contract-to-hire. The role focuses on building, maintaining, and optimizing ETL pipelines using SQL, Informatica PowerCenter, and related technologies. Immediate start with potential transition to a permanent position after the contract.

You will work onsite five days a week, collaborate with data teams on complex environments, and ensure data quality and performance across databases.

Formación

• Hands-on experience designing and supporting ETL pipelines.
• Strong SQL skills with complex query optimization.
• Experience with data integration, transformation, and data quality.

Responsabilidades

• Develop, maintain, and optimize ETL processes for large data environments.
• Collaborate with stakeholders to translate requirements into data solutions.
• Troubleshoot performance issues and ensure data quality across systems.

Conocimientos

ETL expertise

SQL

Data integration

Problem-solving

Herramientas

Informatica PowerCenter

Microsoft SQL Server

Cassandra/DataStax

Descripción del empleo

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

• 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.

Preferred Qualifications

• Experience with Databricks.
• Experience with PySpark.
• Knowledge of Oracle and/or DB2 databases.
• Experience optimizing ETL performance and handling large datasets.

Work Location & Interview Process

• 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.

Skills: cassandra,etl,sql,databases