Staff Software Engineer - Data Integration

FormativGroup provides software that helps regulated enterprises understand the impact of migrating from legacy data platforms by creating trusted lineage and dependency maps. The Staff Software Engineer will own connectors and parsers for legacy ETL platforms, databases, and cloud data systems, while building automated tests, improving the connector framework, and using AI throughout the development process.

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

Requirements:

• 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, with demonstrated experience embedding AI tools into the development process rather than using them occasionally
• A bias for shipping quickly, testing thoroughly, and fixing errors rather than explaining them away
• Experience with Informatica PowerCenter, DataStage, Talend, SSIS, or similar platforms
• Knowledge of graph models, OpenMetadata, OpenLineage, compilers, or parsers
• Experience delivering software into regulated or security-reviewed environments