ETL Data Engineer — Pipelines & Snowflake Expert

Salesforce; Ciudad de México; Presencial; MXN 700.000 - 950.000; Jornada completa

Descripción de la vacante

Salesforce seeks an ETL Software Engineer to build and maintain data pipelines that feed analytics and reporting. You will collaborate with data analysts, platform teams, and business stakeholders to develop mappings, troubleshoot issues, and support data movement between Salesforce, Snowflake, and other sources.

Strong knowledge of Informatica/IICS, Python, and Snowflake, plus Airflow and CI/CD, is valuable in a fast-paced, data-driven environment with emphasis on data quality and deployment

Formación

• 3–5 years of experience in ETL development or data engineering
• Hands‑on experience with an ETL/integration tool (MuleSoft, Informatica/IICS strongly preferred)
• Working knowledge of SQL and a scripting language such as Python for data transformation
• Experience with cloud data warehouses such as Snowflake
• Familiarity with workflow orchestration tools (e.g., Airflow) for monitoring scheduled jobs
• Understanding of environment promotion practices (DEV/QA/STG/PRD) and basic version control (GitHub)
• Strong troubleshooting skills and comfort working directly with cross-functional platform/support teams
• Clear written communication for documenting issues, requesting approvals, and coordinating across teams
• Experience deploying changes via CI/CD deployment pipelines

Responsabilidades

• 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 custom 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 access requests (RBAC) needed to support pipeline read/write operations
• Perform data quality checks — validating, tagging, and reconciling records (e.g., flagging "VALID"/"INVALID" status) 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

Conocimientos

SQL

Python

Data integration

API authentication

Communication

Herramientas

Informatica/IICS

Airflow

Snowflake

MuleSoft

Python

Pandas

NumPy

PySpark

GitHub

CI/CD

Descripción del empleo

Salesforce seeks an ETL Software Engineer to build and maintain data pipelines that feed analytics and reporting. You will collaborate with data analysts, platform teams, and business stakeholders to develop mappings, troubleshoot issues, and support data movement between Salesforce, Snowflake, and other sources.

Strong knowledge of Informatica/IICS, Python, and Snowflake, plus Airflow and CI/CD, is valuable in a fast-paced, data-driven environment with emphasis on data quality and deployment