Job Title: Software Development Specialist Advisor

Employment Type: Full-Time

Location: Remote in Mexico

ROLE SUMMARY
Technical leadership profile covering the full spectrum of a modern data platform: data engineering with Informatica IDMC and the enablement of analytical and agentic capabilities. Acts as the team’s technical reference, ensures alignment between engineering and governance. Proven experience in financial or highly regulated environments.

REQUIRED TECHNICAL SKILLS
Informatica IDMC · Full Stack

Cloud Data Integration (CDI): mapping and mapping-task design, taskflow orchestration, pushdown optimization, parameterization and reusable assets, hierarchical and complex-file processing, performance tuning, and promotion across Dev/QA/Prod orgs.

Cloud Mass Ingestion (CMI): database, file, application, and streaming ingestion; initial load plus incremental CDC over Oracle, Redshift and SQL; schema-drift handling; and delivery to Amazon S3.

Cloud Application Integration (CAI): process and service-connector design, REST/SOAP API exposure,



and event-driven orchestration for near-real-time integration.

Cloud Data Quality (CDQ): profiling, rule specifications, scorecards, and remediation embedded in the ingestion and delivery pipelines.

IDMC administration: Secure Agent sizing and runtime environment groups, connection and asset management, RBAC, license/IPU consumption monitoring, Operational Insights, and upgrade planning.

AI-accelerated development (desirable): use of AI coding assistants to speed up discovery, profiling, and mapping/SQL and pipeline generation, with AI-generated assets reviewed against naming, reusability, and performance standards under code-review and CI/CD guardrails.

Lakehouse and Serving Layer.

Experience in developing Medallion architecture: design and development of Bronze / Silver / Gold layers raw landing, conformed and deduplicated Silver models with data-quality expectations, and Gold Data Products.

Semantic layer for BI

📌 Senior Data Engineer (México)
🏢 Pyramid Consulting
📍 México