Data Engineer — Wilmington, DE

The client is looking for a Senior Data Engineer with strong, hands-on Informatica IICS experience, especially in ETL development, data integration, SQL, and data transformation.

The most important requirement is that Informatica IICS must be the candidate's primary ETL tool, not just a technology they have basic exposure to.

1. What exactly is the client looking for?

The candidate should be able to:

• Develop ETL pipelines: Use Informatica IICS to extract data from different sources, transform it, and load it into target databases or data warehouses.

• Data Integration: Connect multiple systems and databases and build reliable data integration workflows.

• SQL & Database: Write strong SQL queries, perform joins, handle complex transformations, and work with relational databases.

• Data Transformation: Handle large datasets, data cleansing, mapping, validation, and transformation.

• ETL Performance: Optimize ETL workflows to improve performance and processing speed.

• Troubleshooting: Monitor data pipelines, identify failures, debug issues, and maintain data quality.

• Documentation: Prepare technical documentation and collaborate with data architects and analysts.

2. Must-have skills (highest priority)

Informatica IICS

Top priority

• Hands-on experience developing ETL workflows using Informatica Intelligent Cloud Services (IICS).

• Experience with mappings, transformations, and task flows.

• SQL & Relational Databases

• Strong SQL query writing.

• Database design and data modeling.

• Data Engineering

• ETL/ELT processes.

• Data integration, cleansing, transformation.

• Large datasets and data quality.

• Experience

• 7+ years of experience in Data Engineering or a related field.