Senior Integrations Engineer

Remote from: LATAM
Annual salary: Undisclosed
Salary information is not provided for this position. Check our Salary Directory to estimate the average compensation for similar roles.
Department: Software Engineering
Employment type: Full Time,
Job posted: 12 Jul 2026
Apply before: 12 Aug 2026
Experience level: Senior
Views / Applies: 35 / 0

Trusted Global Innovator with Human-Centric Approach

AI Summary

This Senior Integrations Engineer role is fully remote in LATAM, working EST hours, for a 1-year assignment with potential extension. The position focuses on designing and operating enterprise data pipelines using Informatica IDMC, feeding the Databricks Lakehouse, and applying AI-assisted development with CLAIRE GPT. Key responsibilities include migrating PowerCenter workloads, building ingestion pipelines, and maintaining integration infrastructure on Azure and AWS. The role requires deep expertise in Informatica IDMC, Databricks integration, and cloud-agnostic environments.

Role DNA

Job Complexity

Easy Hard

Pace & Pressure

Relaxed Fast-paced

Autonomy Level

Guided Full Ownership

Communication Load

Independent Highly Collaborative

AI Insight The role requires specialized technical skills in Informatica IDMC, Databricks, and AI-assisted tools, along with migration and optimization tasks, which are complex but not entry-level. The difficulty is high due to the need for deep expertise and independent problem-solving.

Salary Analysis

AI Insight The offered salary is not specified, but for a Senior Integrations Engineer with specialized skills in Informatica and Databricks, the US market range is $110k-$170k, with a median around $145k. Given the remote LATAM location, the actual compensation may be adjusted for cost of living.

Core Skills Required

Informatica IDMC Databricks ETL Data Integration Cloud Data Migration AI-Assisted Development Azure AWS PowerCenter Migration CLAIRE GPT

Cover Letter Sample

Dear Hiring Manager,

I am excited to apply for the Senior Integrations Engineer position at NTT DATA. With over 8 years of experience in data integration and a strong focus on Informatica IDMC and Databricks, I am confident in my ability to design and operate enterprise pipelines that drive business value. My expertise includes migrating PowerCenter workloads to IDMC, building ELT pipelines into Databricks Lakehouse, and leveraging AI-assisted tools like CLAIRE GPT to accelerate delivery.

In my previous role at a global tech firm, I led a team in migrating 50+ pipelines to IDMC, reducing time-to-delivery by 30% using CLAIRE Copilot. I am proficient in cloud platforms such as Azure and AWS, and I have a solid understanding of FinOps to optimize costs. I thrive in remote, fast-paced environments and am eager to contribute to NTT DATA's innovative projects.

Thank you for considering my application. I look forward to discussing how my skills align with your team's goals.

Sincerely,
[Your Name]

Sample Interview Questions

Can you describe your experience with Informatica IDMC, particularly in designing and implementing complex data pipelines using CDI and CMI?

I have over 5 years of experience with Informatica IDMC, including designing Cloud Data Integration (CDI) mappings with SQL ELT pushdown optimization, dynamic mappings, and taskflows. I have also used Cloud Mass Ingestion (CMI) for batch and near-real-time ingestion from various sources such as databases, files, and APIs. For example, in my last role, I built a pipeline ingesting streaming data from Kafka into Databricks using CMI, achieving sub-minute latency.

How do you approach migrating PowerCenter workloads to IDMC? Describe the methodology and any accelerators you've used.

I follow a structured methodology starting with an assessment of existing PowerCenter mappings to identify dependencies and complexity. Then I use CDI-PC (PowerCenter to IDMC) accelerator tools to automate conversion of mapping logic. I also perform validation by comparing row counts and data quality between source and target. In one project, I migrated 200+ mappings in 6 months, using a phased approach to minimize business disruption.

Explain how you integrate IDMC with Databricks Lakehouse, particularly with Delta Lake and SQL ELT pushdown.

I use IDMC for Databricks connector to ingest and load data into Delta tables. For SQL ELT pushdown, I configure mappings to push transformation logic to Databricks SQL, leveraging Spark's distributed processing for performance. I also use Delta Lake load patterns such as merge and insert overwrite to handle incremental updates. In a recent project, I optimized a batch load from 2 hours to 15 minutes using pushdown optimization.

How have you used AI-assisted tools like CLAIRE GPT or Copilot in your data integration work?

I have used CLAIRE Copilot to auto-generate mapping logic based on natural language descriptions, which reduced initial development time by 40%. For debugging, I use CLAIRE GPT to analyze transformation errors and suggest corrections. I also use it to automatically document pipeline metadata, ensuring compliance and ease of maintenance.

Describe your experience with cloud platforms (AWS, Azure, GCP) in the context of data integration, particularly with Informatica Secure Agents and runtime environments.

I have deployed and managed Secure Agents on both AWS and Azure, setting up Secure Agent Groups for load balancing and high availability. I have experience with cost optimization by right-sizing agent instances and using spot instances for non-production workloads. For example, on Azure, I configured auto-scaling of Secure Agents based on pipeline queue depth, reducing costs by 20% while maintaining SLA.

Job Title: Senior Integrations Engineer
Location Preference: 100% remote in LATAM with preference in Chile working EST Time Zone
Duration: 1-Year Assignment with possibility of extension

NTT DATA is a team of more than 139,000 diverse professionals operating in more than 50 countries worldwide. Our sectors of activity include telecommunications, finance, industry, utilities, energy, public administration, and health.

Our mission? Offer technological solutions, business, strategy, development, and application maintenance while being a benchmark in consulting. Thanks to the collaboration between teams, the human quality of our people, and the fact that we do not conform to what is established, we always seek innovation that brings us closer to the future.

Our essence has led us to the forefront of technology, breaking paradigms and providing solutions that truly respond to each client’s needs. Our talent has led us to be one of the top six technology companies in the world.

Because #Greattech, needs #GreatPeople, like you

NTT Data seeks high-achieving team players who quickly adapt to new challenges and entrepreneurial ventures. We are looking for a Senior Integrations Engineer to work with our global client for a fully remote opportunity in LATAM working EST hours.

Position Summary

Data integration engineer specialized in designing, developing, and operating enterprise data pipelines on ETL tools; Informatica IDMC (Intelligent Data Management Cloud / IICS) as the primary platform, with strong capabilities in feeding the Databricks Lakehouse. Able to work across cloud-agnostic environments (Azure, AWS, GCP) and to apply AI-assisted development with CLAIRE GPT and CLAIRE Copilot to accelerate the build cycle and reduce time-to-delivery.

Key Responsibilities

Design and implement ingestion, transformation, and distribution pipelines with CDI and Cloud Mass Ingestion.
Build and optimize ingestion and ELT into the Databricks Lakehouse using IDMC for Databricks and Delta Lake patterns.
Migrate PowerCenter workloads to IDMC using structured methodology and internal accelerators.
Operate and maintain integration infrastructure (Secure Agents, runtimes) on Azure and AWS under SLA standards.
Apply CLAIRE GPT/Copilot to optimize the mapping development cycle and reduce delivery time.

Requirements

Technical Skills:

Informatica IDMC · Integration Core
- Cloud Data Integration (CDI): Mapping Designer, SQL ELT with pushdown optimization (full/source/target), Taskflows, mapping partitioning, Dynamic Mappings, parameterization, file listeners, intelligent structure models (CLAIRE-powered), and performance tuning.
- Cloud Mass Ingestion (CMI): batch and near-real-time ingestion from heterogeneous sources across its variants: Mass Ingestion Databases (CDC), Files, Applications, and Streaming.
- Cloud Application Integration (CAI): Process Designer, service connectors, guides, and business processes; API and microservices integration.
- PowerCenter to IDMC: migration and modernization of on-premises pipelines using structured methodology, CDI-PC, and migration accelerators.
- Platform operations: administration of Secure Agents and runtime environments (Secure Agent Groups), monitoring, and SLA management.
Databricks Integration
- IDMC for Databricks: ingestion and ELT into the Databricks Lakehouse with CDI and Cloud Mass Ingestion, Delta Lake load patterns, and SQL ELT pushdown to Databricks SQL.
- Connectivity through the Databricks connector (Partner Connect), Unity Catalog awareness, and parameterized job orchestration.
AI-Assisted Development (CLAIRE)
- CLAIRE GPT / CLAIRE Copilot: assisted generation of mappings, debugging of transformations, and automatic pipeline documentation through natural language within IDMC.
- Awareness of the new agentic capabilities (CLAIRE Agents, Fall 2025 release) for headless ingestion and transformation flows.
Platform FinOps
- Understanding of the IPU (Informatica Processing Units) consumption model and per-service cost optimization.
Cloud-Agnostic (Complementary)
- Azure: Azure Data Factory (ADF), Data Lake Storage Gen2, Key Vault, Azure Databricks.
- AWS: Glue, S3, Step Functions, Redshift, Athena, EventBridge.
- GCP (desirable): BigQuery, Cloud Composer.
- IaC & CI/CD for pipelines: Terraform, CloudFormation; GitHub/Bitbucket, Jenkins.
Databases & Platforms
- Advanced SQL (Oracle, SQL Server, PostgreSQL, Redshift, Databricks SQL).
- NoSQL (MongoDB, DynamoDB; desirable).
- Data Warehouse, Data Lake, and Lakehouse architecture patterns.

Certifications:

Informatica Cloud Data Integration Developer, Professional Certification (ICP) (core to the role).
Informatica Cloud Application Integration Developer, Professional Certification (desirable).
Informatica IDMC Foundation / Data Engineering Foundation.
Databricks Certified Data Engineer Associate (desirable).
Microsoft Certified: Azure Data Engineer Associate (DP-203) (complementary).
AWS Certified Data Engineer / Data Analytics Specialty (complementary).

Why NTT Data?

Empowerment and rewards are the cornerstone of our career development model. We are a young, fast-growing company, with a highly innovative and entrepreneurial spirit, because of this professional experience and growth will be unmatched. Our talent and positive attitude allow us to transform our goals into achievements, and projects into realities.

NTT Data is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. NTT Data is an Equal Opportunity Employer Male/Female/Disabled/Veteran and a VEVRAA Federal Contractor.

Apply now >