JOB DESCRIPTION
JOB SUMMARY
The ERP Administrator (Integrations) is responsible for administering, designing, implementing, and managing secure reliable, scalable system-to-system data integrations across the enterprise. This role develops and enforces data governance and building Extract, Transform, Load (ETL) processes, Application Programming Interface (API) based integrations, and real-time and batch data exchanges to ensure consistent, accurate, and compliant data flows between internal platforms and external systems.
ESSENTIAL DUTIES & RESPONSIBILITIES
Integration Development and Support
- Administrates, designs, develops, and maintains application-to-application integrations using APIs Representational State Transfer/Simple Object Access Protocol (REST/SOAP), file-based interfaces Secure File Transfer Protocol/File Transfer Protocol (SFTP/FTP), and database connections.
- Builds and supports ETL processes to extract, transform, and load data between systems using SQL and integration tooling.
Develops and consumes RESTful APIs and web services using standard data formats JavaScript Object Notation (JSON), Extensible Markup Language (XML).
- Implements data mappings, transformations, and validation rules to ensure accuracy, consistency, and reliability of exchanged data.
- Writes and optimizes Structured Query Language (SQL) queries, stored procedures, and data extraction logic in support of integrations.
Collaborates with functional teams, analysts, and application owners to translate business requirements into technical integration solutions.
Troubleshoots and resolves integration defects, data issues, and interface failures.
- Creates and maintains technical documentation, including interface specifications, data mappings, integration flow diagrams, configuration workbooks, design documents, and knowledge materials.
- Supports testing activities, including unit, system, and regression testing, for integration solutions.
- Ensures integrations follow security, data governance, and coding standards.
- Demonstrates working knowledge of Public Key Infrastructure (PKI), including certificate-based. authentication used by platforms such as Kubernetes.
Demonstrates familiarity with event driven messaging.
Problem Solving and Analytical Skills
REQUIREMENTS
- Bachelor of Science degree or two years of certified technical IT training as identified in job posting supplement, or relevant, equivalent experience and/or education.
- Minimum of three (3) years of experience in application integration, ETL development, or system-to-system data exchange
- Must possess sound research and analytical problem-solving capabilities.
- Strong communication skills with the ability to convey complex issues to non-technical colleagues.
- Positive attitude towards collaboration.
- Willingness to work in a fast-paced, high-intensity environment, which may require longer hours.
- Working knowledge of the systems detailed within the duties and responsibilities.
- Ability to multitask and balance workload based on business priorities.
- Ability to work with minimal supervision.
- Participates in 24/7 support of the supported systems.
Applicants must be authorized to work in the United States for any employer. ITC does not sponsor employment visas, such as H-1B or TN visas.
Supplement: Additional Responsibilities and Qualifications
- Experience supporting CI/CD pipelines using Git-based workflows
- Experience with integration tools like IBM CP4I or Oracle ODI
- Familiarity with Linux
- Familiarity with common scripting languages like Python, Bash, PowerShell used to support integrations
- Familiarity with Containerized or orchestrated environments (examples Kubernetes, Docker, OpenShift, Ansible, YAML and related platform related tools)
