Etl Developer

Zurich Insurance Company; Xico; Presencial; MXN 400,000 - 600,000; Jornada completa

Descripción de la vacante

A leading insurance firm in Veracruz, Xico is seeking a Senior ETL Developer / Lead to join their data engineering team. This role requires extensive experience with Informatica PowerCenter and advanced SQL skills. You will be responsible for designing and implementing ETL workflows, mentoring junior developers, and ensuring data quality. Collaborating closely with various teams, your contributions will be critical to data governance and analytics initiatives. This opportunity promises a pivotal role in enhancing data capabilities within the organization.

Formación

• Extensive experience with Informatica PowerCenter is mandatory.
• Strong SQL skills with expertise in complex queries and performance tuning.
• Experience with cloud data platforms is preferred.

Responsabilidades

• Lead the design and implementation of ETL workflows using Informatica PowerCenter.
• Develop and optimize complex SQL queries.
• Integrate data from multiple sources including APIs and flat files.
• Provide mentorship to junior developers and ensure code quality.
• Monitor and improve ETL job performance.

Conocimientos

Informatica PowerCenter

Advanced SQL

ETL Design

Data Governance

Mentoring and Leadership

Herramientas

Talend

SSIS

PostgreSQL

SQL Server

Oracle

MySQL

Azure Data Factory

Databricks

Descripción del empleo

#ZCC Zurich Capability Center is currently hiring a : ETL Developer / Lead

We are looking for a Senior ETL Developer / Lead with extensive experience in Informatica PowerCenter to join our data engineering team.

In this role, you will not only build, optimize, and integrate robust data pipelines but also guide technical decisions and mentor junior team members, ensuring high-quality, scalable, and reliable data for BI and analytics initiatives.

You will collaborate closely 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, ensuring adherence to best practices and standards.

Mentor and support junior ETL developers, reviewing code, providing guidance, and promoting skill development.

Monitor, troubleshoot, and improve ETL jobs to ensure reliability and efficiency.

Apply data governance practices and ensure data quality, implementing logging and error handling.

Collaborate with business and technical teams to translate requirements into robust ETL solutions.

Document data flows and maintain data warehouse standards (star / snowflake schema, SCDs, surrogate keys).

Participate in strategic planning for data architecture, pipeline design, and performance optimization.

Technical Requirements

ETL Tools : Informatica PowerCenter (mandatory); experience with Talend or SSIS is a plus.

Advanced SQL : CTEs, joins, window functions, and performance tuning.

Databases : PostgreSQL, SQL Server, Oracle, or MySQL.

Cloud Data Platforms : Azure Data Factory, Databricks.

Version Control