Data Engineer
Job in
Saint Paul, Ramsey County, Minnesota, 55199, USA
Listed on 2026-06-12
Listing for:
TALENT Software Services
Full Time
position Listed on 2026-06-12
Job specializations:
-
IT/Tech
Data Engineering, Data Analyst, Data Warehousing, Database Administrator
Job Description & How to Apply Below
- 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
- 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
- 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
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×