Note: The job is a remote job and is open to candidates in USA. TALENT Software Services is seeking a Data Engineer to support a project involving data migration and validation. The role involves analyzing legacy datasets, performing root cause analysis on discrepancies, and collaborating with business stakeholders to ensure data integrity and compliance.
Responsibilities
- Validate migrated data in target systems to ensure that it accurately reflects source Informix data
- Analyze legacy Informix datasets to identify remaining system dependencies and active data usage
- Identify data that was not migrated, is incomplete, or does not match source system values
- Perform root cause analysis on data discrepancies and failed or incomplete migrations
- Review prior migration strategies, scripts, and processes to assess effectiveness
- Develop and execute plans to migrate remaining required data to modernized systems
- Build comparison queries and reconciliation pipelines across Informix, staging, and production environments
- Confirm whether staging data is sufficient to recreate missing documents and records
- Assess and validate archived data across storage types (e.g., magnetic, optical, paper)
- Collaborate with business SMEs to determine data retention requirements and resolve data gaps
- Document current and future state data architecture, including ERDs and data flow diagrams
- Provide recommendations and support planning activities for Informix system retirement
- Support broader data research and initiatives across the agency as needed
- Provide knowledge transfer and documentation to State staff
- Perform other related duties as assigned
Skills
- Experience designing relational databases and using SQL to interact with data (Informix and/or SQL Server preferred)
- Experience in data migration, validation, and reconciliation for legacy-to-modern system transitions
- Experience reviewing and working with existing ETL/migration scripts and processes
- Experience building ETL/ELT workflows and working with staging vs. production data environments
- Experience performing data analysis and root cause investigation in complex or ambiguous environments
- Experience complying with data quality, data governance, and records retention requirements
- Experience documenting data architecture (e.g., ERDs, data flows)
- Experience managing data within cloud platforms (e.g., Azure)
- Experience using collaboration tools such as Jira and Confluence
- Experience communicating effectively with and working with both technical teams and business stakeholders
Company Overview