Staff AI-Driven Data Integration Engineer

Worky; City of White Plains (NY); On-site; USD 180,000 - 225,000; Full time

Job summary

FormativGroup is building a focused product team to own the connectors and parsers that power our platform. You will create connectors for legacy ETL platforms, databases, and cloud data systems, and turn extracted data into reliable lineage models.

We operate AI-first and expect you to integrate AI throughout development to speed reverse engineering, coding, testing, and documentation. Candidates must reside in the U.S. and be authorized to work here.

Qualifications

• Strong data engineering, metadata, or systems integration experience.
• Hands-on work with ETL platforms, SQL parsing, data lineage, or transformation logic.
• Experience reverse engineering unfamiliar or poorly documented systems.
• Comfort working in TypeScript and building automated tests.
• Well-versed in AI-assisted software development, embedding AI tools into the development process.
• A bias for shipping quickly, testing thoroughly, and fixing errors rather than explaining them away.

Responsibilities

• Build connectors for legacy ETL platforms, databases, and modern cloud data systems.
• Parse XML, SQL, repository exports, scripts, and vendor-specific formats.
• Turn extracted metadata into accurate lineage and dependency models.
• Create automated tests and known-good datasets to verify connector accuracy.
• Improve the connector framework with our Principal Architect and document reusable patterns.
• Integrate AI into your daily development workflow to accelerate reverse engineering, coding, testing, debugging, and documentation.

Skills

Data engineering

Metadata

Data lineage

ETL platforms

SQL parsing

Reverse engineering

TypeScript

AI in development

Tools

Informatica PowerCenter

DataStage

Talend

SSIS

Job description

FormativGroup is building a focused product team to own the connectors and parsers that power our platform. You will create connectors for legacy ETL platforms, databases, and cloud data systems, and turn extracted data into reliable lineage models.

We operate AI-first and expect you to integrate AI throughout development to speed reverse engineering, coding, testing, and documentation. Candidates must reside in the U.S. and be authorized to work here.