Data Integration Engineer Informatica, Redshift, and IDMC/ Know Manager

Summary: The Data Integration Engineer role focuses on designing and developing ETL/ELT workflows using Informatica Cloud to integrate data into Amazon Redshift. Candidates should possess extensive experience with data integration tools and AWS services. The position is remote and requires a strong understanding of SQL and data management practices. This role is classified as outside IR35.

Key Responsibilities:

• Design and develop ETL/ELT workflows using Informatica Cloud (IDMC) to integrate data from diverse sources into Amazon Redshift.
• 10+ years of experience in data integration/ETL tools, including Informatica PowerCenter and IDMC (IICS/Cloud Data Integration).
• Strong expertise in Amazon Redshift, including schema design, SQL tuning, and workload management.
• Proficiency in writing complex SQL queries and stored procedures.
• Experience with AWS services like S3, Glue, Lambda, and CloudWatch.
• Familiarity with data quality, metadata management, and error handling mechanisms in IDMC.
• Understanding of REST APIs and integration with third-party systems.

Key Skills:

• Informatica Cloud (IDMC)
• Amazon Redshift
• SQL
• AWS services (S3, Glue, Lambda, CloudWatch)
• Data integration/ETL tools
• Data quality and metadata management
• REST APIs

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT