Oliver James Associates - Data Functional Analyst
Core
Bridge the gap between legacy Mainframe business logic and modern PostgreSQL database architecture during a system migration.
Role type
Data Functional Analyst
Builds
Data mappings, functional specifications, and reconciliation strategies for legacy-to-relational migration
Domain
Enterprise data migration, Mainframe to PostgreSQL
Required skills
Data mapping, PostgreSQL, SQL, relational data modelling, data validation, data reconciliation, data lineage documentation, cross-functional collaboration
Preferred skills
Adabas, Mainframe database environments
Technologies
PostgreSQL, Adabas, Mainframe
Responsibilities
Define data mappings from Mainframe to PostgreSQL, write functional specifications for ETL/ELT pipelines, execute cross-database reconciliation checks, maintain data dictionaries and lineage documentation, resolve legacy data ambiguities
Seniority
Mid-level, hands-on IC
