ETL DEVELOPER

Zurich; Ciudad de México; Híbrido; MXN 923,000 - 1,293,000; Jornada completa

Descripción de la vacante

A leading global insurance company is seeking a Senior ETL Developer / Lead in Mexico City to guide technical decisions and mentor junior developers. The role involves designing and maintaining ETL workflows, primarily using Informatica PowerCenter, along with optimizing data pipelines. Ideal candidates possess 7+ years of ETL experience and strong leadership skills. This position offers an exciting opportunity to be part of a dedicated data engineering team in a hybrid work environment.

Formación

• 7+ years of ETL experience, focusing primarily on Informatica PowerCenter.
• Strong leadership and mentoring skills with technical teams.
• Proven experience designing and optimizing data pipelines.

Responsabilidades

• Lead and design ETL workflows using Informatica PowerCenter.
• Develop and maintain complex SQL queries.
• Mentor junior ETL developers.

Conocimientos

Informatica PowerCenter

Advanced SQL

Data governance

Agile methodologies

Leadership and mentoring

Herramientas

PostgreSQL

Azure Data Factory

Git

Descripción del empleo

ETL Developer / Lead

Zurich Capability Center is currently hiring 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 & DevOps: Git, CI/CD, Agile methodologies.
• Data Warehousing: Schema design, SCD management, surrogate keys.
• Experience with data quality frameworks, logging, and error handling.
• Strong leadership and mentoring skills, with experience guiding technical teams.

Nice to Have

• Programming in Python or Scala for data processing.
• Experience with orchestration tools such as Apache Airflow.
• Knowledge of Big Data technologies: Spark, Hive, HDFS.
• Experience with Docker/Kubernetes and cloud deployment.
• Familiarity with data cataloging and lineage tools (Collibra, Alation).
• Advanced English (C1) for technical communication, documentation, and leadership discussions.

Ideal Candidate Profile

• 7+ years of ETL experience, with Informatica PowerCenter as the primary tool.
• Proven experience designing and optimizing data pipelines at scale.
• Experience providing technical leadership and mentoring junior team members.
• Ability to work in hybrid on-premise and cloud environments.
• Strong focus on data quality, governance, and documentation.
• Experience working in cross‑functional teams using Agile methodologies.

If you are interested, please apply directly through this link or send your resume to [e-mail].

Position available only for candidates located in Mexico. Please apply only if you reside in one of these areas.

Who we are

Looking for a challenging and inspiring work environment where you can make a difference? At Zurich millions of individuals and businesses place their trust in our products and services every day. Our 53,000 employees worldwide form the basis of our success, enabling, businesses and communities to face a world of risk with confidence. Imagine if you could help people do this all over the world. You’d give them confidence and reassurance by protecting what they love most. It’s a big challenge, but you will be supported by a world‑class team who believe in helping you to reach your full potential and deliver on our promises.

So be challenged. Be inspired. Help us make a difference.

At Zurich we are an equal opportunity employer. We attract and retain the best qualified individuals available, without regard to race/ethnicity, religion, gender, sexual orientation, age, or disability.