Description

You will design and support ETL workflows to exchange data between CMMS, APM, and SaaS platforms.

Responsibilities

• Configure secure connections to Oracle EAM using APIs, RFCs, service buses, JSON, or third-party connectors.
• Integrate SaaS applications with APM systems, managing credentials and validating data via APM Connect.
• Troubleshoot APM Connect architecture, including server-side services, staging databases, and credential vaults.
• Execute basic SQL queries to validate data integrity during integration testing.
• Configure APM to store CMMS credentials and ensure correct PLA SaaS data synchronization.

Required Skills

• 5+ years of experience in Information Technology, specifically in integration support.
• Working knowledge of databases and SQL.
• Experience with ETL concepts; Boomi experience is preferred.
• Knowledge of CMMS and APM systems and their interoperability.
• Understanding of secure networking, including SFTP, firewall management, and port configuration.
• Ability to troubleshoot integration issues across cloud and on-premise environments.
• Familiarity with SaaS platforms and integration requirements.
• Knowledge of IT security practices for credential handling and data validation.
• Exposure to cloud-native integration patterns and SaaS architecture.

Key Skills

Education

Bachelor's degree