LT Data Integration Engineer, Inglés

This is a fully remote position, open to applicants in Mexico, +5 more states.

📋 Description

• Design, develop, and implement data ingestion, transformation, and distribution pipelines using Cloud Data Integration (CDI) and Cloud Mass Ingestion (CMI).

• Build and optimize ETL/ELT processes towards Databricks Lakehouse utilizing IDMC for Databricks and Delta Lake patterns.

• Migrate processes developed in PowerCenter to Informatica IDMC using structured methodologies and migration accelerators.

• Manage and maintain the integration infrastructure, including Secure Agents and Runtime Environments, ensuring compliance with SLAs.

• Implement integrations via Cloud Application Integration (CAI) for APIs, business processes, and microservices.

• Leverage CLAIRE GPT and CLAIRE Copilot to accelerate the development, debugging, and automatic documentation of pipelines.

• Monitor the consumption of Informatica Processing Units (IPU) and propose enhancements in cost and performance.

• Collaborate with multidisciplinary teams to ensure the availability, quality, and scalability of integration solutions.

⛳️ Requirements

• Experience in designing, developing, and operating enterprise data integration solutions using Informatica IDMC.

• Experience implementing solutions on Databricks.

• Experience working in cloud environments such as Azure, AWS, and preferably GCP.

• Knowledge of Informatica IDMC Cloud Data Integration (CDI), Mapping Designer, SQL ELT with Pushdown Optimization, Taskflows, Mapping Partitioning, Dynamic Mappings, Parameterization, File Listeners, Intelligent Structure Models, and Performance Tuning.

• Familiarity with Cloud Mass Ingestion (CMI), including databases with CDC, files, applications, and streaming.

• Understanding of Cloud Application Integration (CAI).

• Administration of Secure Agents and Runtime Environments.

• Migration experience from PowerCenter to IDMC.

• Integration of IDMC with Databricks Lakehouse, Delta Lake, Databricks SQL, Databricks Connector, and Unity Catalog.

• Orchestration of parameterized processes.

• Experience using CLAIRE GPT and CLAIRE Copilot; knowledge of CLAIRE Agents is a plus.

• Familiarity with Azure Data Factory, Azure Data Lake Storage Gen2, Azure Key Vault, and Azure Databricks.

• Knowledge of AWS Glue, S3, Step Functions, Redshift, Athena, and EventBridge.

• GCP BigQuery and Cloud Composer knowledge is desirable.

• Proficiency in Terraform, CloudFormation, GitHub or Bitbucket, and Jenkins.

• Advanced SQL skills in Oracle, SQL Server, PostgreSQL, Redshift, and Databricks SQL.

• Preferred experience with MongoDB and DynamoDB.

• Understanding of Data Warehouse, Data Lake, and Lakehouse architectures.

• English proficiency at B2+ or C1 level is essential.

• Informatica Cloud Data Integration Developer Professional Certification (ICP) is required.

• Informatica IDMC Foundation / Data Engineering Foundation is desirable.

• Informatica Cloud Application Integration Developer Professional Certification is a plus.

• Databricks Certified Data Engineer Associate is preferred.

• Microsoft Certified: Azure Data Engineer Associate (DP-203) is desirable.

• AWS Certified Data Engineer or Data Analytics Specialty is a plus.

🏝️ Benefits

• Freelance contract (Contractor).

• 100% remote for LATAM.

• Full-time work schedule, Monday to Friday, from 9:00 a.m. to 6:00 p.m. (Chile time).

• 12-month contract with the possibility of renewal.