ETL Engineer - Informatica/IICS Specialist

Salesforce; Ciudad de México; Hybrid; MXN 420,000 - 700,000; Full time

Job summary

Salesforce is seeking an ETL Software Engineer to build and maintain data integration pipelines connecting Salesforce, Snowflake, and other sources. You will collaborate with data analysts, platform teams, and business stakeholders to design mappings and troubleshoot pipelines.

This hybrid Mexico City role requires hands-on experience with Informatica/IICS, MuleSoft, Snowflake, and Airflow, plus Python and SQL.

Qualifications

• 3–5 years of experience in ETL development or data engineering.
• Hands-on experience with MuleSoft or Informatica/IICS.
• SQL and Python for data transformation.
• Experience with Snowflake data warehouses.
• Familiarity with Airflow for workflow orchestration.
• Understanding DEV/QA/STG/PRD promotions and basic version control (GitHub).
• Strong troubleshooting skills and cross-functional collaboration.

Responsibilities

• Design, build, and maintain ETL mappings and workflows using Informatica/IICS to move and transform data across source and target systems
• Develop and support Python-based ETL scripts (Pandas, NumPy, PySpark) for data transformation and automation needs
• Monitor and troubleshoot scheduled data pipeline jobs (e.g., Airflow DAGs), diagnosing failures and coordinating fixes with platform/infrastructure teams
• Manage and validate API user connections and credentials across environments (DEV, QA, STG, PRD) for integrated systems
• Create and maintain Snowflake database objects, roles, and RBAC needed to support pipeline read/write operations
• Perform data quality checks — validating, tagging, and reconciling records across source systems
• Submit and shepherd change requests and deployment pull requests through DEV → QA → STG → PRD promotion, coordinating approvals with release/support teams
• Partner with business and analytics stakeholders to resolve data mapping discrepancies and ensure clean handoffs
• Maintain clear documentation of ETL jobs, connections, and operational runbooks for team knowledge continuity
• Respond to and resolve production support tickets related to ETL job failures, connection issues, or data discrepancies

Skills

ETL development

SQL

Python

Troubleshooting

Documentation

Tools

Informatica/IICS

MuleSoft

Snowflake

Airflow

Tableau

GitHub

Job description

Salesforce is seeking an ETL Software Engineer to build and maintain data integration pipelines connecting Salesforce, Snowflake, and other sources. You will collaborate with data analysts, platform teams, and business stakeholders to design mappings and troubleshoot pipelines.

This hybrid Mexico City role requires hands-on experience with Informatica/IICS, MuleSoft, Snowflake, and Airflow, plus Python and SQL.