• Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role.
Mexico Jobs Expertini

ETL DEVELOPER Job Opening In Lomas de Sotelo – Now Hiring Zurich Insurance Company


Job description

#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 & 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.
  • 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

    Required Skill Profession

    Computer Occupations


    • Job Details

    Related Jobs

    Arrow Components Mexico S.A. de C.V. hiring ETL Developer Job in Tlaquepaque, Jalisco, Mexico
    Arrow Components Mexico S.A. de C.V.
    Tlaquepaque, Jalisco, Mexico
    Zurich hiring ETL DEVELOPER Job in WorkFromHome, Ciudad de México, Mexico
    Zurich
    WorkFromHome, Ciudad de México, Mexico
    Zurich 56 Company Ltd hiring ETL DEVELOPER Job in WorkFromHome, WorkFromHome, Mexico
    Zurich 56 Company Ltd
    WorkFromHome, WorkFromHome, Mexico
    Pyramid Consulting, Inc hiring ETL Developer Job in WorkFromHome, Ciudad de México, Mexico
    Pyramid Consulting, Inc
    WorkFromHome, Ciudad de México, Mexico
    Tata Consultancy Services hiring ETL Developer Job in Región Centro, Jalisco, Mexico
    Tata Consultancy Services
    Región Centro, Jalisco, Mexico
    Zurich Insurance hiring ETL DEVELOPER Job in WorkFromHome, Ciudad de México, Mexico
    Zurich Insurance
    WorkFromHome, Ciudad de México, Mexico
    HCLTech hiring ETL Developer Job in WorkFromHome, Jalisco, Mexico
    HCLTech
    WorkFromHome, Jalisco, Mexico
    Arrow Electronics hiring ETL Developer Job in Tlaquepaque, , Mexico
    Arrow Electronics
    Tlaquepaque, , Mexico
    Arrow Electronics hiring ETL Developer Job in Tlaquepaque, , Mexico
    Arrow Electronics
    Tlaquepaque, , Mexico
    Arrow Electronics hiring ETL Developer Job in Tlaquepaque, Mexico, Mexico
    Arrow Electronics
    Tlaquepaque, Mexico, Mexico
    Arrow Components hiring ETL Developer & Integration Specialist Job in Tlaquepaque, Jalisco, Mexico
    Arrow Components
    Tlaquepaque, Jalisco, Mexico
    Arrow Electronics hiring ETL Developer & Integration Specialist Job in WorkFromHome, Jalisco, Mexico
    Arrow Electronics
    WorkFromHome, Jalisco, Mexico
    Alliance IT Inc. hiring ETL Developer (Ab Initio) Job in WorkFromHome, Jalisco, Mexico
    Alliance IT Inc.
    WorkFromHome, Jalisco, Mexico
    Zurich Insurance Company hiring ETL - SQL IPC Sr Developer Job in Lomas de Sotelo, Ciudad de México, Mexico
    Zurich Insurance Company
    Lomas de Sotelo, Ciudad de México, Mexico
    Axity hiring ETL Developer (Informatica IICS / DataStage) Job in Huixquilucan de Degollado, State of Mexico, Mexico
    Axity
    Huixquilucan de Degollado, State of Mexico, Mexico
    Zurich Insurance hiring ETL - SQL IPC Sr Developer Job in Mexico
    Zurich Insurance
    Mexico
    Zurich 56 Company Ltd hiring ETL - SQL IPC Sr Developer Job in Mexico
    Zurich 56 Company Ltd
    Mexico
    Zurich Insurance Group hiring ETL - SQL IPC Sr Developer Job in Mexico
    Zurich Insurance Group
    Mexico
    Snaphunt hiring ETL Tester Job in Guadalajara, Jalisco, Mexico
    Snaphunt
    Guadalajara, Jalisco, Mexico
    Volto Consulting (IT/Healthcare/Engineering) hiring ETL Tester Job in Mexico City, Federal District, Mexico
    Volto Consulting (IT/Healthcare/Engineering)
    Mexico City, Federal District, Mexico
    Snaphunt hiring ETL Tester Job in Mexico City, Federal District, Mexico
    Snaphunt
    Mexico City, Federal District, Mexico
    Volto Consulting (IT/Healthcare/Engineering) hiring ETL Tester Job in Guadalajara, Jalisco, Mexico
    Volto Consulting (IT/Healthcare/Engineering)
    Guadalajara, Jalisco, Mexico
    Digital Challengers IT hiring Desarrollador de ETL Job in Mexico
    Digital Challengers IT
    Mexico
    Digital Challengers IT hiring Desarrollador de ETL Job in Ciudad Juárez, Ciudad Juárez, Mexico
    Digital Challengers IT
    Ciudad Juárez, Ciudad Juárez, Mexico
    Confidential hiring Software Engineering ETL Job in Mexico City, Mexico City, Mexico
    Confidential
    Mexico City, Mexico City, Mexico
    Digital Challengers IT hiring Desarrollador de ETL Job in México, Mexico, Mexico
    Digital Challengers IT
    México, Mexico, Mexico
    Confidential hiring Software Engineering ETL Job in Mexico
    Confidential
    Mexico
    T-mapp hiring Software Engineering ETL Job in Mexico
    T-mapp
    Mexico
    Digital Challengers IT hiring Desarrollador de ETL Job in Mexico
    Digital Challengers IT
    Mexico
    Link-Worldwide hiring Desarrollador Etl (Iztapalapa) Job in Mexico
    Link-Worldwide
    Mexico
    Digital Challengers IT hiring Desarrollador de ETL Job in México, MX, Mexico
    Digital Challengers IT
    México, MX, Mexico

    Unlock Your ETL DEVELOPER Potential: Insight & Career Growth Guide


    Real-time ETL DEVELOPER Jobs Trends (Graphical Representation)

    Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph here. Uncover the dynamic job market trends for ETL DEVELOPER in Lomas de Sotelo, Mexico, highlighting market share and opportunities for professionals in ETL DEVELOPER roles.

    2737 Jobs in Mexico
    2737
    206 Jobs in Lomas De Sotelo
    206
    Download Etl Developer Jobs Trends in Lomas De Sotelo and Mexico

    Are You Looking for ETL DEVELOPER Job?

    Great news! is currently hiring and seeking a ETL DEVELOPER to join their team. Feel free to download the job details.

    Wait no longer! Are you also interested in exploring similar jobs? Search now: .

    The Work Culture

    An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Zurich Insurance Company adheres to the cultural norms as outlined by Expertini.

    The fundamental ethical values are:

    1. Independence

    2. Loyalty

    3. Impartiapty

    4. Integrity

    5. Accountabipty

    6. Respect for human rights

    7. Obeying Mexico laws and regulations

    What Is the Average Salary Range for ETL DEVELOPER Positions?

    The average salary range for a varies, but the pay scale is rated "Standard" in Lomas de Sotelo. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

    What Are the Key Qualifications for ETL DEVELOPER?

    Key qualifications for ETL DEVELOPER typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. The generic skills are mostly outlined by the . Be sure to check the specific job listing for detailed requirements and qualifications.

    How Can I Improve My Chances of Getting Hired for ETL DEVELOPER?

    To improve your chances of getting hired for ETL DEVELOPER, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

    Interview Tips for ETL DEVELOPER Job Success

    Zurich Insurance Company interview tips for ETL DEVELOPER

    Here are some tips to help you prepare for and ace your ETL DEVELOPER job interview:

    Before the Interview:

    Research: Learn about the Zurich Insurance Company's mission, values, products, and the specific job requirements and get further information about

    Other Openings

    Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.

    Dress Professionally: Choose attire appropriate for the company culture.

    Prepare Questions: Show your interest by having thoughtful questions for the interviewer.

    Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.

    During the Interview:

    Be Punctual: Arrive on time to demonstrate professionalism and respect.

    Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.

    Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.

    Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.

    Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.

    Follow Up: Send a thank-you email to the interviewer within 24 hours.

    Additional Tips:

    Be Yourself: Let your personality shine through while maintaining professionalism.

    Be Honest: Don't exaggerate your skills or experience.

    Be Positive: Focus on your strengths and accomplishments.

    Body Language: Maintain good posture, avoid fidgeting, and make eye contact.

    Turn Off Phone: Avoid distractions during the interview.

    Final Thought:

    To prepare for your ETL DEVELOPER interview at Zurich Insurance Company, research the company, understand the job requirements, and practice common interview questions.

    Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Zurich Insurance Company's products or services and be prepared to discuss how you can contribute to their success.

    By following these tips, you can increase your chances of making a positive impression and landing the job!

    How to Set Up Job Alerts for ETL DEVELOPER Positions

    Setting up job alerts for ETL DEVELOPER is easy with Mexico Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!