Senior Integrations Engineer

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) (complem