LT Data Integration Engineer + English
About the company
At Ready We are looking for an LT Data Integration Engineer with experience in the design, development, and operation of enterprise data integration solutions using Informatica Intelligent Data Management Cloud (IDMC) as the primary platform. You will be responsible for building, optimizing, and managing data pipelines to feed Databricks Lakehouse, ensuring scalable, efficient solutions aligned with business needs.
Your tasks
- Design, develop, and implement ingestion, transformation, and data distribution pipelines using Cloud Data Integration (CDI) and Cloud Mass Ingestion (CMI).
- Build and optimize ETL/ELT processes toward Databricks Lakehouse using IDMC for Databricks and Delta Lake patterns.
- Migrate processes developed in PowerCenter to Informatica IDMC using structured methodologies and migration accelerators.
- Manage and maintain integration infrastructure (Secure Agents and Runtime Environments), ensuring compliance with established SLAs.
- Implement integrations via Cloud Application Integration (CAI) for APIs, business processes, and microservices.
- Apply CLAIRE GPT and CLAIRE Copilot to accelerate development, debugging, and automatic pipeline documentation.
- Monitor Informatica Processing Units (IPU) consumption and propose cost and performance improvements.
- Collaborate with multidisciplinary teams to ensure the availability, quality, and scalability of integration solutions.
Long-term project focused on strategic analysis and operations optimization.
Requirements
The ideal candidate has experience with ETL/ELT tools, cloud environments (Azure, AWS, and preferably GCP), and AI-assisted development using CLAIRE GPT and CLAIRE Copilot.
Technical Knowledge
- ## Informatica IDMC
- ## Cloud Data Integration (CDI).
- ## Mapping Designer.
- ## SQL ELT with Pushdown Optimization.
- ## Taskflows.
- ## Mapping Partitioning.
- ## Dynamic Mappings.
- ## Parameterization.
- ## File Listeners.
- ## Intelligent Structure Models.
- ## Performance Tuning.
- ## Cloud Mass Ingestion (CMI):
- ## Mass Ingestion Databases (CDC).
- ## Files.
- ## Applications.
- ## Streaming.
- ## Cloud Application Integration (CAI).
- Administration of Secure Agents and Runtime Environments.
- ## Migration from PowerCenter to IDMC.
Databricks
- Integration of IDMC with Databricks Lakehouse.
- ## Delta Lake.
- ## Databricks SQL.
- ## Databricks Connector (Partner Connect).
- ## Knowledge of Unity Catalog.
- ## Orchestration of parameterized processes.
AI-assisted development
- Experience using CLAIRE GPT and CLAIRE Copilot.
- Knowledge of CLAIRE Agents (desirable).
Azure
- ## Azure Data Factory (ADF).
- ## Azure Data Lake Storage Gen2.
- ## Azure Key Vault.
- ## Azure Databricks.
AWS
- ## Glue.
- ## S3.
- ## Step Functions.
- ## Redshift.
- ## Athena.
- ## EventBridge.
Desirable GCP
- ## BigQuery.
- ## Cloud Composer.
Infrastructure as Code (IaC) and CI/CD
- ## Terraform.
- ## CloudFormation.
- ## GitHub or Bitbucket.
- ## Jenkins.
Databases
- Advanced SQL (Oracle, SQL Server, PostgreSQL, Redshift, and Databricks SQL).
- Desirable experience in MongoDB and DynamoDB.
- Knowledge of Data Warehouse, Data Lake, and Lakehouse architectures.
Other Requirements
- ## English B2+ or C1 (indispensable).
- Experience in design, development, and operation of data integration solutions using Informatica IDMC.
- Experience implementing solutions on Databricks.
- Experience working in cloud environments (Azure, AWS, and preferably GCP).
Certifications
- Informatica Cloud Data Integration Developer Professional Certification (ICP). (Required)
- Informatica IDMC Foundation / Data Engineering Foundation. (Desirable)
- Informatica Cloud Application Integration Developer Professional Certification. (Desirable)
- Databricks Certified Data Engineer Associate. (Desirable)
- Microsoft Certified: Azure Data Engineer Associate (DP-203). (Desirable)
- AWS Certified Data Engineer or Data Analytics Specialty. (Desirable)
Other
Position Conditions
- Contract modality: Freelance (Contractor). 100% Remote LATAM
- Working hours: Full-time, Monday to Friday, 9:00 a.m. to 6:00 p.m. (Chile Time)
- Contract duration: 12 months with possibility of renewal.