ETL Developer with InfoArchive and Archon

Techwaukee; United States; Remote; USD 140,000 - 170,000; Full time

Job summary

Techwaukee seeks an experienced ETL Developer specializing in OpenText InfoArchive and Platform 3 Services (Archon) to lead design, implementation, and modernization of enterprise information archiving and data retirement solutions.

The ideal candidate combines archiving platform expertise with strong database/ETL engineering, robust Java development skills, and leadership to guide a technical team toward successful delivery.

Qualifications

• 5+ years with OpenText InfoArchive (21.x/22.x) and Archon Platform 3.
• Strong experience designing database ETL pipelines with tools like Informatica, Talend, Pentaho, SSIS.
• Advanced SQL and relational DB skills (Oracle, PostgreSQL, SQL Server).
• Solid Java development, REST APIs, Spring/Spring Boot, and integration components.
• Proven experience leading data retirement or decommissioning programs.
• Ability to mentor a technical team and drive delivery outcomes.
• Excellent written and verbal communication for technical and executive audiences.

Responsibilities

• Architect and implement end-to-end OpenText InfoArchive solutions and data ingestion pipelines.
• Lead Archon configuration, integration, and administration across archiving initiatives.
• Define Enterprise Data Retirement strategies and roadmaps.
• Design and optimize ETL workflows to move data from legacy sources into the archive.
• Develop and review Java components, transformations, and API integrations.
• Provide technical leadership, code reviews, and mentoring.
• Collaborate with stakeholders to translate retention requirements into solutions.
• Troubleshoot production issues spanning authentication, storage, schemas, and apps.
• Create architecture docs, runbooks, and status updates for tech and execs.

Skills

ETL design

InfoArchive expertise

Archon Platform 3

SQL proficiency

Java development

REST APIs

Spring/Spring Boot

Leadership

Data retirement

Mentoring

Tools

Informatica

Talend

Pentaho

SSIS

Oracle

PostgreSQL

OTDS

Job description

Position Summary

We are seeking an experienced ETL Developer specializing in OpenText InfoArchive and Platform 3 Services (Archon) to lead the design, implementation, and modernization of enterprise information archiving and data retirement solutions. The ideal candidate combines deep archiving platform expertise with strong database/ETL engineering, robust Java development skills, and the leadership ability to guide a technical team toward successful delivery.

Key Responsibilities

• Architect, design, and implement end-to-end OpenText InfoArchive solutions, including data ingestion pipelines, holdings, SIP generation, retention policies, and content query/retrieval.
• Lead Platform 3 Services (Archon) configuration, integration, and administration across archiving and decommissioning initiatives.
• Define and drive Enterprise Data Retirement (EDR) and legacy application decommissioning strategies and roadmaps.
• Design and optimize database ETL workflows to extract, transform, and load structured/unstructured data from legacy source systems into the archive.
• Develop, review, and maintain Java-based components, custom transformations, and API integrations supporting the archiving platform.
• Provide technical leadership to a team of engineers assigning work, conducting design/code reviews, mentoring, and ensuring adherence to architectural standards.
• Partner with business stakeholders, data owners, and compliance teams to translate retention and regulatory requirements into technical solutions.
• Troubleshoot complex production issues spanning authentication (OTDS), storage/file store provisioning, database schema, and application layers.
• Produce clear architecture documentation, runbooks, and status communications for both technical and executive audiences.

Required Qualifications

• 5+ years of hands-on experience with OpenText InfoArchive (ideally 21.x/22.x) and Platform 3 Services (Archon).
• Strong experience designing and building database ETL pipelines using tools such as Informatica, Talend, Pentaho, SSIS, or equivalent.
• Advanced SQL and relational database skills (Oracle, PostgreSQL, SQL Server); ability to profile source schemas and validate archived data.
• Solid Java development experience, including REST APIs, Spring/Spring Boot, and integration components.
• Proven experience leading application decommissioning / data retirement programs.
• Demonstrated ability to lead and mentor a technical team and own delivery outcomes.
• Excellent communication skills, both written and verbal, with the ability to present to technical teams and non-technical stakeholders.

Preferred Qualifications

• Experience with OTDS authentication, SIP/SIData configuration, and InfoArchive storage (Store/Space/Holding) architecture.
• Cloud experience (AWS preferred) and containerized deployments.
• Familiarity with scripting (Python, Shell) for automation and data validation.
• Background in regulated industries (financial services, healthcare, insurance).
• Relevant certifications (OpenText, AWS Solutions Architect, PMP/SAFe).

Core Competencies

• Enterprise archiving & data retirement strategy
• ETL / data migration engineering
• Java solution development
• Technical team leadership & mentoring
• Stakeholder communication & documentation