ETL DEVELOPER

Overview

Zurich Capability Center is hiring a Senior ETL Developer / Lead with extensive experience in Informatica PowerCenter to join our data engineering team. You will build, optimize, and integrate robust data pipelines, guide technical decisions, and mentor junior team members, ensuring high-quality, scalable, and reliable data for BI and analytics initiatives. You will collaborate with data architects, analysts, and DevOps teams to drive best practices across the organization.

Responsibilities

• Lead the design, implementation, and maintenance of ETL workflows using Informatica PowerCenter for data ingestion, transformation, and loading.
• Develop and optimize complex SQL queries, including CTEs, joins, and window functions, ensuring optimal performance.
• Integrate data from multiple sources: relational databases, APIs, flat files, and cloud-based systems.
• Provide technical leadership in ETL design and implementation, ensu...