Role: Data Migration & Integration Lead
Location: Remote
Type: Contract
Description
Senior Techno-Functional Analyst supporting the Siebel / Java-to-IEEW SaaS transformation
Requirements and legacy analysis
Translate business needs into specifications.
Reverse engineer application logic and assess upstream/downstream impacts.
Data architecture and mapping
Own source-to-target mappings, entity relationships and master/reference data rules, with field-level lineage.
Migration and interface design
Define full/delta loads, sequencing and ETL/API dependencies.
Plan mock migrations, recovery and cutover execution.
Data quality and reconciliation
Establish SQL-based profiling, control totals and business-rule validation.
Trace exceptions through to root-cause resolution.
Technical delivery ownership
Maintain mappings, runbooks and test evidence.
Coordinate readiness with business SMEs, middleware and Syncron.
CORE EXPERTISE
- Advanced SQL and Oracle PL/SQL
- Relational data modeling
- ODI and Kettle ETL
- REST APIs and JSON/XML
- SFTP, DB links and middleware
- Data Lake lineage
- Migration testing
- Reconciliation controls
EXPECTED OUTCOME
Accurate, traceable migration with validated business rules and fewer transition defects.