AI/ML Data Conversion Specialist

Total Required Experience in Years:15 Years

Mode of Work: Hybrid (Preferred) / Remote (Texas)

Seeking an experienced AI/ML Data Conversion Specialist to support a large-scale pension system modernization initiative. The consultant will be responsible for designing, developing, and executing complex data conversion and migration activities involving legacy pension systems, high-volume data sets, ETL processes, reconciliation, and validation activities.

The ideal candidate will have strong expertise in SQL Server, SSIS, BIML scripting, T-SQL development, data migration, and conversion automation within highly governed enterprise environments. This role requires close collaboration with architects, developers, QA teams, and business stakeholders to ensure successful migration, validation, and production deployment of critical business data.

Key Responsibilities

• Design and execute source-to-target data conversion strategies.
• Develop and maintain ETL processes for large-scale data migration initiatives.
• Create and manage SSIS packages and BIML scripts for automated data processing.
• Perform data extraction, transformation, and loading activities.
• Develop complex SQL queries, stored procedures, views, and database objects.
• Optimize ETL workflows, indexing strategies, and database performance.
• Create C# and .NET utilities to automate data conversion processes.
• Perform data validation, reconciliation, and exception handling.
• Analyze and resolve data discrepancies during migration activities.
• Support mock conversions, UAT testing, and production cutover events.
• Collaborate with technical architects, QA teams, and business stakeholders.
• Ensure compliance with data governance and migration standards.
• Develop conversion documentation, reconciliation reports, and migration artifacts.
• Support post-conversion validation and issue resolution activities.
  
  

Required Skills

• Data Conversion & Data Migration
• ETL Development
• SSIS Package Development
• BIML Scripting
• SQL Server
• T-SQL
• Stored Procedures
• Query Optimization
• Indexing Strategies
• Execution Plan Analysis
• Data Reconciliation
• Source-to-Target Mapping
• Data Validation
• Exception Handling
• Legacy System Migration
• UAT Support
• Production Cutover
• SDLC Methodologies
  
  

Preferred Skills

• C#
• .NET Development
• Conversion Automation
• Pension Administration Systems
• Benefits Administration Platforms
• Large-Scale Data Modernization
• Enterprise Data Governance
• Data Quality Management
• Performance Tuning
  
  

Required Qualifications

• 4 years of data conversion development experience supporting large-scale pension modernization projects.
• 4 years of SSIS package development and BIML scripting experience.
• 4 years of SQL Server and T-SQL development experience.
• 3 years of C# and .NET development experience.
• 3 years of legacy system migration experience.
• 2 years of data reconciliation and validation experience.
• Experience supporting UAT, mock conversions, and production cutovers.
• Experience handling large-scale structured data migration initiatives.
  
  

Preferred Qualifications

• Experience with pension administration systems.
• Experience with benefits modernization projects.
• Experience with enterprise-scale data governance frameworks.
• Experience migrating multi-billion-record legacy data environments.
• Experience supporting complex data transformation initiatives.
  
  

Deliverables

• Source-to-Target Mapping Documents
• ETL Packages
• BIML Scripts
• Data Conversion Programs
• Data Validation Reports
• Reconciliation Reports
• Exception Reports
• Conversion Runbooks
• UAT Support Documentation
• Production Cutover Documentation
• Technical Specifications
• Migration Status Reports
  
  

Education

• Bachelors Degree in Computer Science, Information Systems, Data Engineering, or related field (or equivalent experience).